APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_PERD_TRANS_SUM_TEMP

Line 201: PMI_PERD_TRANS_SUM_TEMP prd_tr_sum

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;
205:

Line 210: delete PMI_PERD_TRANS_SUM_TEMP ;

206: /* Summarize Transactions at period level this table is used for
207: populating sales data for current period and to calculate period end balance
208: for the previous period. */
209:
210: delete PMI_PERD_TRANS_SUM_TEMP ;
211:
212: INSERT INTO PMI_PERD_TRANS_SUM_TEMP (WHSE_CODE,
213: ITEM_ID,
214: PERD_TRANS_QTY,

Line 212: INSERT INTO PMI_PERD_TRANS_SUM_TEMP (WHSE_CODE,

208: for the previous period. */
209:
210: delete PMI_PERD_TRANS_SUM_TEMP ;
211:
212: INSERT INTO PMI_PERD_TRANS_SUM_TEMP (WHSE_CODE,
213: ITEM_ID,
214: PERD_TRANS_QTY,
215: PERD_SALES_QTY)
216: (

Line 304: FROM PMI_PERD_TRANS_SUM_TEMP

300: ,cldr_rec.period_end_date GL_PERIOD_END_DATE
301: ,cldr_rec.period_start_date GL_PERIOD_START_DATE
302: ,0 MISS_CONV_FACT_CNT
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,

Line 383: PMI_PERD_TRANS_SUM_TEMP prd_tr_sum

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:
387: