SOURCE_BUS_UNITINTERUNIT_IDINTERUNIT_LINEINV_ITEM_IDLOT_IDN=No
Y=Yes
INV_RECVLIUT_VW(SQL View) |
Index Back |
|---|---|
Inv Recv IUT lot view05/27/04 PWF Change reference from sched_line_no to sched_line_nbr |
| SELECT DISTINCT s.business_unit , s.interunit_id , s.interunit_line , s.inv_item_id , d.inv_lot_id , d.container_id , st.non_own_flag FROM ps_stor_loc_inv st , ps_demand_phys_inv d , PS_IN_DEMAND s WHERE st.business_unit = d.business_unit AND st.storage_area = d.storage_area AND st.stor_level_1 = d.stor_level_1 AND st.stor_level_2 = d.stor_level_2 AND st.stor_level_3 = d.stor_level_3 AND st.stor_level_4 = d.stor_level_4 AND d.business_unit = s.business_unit AND d.demand_source = s.demand_source AND d.source_bus_unit = s.source_bus_unit AND d.order_no = s.order_no AND d.order_int_line_no = s.order_int_line_no AND d.sched_line_nbr = s.sched_line_nbr AND d.inv_item_id = s.inv_item_id AND s.in_fulfill_state >= '50' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | INTERUNIT_LINE |
Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | LOT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 6 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 7 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |