LS_KEYPARTY_TYPE_CDRE_INTPARTY1(SQL View) |
Index Back |
|---|---|
Real Estate Internal Party Nm |
| SELECT A.LS_KEY , A.PARTY_TYPE_CD , E.INSTANCE_NAME FROM PS_RE_OPT_RECIP A , PS_SET_CNTRL_REC C , PS_RE_LS D , PS_RE_INTPARTY E WHERE A.LS_KEY = D.LS_KEY AND C.RECNAME = 'RE_INTPARTY' AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.SETID = E.SETID AND A.PARTY_TYPE_CD = E.PARTY_TYPE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | PARTY_TYPE_CD |
Character(20) | VARCHAR2(20) NOT NULL | Party type code (Internal or External) |
| 3 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Instance Name |