eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PMI_BUILD_ONHANDSALE_SUM dependencies on PMI_ONHAND_SALE_SUM

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

Line 391: DELETE PMI_ONHAND_SALE_SUM

387:
388: /* Delete data from Summary table for currently processed data
389: we will replace this rows using next insert statement */
390:
391: DELETE PMI_ONHAND_SALE_SUM
392: WHERE co_Code = cldr_rec.co_code
393: AND period_set_name = cldr_rec.period_Set_name
394: AND period_name = cldr_rec.period_name;
395:

Line 397: INSERT INTO PMI_ONHAND_SALE_SUM(FISCAL_YEAR

393: AND period_set_name = cldr_rec.period_Set_name
394: AND period_name = cldr_rec.period_name;
395:
396:
397: INSERT INTO PMI_ONHAND_SALE_SUM(FISCAL_YEAR
398: ,CO_CODE
399: ,ORGN_CODE
400: ,WHSE_CODE
401: ,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;

Line 480: l_conv_uom pmi_onhand_sale_sum.convertible_uom%TYPE;

476: l_last_trns_eff_date DATE;
477: l_start_population_date DATE;
478: buff32k VARCHAR2(32767);
479: l_mesg VARCHAR2(2000);
480: l_conv_uom pmi_onhand_sale_sum.convertible_uom%TYPE;
481: l_conv_uom1 pmi_onhand_sale_sum.convertible_uom%TYPE;
482: l_table_owner VARCHAR2(40);
483: -- Cursors and cursor row type variables
484: CURSOR cur_bisopm_onhand IS

Line 481: l_conv_uom1 pmi_onhand_sale_sum.convertible_uom%TYPE;

477: l_start_population_date DATE;
478: buff32k VARCHAR2(32767);
479: l_mesg VARCHAR2(2000);
480: l_conv_uom pmi_onhand_sale_sum.convertible_uom%TYPE;
481: l_conv_uom1 pmi_onhand_sale_sum.convertible_uom%TYPE;
482: l_table_owner VARCHAR2(40);
483: -- Cursors and cursor row type variables
484: CURSOR cur_bisopm_onhand IS
485: SELECT LAST_RUN_DATE,ATTR1

Line 487: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';

483: -- Cursors and cursor row type variables
484: CURSOR cur_bisopm_onhand IS
485: SELECT LAST_RUN_DATE,ATTR1
486: FROM PMI_SUMMARY_LOG_TABLE
487: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
488: CURSOR cur_last_trans_eff_date IS
489: SELECT min(trans_date)
490: from (Select (min(trans_date)) trans_date
491: from IC_TRAN_PND

Line 508: FROM PMI_ONHAND_SALE_SUM

504: IF cur_bisopm_onhand%NOTFOUND THEN
505: CLOSE cur_bisopm_onhand;
506: BEGIN
507: SELECT 1 into rows_exists
508: FROM PMI_ONHAND_SALE_SUM
509: WHERE ROWNUM = 1;
510: errbuf := FND_MESSAGE.get_string('PMI','PMI_SUMM_POPULATION_ERR');
511: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf );
512: retcode:= '2';

Line 537: DELETE pmi_onhand_sale_sum;

533: /* Delete data from summary table. now we need to populate using new conversion UOM */
534: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_VAL_CHG') ||'-'||
535: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_VAL_CHG');
536: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );
537: DELETE pmi_onhand_sale_sum;
538: COMMIT;
539: l_last_run_date := NULL;
540: END IF;
541: OPEN cur_last_trans_eff_date;

Line 550: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';

546: BEGIN
547: UPDATE PMI_SUMMARY_LOG_TABLE
548: SET LAST_RUN_DATE = l_log_end_date,
549: ATTR1 = PV_conv_uom
550: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
551: IF SQL%ROWCOUNT = 0 THEN
552: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
553: VALUES ('PMI_ONHAND_SALE_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
554: END IF;

Line 553: VALUES ('PMI_ONHAND_SALE_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);

549: ATTR1 = PV_conv_uom
550: WHERE summary_table = 'PMI_ONHAND_SALE_SUM';
551: IF SQL%ROWCOUNT = 0 THEN
552: INSERT INTO PMI_SUMMARY_LOG_TABLE (SUMMARY_TABLE,LAST_RUN_DATE,ATTR1,ATTR2,ATTR3,ATTR4,ATTR5,ATTR6)
553: VALUES ('PMI_ONHAND_SALE_SUM',l_log_end_date,PV_conv_uom,null,null,null,null,null);
554: END IF;
555: END;
556: SELECT TABLE_OWNER INTO l_table_owner
557: FROM USER_SYNONYMS

Line 558: WHERE SYNONYM_NAME = 'PMI_ONHAND_SALE_SUM';

554: END IF;
555: END;
556: SELECT TABLE_OWNER INTO l_table_owner
557: FROM USER_SYNONYMS
558: WHERE SYNONYM_NAME = 'PMI_ONHAND_SALE_SUM';
559: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_ONHAND_SALE_SUM');
560: ELSE
561: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||
562: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_PROF_MISS');

Line 559: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_ONHAND_SALE_SUM');

555: END;
556: SELECT TABLE_OWNER INTO l_table_owner
557: FROM USER_SYNONYMS
558: WHERE SYNONYM_NAME = 'PMI_ONHAND_SALE_SUM';
559: FND_STATS.GATHER_TABLE_STATS(l_table_owner, 'PMI_ONHAND_SALE_SUM');
560: ELSE
561: buff32k := FND_MESSAGE.get_number('PMI','PMI_CONV_UOM_PROF_MISS') ||'-'||
562: FND_MESSAGE.get_string('PMI','PMI_CONV_UOM_PROF_MISS');
563: FND_FILE.PUT_LINE(FND_FILE.LOG, buff32k );