BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
SHIP_IDSHIPCNT_INV_VW4(SQL View) |
Index Back |
|---|---|
Shipping Containers View 2/* mmt 04/02/04 Data model changes */ |
| SELECT DISTINCT a.business_unit , b.ship_id FROM ps_ship_cntr_inv a , PS_IN_DEMAND b WHERE a.business_unit = b.business_unit AND a.demand_source = b.demand_source AND a.source_bus_unit = b.source_bus_unit AND a.order_no = b.order_no AND a.order_int_line_no = b.order_int_line_no AND a.sched_line_nbr = b.sched_line_nbr AND a.inv_item_id = b.inv_item_id AND a.demand_line_no = b.demand_line_no AND b.ship_id <> ' ' AND b.in_fulfill_state >= '50' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 2 | SHIP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |