|
SELECT d.business_unit , d.demand_source , d.source_bus_unit , d.order_no , d.order_int_line_no , d.sched_line_nbr , d.inv_item_id , d.demand_line_no , d.location , d.destin_bu , d.ship_to_cust_id , d.ship_id , d.load_id , d.carrier_id , d.ship_type_id , d.route_cd , j.wave_cd , m.descr , %DatePart(d.sched_dttm) , %TimePart(d.sched_dttm) , d.unit_of_measure , d.unit_measure_ship , d.qty_allocated , d.qty_requested , d.qty_picked , d.qty_shipped_conv , d.qty_ship_base , d.qty_pack_base , d.ship_dttm , i.inv_item_weight , i.inv_item_volume , i.unit_measure_wt , i.unit_measure_vol , m.unit_measure_std , d.pick_batch_id , d.hold_flag , d.qty_backorder , d.in_fulfill_state , d.single_ship_flag , d.parent_prod_id , '31' , d.optional_ship , d.lot_alloc_flg , d.in_defer_depletion , d.delivery_id FROM ps_in_demand d , PS_MASTER_ITEM_TBL m , ps_inv_items i , ps_wave_route_inv j WHERE m.setid = ( SELECT setid FROM ps_set_cntrl_rec sc WHERE setcntrlvalue = d.business_unit AND recname = 'MASTER_ITEM_TBL') AND m.inv_item_id = d.inv_item_id AND i.setid = ( SELECT setid FROM ps_set_cntrl_rec sc WHERE setcntrlvalue = d.business_unit AND recname = 'INV_ITEMS') AND i.inv_item_id = d.inv_item_id AND i.effdt = ( SELECT MAX(effdt) FROM ps_inv_items i2 WHERE i2.inv_item_id = i.inv_item_id AND i2.setid = i.setid AND i2.effdt <= %CurrentDateIn) AND EXISTS ( SELECT 'X' FROM ps_wave_route_inv k WHERE d.business_unit = j.business_unit AND j.business_unit = k.business_unit AND j.wave_cd = k.wave_cd AND d.route_cd = j.route_cd AND j.route_cd = k.route_cd)
|
BUSINESS_UNIT