BUSINESS_UNITSHIP_CNTR_IDIN_DLV_CNTID_VW(SQL View) |
Index Back |
|---|---|
Ship Cntr view for deliveries |
| SELECT DISTINCT a.business_unit , a.ship_cntr_id FROM ps_ship_cntr_inv a , PS_IN_DEMAND b WHERE b.demand_source IN ('IN','OM','PL','PO','PL','RT') AND b.in_fulfill_state BETWEEN '20' AND '60' AND %Join(COMMON_KEYS, in_demand b, ship_cntr_inv a) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHIP_CNTR_ID |
Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |