BUSINESS_UNITEXT_ORG_IDSSF_SEPA_ORG_VW(SQL View) |
Index Back |
|---|---|
External Org View for mandate |
| SELECT DISTINCT A.BUSINESS_UNIT ,A.COMMON_ID ,D.descr FROM PS_SSF_COR_BNK_NLD A , PS_BUS_UNIT_TBL_SF B , PS_SSF_BANK_ACCT C ,PS_EXT_ORG_TBL D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SSF_ACCT_SEL_NLD = 'B' AND A.SA_ID_TYPE = C.SA_ID_TYPE AND C.COMMON_ID = A.COMMON_ID AND C.ACCT_STATUS = 'A' AND D.EXT_ORG_ID = A.COMMON_ID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_EXT_ORG_TBL D1 WHERE D.EXT_ORG_ID = D1.EXT_ORG_ID AND D1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |