SETIDBUSINESS_UNITCNT_PO_VW(SQL View) |
Index Back |
|---|---|
view for po contractsview for po contracts |
| SELECT A.SETID , B.BUSINESS_UNIT , C.DESCR FROM %Table(SET_CNTRL_GROUP) A , %Table(BUS_UNIT_TBL_PM) B , %Table(BUS_UNIT_TBL_FS) C WHERE A.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REC_GROUP_ID = 'FS_24' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |