INV_RECV_OWN_VW

(SQL View)
 Index Back

Receipt view

05/27/04 PWF Change reference from sched_line_no to sched_line_nbr

SELECT DISTINCT inv.interunit_id , st.non_own_flag FROM PS_MASTER_ITEM_TBL itm , ps_demand_phys_inv phys , ps_stor_loc_inv st , ps_in_demand inv , ps_inv_item_uom conv , ps_set_cntrl_rec sc WHERE sc.recname = 'MASTER_ITEM_TBL' AND sc.setcntrlvalue = inv.business_unit AND phys.business_unit = inv.business_unit AND phys.demand_source = inv.demand_source AND phys.source_bus_unit = inv.source_bus_unit AND phys.order_no = inv.order_no AND phys.order_int_line_no = inv.order_int_line_no AND phys.sched_line_nbr = inv.sched_line_nbr AND phys.demand_line_no = inv.demand_line_no AND phys.inv_item_id = inv.inv_item_id AND Phys.qty_picked > 0 AND st.business_unit = phys.business_unit AND st.storage_area = phys.storage_area AND st.stor_level_1 = phys.stor_level_1 AND st.stor_level_2 = phys.stor_level_2 AND st.stor_level_3 = phys.stor_level_3 AND st.stor_level_4 = phys.stor_level_4 AND inv.interunit_id <> ' ' AND itm.setid = sc.setid AND inv.inv_item_id = itm.inv_item_id AND inv.in_fulfill_state BETWEEN '60' AND '70' AND inv.interunit_flg = 'Y' AND inv.interunit_stat = 'I' AND conv.setid = itm.setid AND conv.inv_item_id = itm.inv_item_id AND conv.unit_of_measure = inv.unit_measure_ship GROUP BY inv.interunit_id,st.non_own_flag

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
2 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

Y/N Table Edit