BUSINESS_UNITAPS_BRANCH_VW(SQL View) |
Index Back |
|---|---|
APS Integration Branch View |
| SELECT I.BUSINESS_UNIT , I.LOCATION , S2.SETID , F.DESCRSHORT , F.DESCR , L.CITY , L.STATE , L.COUNTRY , L.POSTAL , I.IBU_GROUP FROM PS_BUS_UNIT_TBL_IN I , PS_BUS_UNIT_TBL_FS F , PS_LOCATION_TBL L , PS_SET_CNTRL_REC S , PS_SET_CNTRL_REC S2 WHERE I.BUSINESS_UNIT = F.BUSINESS_UNIT AND I.LOCATION = L.LOCATION AND I.BU_STATUS = '1' AND S.SETCNTRLVALUE = I.BUSINESS_UNIT AND S.RECNAME = 'LOCATION_TBL' AND S.SETID = L.SETID AND %EffdtCheck(LOCATION_TBL, L, %currentdatein) AND L.EFF_STATUS = 'A' AND S2.SETCNTRLVALUE = I.BUSINESS_UNIT AND S2.RECNAME = 'MASTER_ITEM_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 10 | IBU_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Unit Group |