BUSINESS_UNITSSF_SEPA_BU_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT ,B.DESCR ,A.COMMON_ID FROM PS_SSF_COR_BNK_NLD A , PS_BUS_UNIT_TBL_SF B , PS_SSF_BANK_ACCT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SSF_ACCT_SEL_NLD = 'B' AND A.SA_ID_TYPE = 'O' AND C.COMMON_ID = A.COMMON_ID AND C.SA_ID_TYPE = 'O' AND C.ACCT_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |