DBA Data[Home] [Help]

APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on IC_WHSE_MST

Line 127: IC_WHSE_MST whs,

123: ,0 MISS_CONV_FACT_CNT
124: FROM (SELECT whse_code,item_id,sum(LOCT_ONHAND) loct_onhand
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

Line 308: IC_WHSE_MST whs,

304: FROM PMI_PERD_TRANS_SUM_TEMP
305: MINUS
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