APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_ONHAND_SALE_SUM_CUR_TEMP

Line 200: FROM PMI_ONHAND_SALE_SUM_CUR_TEMP next_prd,

196: ,cldr_rec.year_name GL_FISCAL_YEAR_NAME
197: ,cldr_rec.period_end_date GL_PERIOD_END_DATE
198: ,cldr_rec.period_start_date GL_PERIOD_START_DATE
199: ,0 MISS_CONV_FACT_CNT
200: FROM PMI_ONHAND_SALE_SUM_CUR_TEMP next_prd,
201: PMI_PERD_TRANS_SUM_TEMP prd_tr_sum
202: WHERE next_prd.whse_code = prd_tr_sum.whse_code (+)
203: AND next_prd.item_id = prd_tr_sum.item_id (+);
204: END IF;

Line 316: delete PMI_ONHAND_SALE_SUM_CUR_TEMP ;

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 );
315:
316: delete PMI_ONHAND_SALE_SUM_CUR_TEMP ;
317:
318: INSERT INTO PMI_ONHAND_SALE_SUM_CUR_TEMP(FISCAL_YEAR
319: ,CO_CODE
320: ,ORGN_CODE

Line 318: INSERT INTO PMI_ONHAND_SALE_SUM_CUR_TEMP(FISCAL_YEAR

314: AND whs.orgn_code = org.orgn_code );
315:
316: delete PMI_ONHAND_SALE_SUM_CUR_TEMP ;
317:
318: INSERT INTO PMI_ONHAND_SALE_SUM_CUR_TEMP(FISCAL_YEAR
319: ,CO_CODE
320: ,ORGN_CODE
321: ,WHSE_CODE
322: ,PERIOD_ID

Line 465: FROM PMI_ONHAND_SALE_SUM_CUR_TEMP;

461: ,GL_FISCAL_YEAR_NAME
462: ,GL_PERIOD_END_DATE
463: ,GL_PERIOD_START_DATE
464: ,MISS_CONV_FACT_CNT
465: FROM PMI_ONHAND_SALE_SUM_CUR_TEMP;
466: commit;
467: END LOOP;
468: CLOSE check_cldr_for_perd_bal;
469: END populate_summary;