APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_ONHAND_SALE_SUM_TEMP

Line 57: DELETE PMI_ONHAND_SALE_SUM_TEMP;

53: required because user might have run the purge 0 -zero balance rows
54: For period 2 use period 3 rows and Trnasaction tables
55: For period 1 use period 2 rows and Trnasaction tables
56: */
57: DELETE PMI_ONHAND_SALE_SUM_TEMP;
58:
59: IF l_prev_co_code IS NULL OR l_prev_co_code <> cldr_rec.co_code THEN
60: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR
61: ,CO_CODE

Line 60: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR

56: */
57: DELETE PMI_ONHAND_SALE_SUM_TEMP;
58:
59: IF l_prev_co_code IS NULL OR l_prev_co_code <> cldr_rec.co_code THEN
60: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR
61: ,CO_CODE
62: ,ORGN_CODE
63: ,WHSE_CODE
64: ,PERIOD_ID

Line 136: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR

132: AND loct.whse_code = whs.whse_code
133: AND whs.orgn_code = org.orgn_code );
134: l_prev_co_code := cldr_rec.co_code;
135: ELSE
136: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR
137: ,CO_CODE
138: ,ORGN_CODE
139: ,WHSE_CODE
140: ,PERIOD_ID

Line 239: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR

235: Following statement inserts 0-Zero balance rows if purge 0-zero
236: balance rows routine purges 0 balance rows from ic_LOCT_INV */
237:
238:
239: INSERT INTO PMI_ONHAND_SALE_SUM_TEMP(FISCAL_YEAR
240: ,CO_CODE
241: ,ORGN_CODE
242: ,WHSE_CODE
243: ,PERIOD_ID

Line 307: FROM PMI_ONHAND_SALE_SUM_TEMP) prd_sum,

303: FROM (SELECT whse_code,item_id
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

Line 382: FROM PMI_ONHAND_SALE_SUM_TEMP psum_tmp,

378: ,psum_tmp.GL_FISCAL_YEAR_NAME
379: ,psum_tmp.GL_PERIOD_END_DATE
380: ,psum_tmp.GL_PERIOD_START_DATE
381: ,psum_tmp.MISS_CONV_FACT_CNT
382: FROM PMI_ONHAND_SALE_SUM_TEMP psum_tmp,
383: PMI_PERD_TRANS_SUM_TEMP prd_tr_sum
384: WHERE psum_tmp.whse_code = prd_tr_sum.whse_code (+)
385: AND psum_tmp.item_id = prd_tr_sum.item_id (+);
386: