APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on IC_ITEM_MST

Line 129: IC_ITEM_MST iim

125: from IC_LOCT_INV
126: group by whse_code,item_id) loct,
127: IC_WHSE_MST whs,
128: SY_ORGN_MST org,
129: IC_ITEM_MST iim
130: WHERE org.co_code = cldr_rec.co_code
131: AND loct.item_id = iim.item_id
132: AND loct.whse_code = whs.whse_code
133: AND whs.orgn_code = org.orgn_code );

Line 310: IC_ITEM_MST iim

306: SELECT WHSE_CODE,ITEM_ID
307: FROM PMI_ONHAND_SALE_SUM_TEMP) prd_sum,
308: IC_WHSE_MST whs,
309: SY_ORGN_MST org,
310: IC_ITEM_MST iim
311: WHERE co_code = cldr_rec.co_code
312: AND prd_sum.item_id = iim.item_id
313: AND prd_sum.whse_code = whs.whse_code
314: AND whs.orgn_code = org.orgn_code );