PL_SRC_TO_VW(SQL View) |
Index Back |
|---|---|
PL_SRC_TO_VW04/17/02 EGS (CN#PL900-1): Removed RESPONSE_AGENT. |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , C.BUS_UNIT_SOURCE , C.SHIP_TYPE_ID FROM PS_TRANS_UNIT_IT A , PS_PL_ITEM_ATTRIB B , PS_PL_SRC_TMPL_DET C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND A.BUS_UNIT_SOURCE = C.BUS_UNIT_SOURCE AND A.SHIP_TYPE_ID = C.SHIP_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | BUS_UNIT_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | Source Business Unit |
| 4 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |