|
SELECT a.business_unit , a.inv_item_id , SUM(a.qty_base) FROM ps_physical_inv a , ps_stor_loc_inv b , PS_BUS_UNIT_TBL_IN c WHERE b.business_unit = a.business_unit AND b.storage_area = a.storage_area AND b.stor_level_1 = a.stor_level_1 AND b.stor_level_2 = a.stor_level_2 AND b.stor_level_3 = a.stor_level_3 AND b.stor_level_4 = a.stor_level_4 AND b.wip_loc_flg = 'Y' AND c.business_unit = b.business_unit AND (a.avail_status = '1' OR (a.avail_status IN ('2','3') AND c.incl_quar_avail = 'Y')) GROUP BY a.business_unit, a.inv_item_id
|