BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW
SHIP_IDSHPSR_ID_INV_VW(SQL View) |
Index Back |
|---|---|
Ship ID from Ship Serial Order05/27/04 PWF Change reference from sched_line_no to sched_line_nbr |
| SELECT DISTINCT b.business_unit , b.ship_id FROM ps_ship_serial_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 <> ' ' |
| # | 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 |