|
SELECT DISTINCT a.business_unit , a.prdn_area_code , a.inv_item_id , b.descr FROM ps_sf_prdn_area_it a , PS_MASTER_ITEM_TBL b , ps_set_cntrl_rec d , ps_sf_prdnid_headr e , ps_sf_variances f WHERE a.ma_prdn_id_flg = 'N' AND b.setid = d.setid AND d.recname = 'MASTER_ITEM_TBL' AND d.setcntrlvalue = a.business_unit AND b.inv_item_id = a.inv_item_id AND a.business_unit = e.business_unit AND a.prdn_area_code = e.prdn_area_code AND a.inv_item_id = e.inv_item_id AND e.business_unit = f.business_unit AND e.production_id = f.production_id AND (EXISTS ( SELECT 'x' FROM ps_sf_vars_detail cc WHERE f.business_unit = cc.BUSINESS_UNIT AND f.production_id = cc.production_id) OR EXISTS ( SELECT 'x' FROM ps_sf_cfgvar_det dd WHERE f.business_unit = dd.BUSINESS_UNIT AND f.production_id = dd.PRODUCTION_ID))
|
BUSINESS_UNIT