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.OPI_COLLECTION_HOOK_P dependencies on EDW_OWB_COLLECTION_UTIL

Line 29: EDW_OWB_COLLECTION_UTIL.write_to_log_file('get distinct row ids from IDS Snapshot Log log table');

25: -- Gather stats on the daily status fact to optimize joins to it.
26: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_DAILY_STAT_F');
27:
28:
29: EDW_OWB_COLLECTION_UTIL.write_to_log_file('get distinct row ids from IDS Snapshot Log log table');
30: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
31: /* get distinct row ids from IDS Snapshot Log log table */
32: IF FACT_NAME = 'OPI_EDW_INV_DAILY_STAT_F' THEN
33: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)

Line 30: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

26: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_DAILY_STAT_F');
27:
28:
29: EDW_OWB_COLLECTION_UTIL.write_to_log_file('get distinct row ids from IDS Snapshot Log log table');
30: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
31: /* get distinct row ids from IDS Snapshot Log log table */
32: IF FACT_NAME = 'OPI_EDW_INV_DAILY_STAT_F' THEN
33: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)
34: SELECT DISTINCT M_ROW$$

Line 44: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows changed in IDS'||SQL%ROWCOUNT);

40: WHERE period_flag = 1 ; -- add this condition to minimize join below for the
41: -- initial load
42: END IF;
43:
44: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows changed in IDS'||SQL%ROWCOUNT);
45: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
46:
47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');
48:

Line 45: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

41: -- initial load
42: END IF;
43:
44: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows changed in IDS'||SQL%ROWCOUNT);
45: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
46:
47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');
48:
49: /* Move Non Attribute Columns into Tep Table 1 */

Line 51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');

47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');
48:
49: /* Move Non Attribute Columns into Tep Table 1 */
50:
51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');
52: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53:
54:
55: INSERT INTO OPI_EDW_IDS_NET_CHG(

Line 52: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

48:
49: /* Move Non Attribute Columns into Tep Table 1 */
50:
51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');
52: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53:
54:
55: INSERT INTO OPI_EDW_IDS_NET_CHG(
56: BASE_UOM_FK_KEY,

Line 93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);

89: LOT_FK_KEY,
90: PRD_DATE_FK_KEY,
91: COST_GROUP;
92:
93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);
94: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
95:
96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');
97:

Line 94: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

90: PRD_DATE_FK_KEY,
91: COST_GROUP;
92:
93: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populated Non key attributes into OPI_EDW_IDS_NET_CHG Table'||SQL%ROWCOUNT);
94: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
95:
96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');
97:
98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */

Line 100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');

96: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_NET_CHG');
97:
98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */
99:
100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');
101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
102:
103: INSERT INTO OPI_EDW_IPS_NET_CHG
104: ( ROW_ID

Line 101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

97:
98: /* Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG */
99:
100: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Move net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ');
101: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
102:
103: INSERT INTO OPI_EDW_IPS_NET_CHG
104: ( ROW_ID
105: ,AVG_INT_QTY

Line 313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);

309: IPS.LOT_FK_KEY=WK2.LOT_FK_KEY AND
310: IPS.PRD_DATE_FK_KEY=WK2.PRD_DATE_FK_KEY AND
311: NVL(IPS.COST_GROUP,'0') = NVL(WK2.COST_GROUP,'0');
312:
313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);
314: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
315:
316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');
317:

Line 314: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

310: IPS.PRD_DATE_FK_KEY=WK2.PRD_DATE_FK_KEY AND
311: NVL(IPS.COST_GROUP,'0') = NVL(WK2.COST_GROUP,'0');
312:
313: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved net change data from IPS and Temp OPI_EDW_IPS_NET_CHG ' ||SQL%ROWCOUNT);
314: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
315:
316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');
317:
318: /* Delete IPS table for Changed rows */

Line 320: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleting Changed rows from IPS ');

316: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IPS_NET_CHG');
317:
318: /* Delete IPS table for Changed rows */
319:
320: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleting Changed rows from IPS ');
321: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
322:
323: DELETE OPI_EDW_INV_PERD_STAT_F
324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);

Line 321: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

317:
318: /* Delete IPS table for Changed rows */
319:
320: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleting Changed rows from IPS ');
321: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
322:
323: DELETE OPI_EDW_INV_PERD_STAT_F
324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);
325:

Line 326: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleted Changed rows from IPS ' ||SQL%ROWCOUNT);

322:
323: DELETE OPI_EDW_INV_PERD_STAT_F
324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);
325:
326: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleted Changed rows from IPS ' ||SQL%ROWCOUNT);
327: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
328:
329:
330: /* insert data from temp Table to IPS */

Line 327: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

323: DELETE OPI_EDW_INV_PERD_STAT_F
324: WHERE ROWID IN (SELECT ROW_ID FROM OPI_EDW_IPS_NET_CHG);
325:
326: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Deleted Changed rows from IPS ' ||SQL%ROWCOUNT);
327: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
328:
329:
330: /* insert data from temp Table to IPS */
331:

Line 332: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moving Data from Work table to IPS');

328:
329:
330: /* insert data from temp Table to IPS */
331:
332: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moving Data from Work table to IPS');
333: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
334:
335:
336: INSERT INTO OPI_EDW_INV_PERD_STAT_F (

Line 333: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

329:
330: /* insert data from temp Table to IPS */
331:
332: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moving Data from Work table to IPS');
333: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
334:
335:
336: INSERT INTO OPI_EDW_INV_PERD_STAT_F (
337: AVG_INT_QTY

Line 534: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved Data from Work table to IPS' ||SQL%ROWCOUNT);

530: ,WIP_ISSUE_VAL_B
531: ,WIP_ISSUE_VAL_G
532: FROM OPI_EDW_IPS_NET_CHG;
533:
534: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved Data from Work table to IPS' ||SQL%ROWCOUNT);
535: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
536:
537: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_PERD_STAT_F');
538:

Line 535: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

531: ,WIP_ISSUE_VAL_G
532: FROM OPI_EDW_IPS_NET_CHG;
533:
534: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Moved Data from Work table to IPS' ||SQL%ROWCOUNT);
535: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
536:
537: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_PERD_STAT_F');
538:
539: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';

Line 708: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FDLG '||SQL%ROWCOUNT);

704: AND a.GL_PERIOD_FK_KEY <> ''0'' )
705: WHERE
706: FIRST_UPDATE_DATE = LAST_UPDATE_DATE';
707:
708: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FDLG '||SQL%ROWCOUNT);
709: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
710: commit;
711: --
712: --

Line 709: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

705: WHERE
706: FIRST_UPDATE_DATE = LAST_UPDATE_DATE';
707:
708: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FDLG '||SQL%ROWCOUNT);
709: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
710: commit;
711: --
712: --
713: -- Gather table statistics these stats will be used by CBO for query optimisation.

Line 721: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FD '||SQL%ROWCOUNT);

717: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MARGIN_PERD_FDLG');
718:
719: insert into OPI_EDW_MARGIN_PERD_FD (select rowid ,0 from OPI_EDW_MARGIN_PERD_FDLG);
720:
721: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FD '||SQL%ROWCOUNT);
722: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
723: commit;
724:
725: --

Line 722: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

718:
719: insert into OPI_EDW_MARGIN_PERD_FD (select rowid ,0 from OPI_EDW_MARGIN_PERD_FDLG);
720:
721: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into OPI_EDW_MARGIN_PERD_FD '||SQL%ROWCOUNT);
722: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
723: commit;
724:
725: --
726: --

Line 756: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be processed to build margin period summary'||SQL%ROWCOUNT);

752: --
753:
754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /*+ ALL_ROWS */ distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);
755:
756: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be processed to build margin period summary'||SQL%ROWCOUNT);
757: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
758:
759: --
760: --

Line 757: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

753:
754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /*+ ALL_ROWS */ distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);
755:
756: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be processed to build margin period summary'||SQL%ROWCOUNT);
757: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
758:
759: --
760: --
761: -- Gather table statistics these stats will be used by CBO for query optimisation.

Line 957: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);

953: where EXISTS (SELECT 1
954: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
955: WHERE MRG.rowid = MAXVALS.ROW_ID);
956:
957: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
958: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
959: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
960: UPDATE OPI_EDW_MARGIN_PERD_ILOG
961: SET STATUS =2

Line 958: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

954: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
955: WHERE MRG.rowid = MAXVALS.ROW_ID);
956:
957: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
958: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
959: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
960: UPDATE OPI_EDW_MARGIN_PERD_ILOG
961: SET STATUS =2
962: WHERE STATUS = 1;

Line 1166: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);

1162: where EXISTS (SELECT 1
1163: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1164: WHERE MRG.rowid = MAXVALS.ROW_ID);
1165:
1166: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1167: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1168:
1169: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1170:

Line 1167: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1163: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1164: WHERE MRG.rowid = MAXVALS.ROW_ID);
1165:
1166: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1167: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1168:
1169: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1170:
1171: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1362: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);

1358: where EXISTS (SELECT 1
1359: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
1360: WHERE MRG.rowid = MAXVALS.ROW_ID);
1361:
1362: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1363: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1364:
1365: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
1366:

Line 1363: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1359: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
1360: WHERE MRG.rowid = MAXVALS.ROW_ID);
1361:
1362: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1363: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1364:
1365: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
1366:
1367: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1409: EDW_OWB_COLLECTION_UTIL.write_to_log_file('1 sqlcount ddd ' || SQL%rowcount);

1405: top_model_item_fk_key,
1406: BASE_CURRENCY_FK_KEY,
1407: GL_SET_OF_BOOKS_FK_KEY
1408: FROM OPI_EDW_COGS_F;
1409: EDW_OWB_COLLECTION_UTIL.write_to_log_file('1 sqlcount ddd ' || SQL%rowcount);
1410: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');
1411:
1412: INSERT INTO OPI_EDW_MRG_MAX_VALUES
1413: (ORDER_LINE_ID,

Line 1512: EDW_OWB_COLLECTION_UTIL.write_to_log_file('2 sqlcount ddd ' || SQL%rowcount);

1508: AND MAXVALS.OPERATING_UNIT_FK_KEY = COGS.OPERATING_UNIT_FK_KEY
1509: AND MAXVALS.ITEM_ORG_FK_KEY = COGS.top_model_item_fk_key
1510: AND MAXVALS.BASE_CURRENCY_FK_KEY = COGS.BASE_CURRENCY_FK_KEY
1511: AND MAXVALS.GL_SET_OF_BOOKS_FK_KEY= COGS.GL_SET_OF_BOOKS_FK_KEY;
1512: EDW_OWB_COLLECTION_UTIL.write_to_log_file('2 sqlcount ddd ' || SQL%rowcount);
1513: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
1514:
1515:
1516:

Line 1558: EDW_OWB_COLLECTION_UTIL.write_to_log_file('3 sqlcount ddd ' || SQL%rowcount);

1554: AND MAXVALS.BASE_CURRENCY_FK_KEY = MRG.BASE_CURRENCY_FK_KEY
1555: AND MAXVALS.SOB_FK_KEY = MRG.SOB_FK_KEY
1556: AND LOG.ROW_ID = MRG.ROWID
1557: AND LOG.STATUS = 1;
1558: EDW_OWB_COLLECTION_UTIL.write_to_log_file('3 sqlcount ddd ' || SQL%rowcount);
1559: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1560:
1561: UPDATE OPI_EDW_MARGIN_F MRG
1562: SET (ORDER_DATE

Line 1577: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);

1573: where EXISTS (SELECT 1
1574: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1575: WHERE MRG.rowid = MAXVALS.ROW_ID);
1576:
1577: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1578: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1579:
1580: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1581:

Line 1578: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1574: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1575: WHERE MRG.rowid = MAXVALS.ROW_ID);
1576:
1577: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from revenue fact'||SQL%ROWCOUNT);
1578: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1579:
1580: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1581:
1582: UPDATE OPI_EDW_MARGIN_PERD_ILOG

Line 1590: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from cogs fact'||SQL%ROWCOUNT);

1586: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1587: SET STATUS =0;
1588: COMMIT;
1589:
1590: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from cogs fact'||SQL%ROWCOUNT);
1591: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1592:
1593: END IF;
1594: /****************************************************************************************+

Line 1591: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1587: SET STATUS =0;
1588: COMMIT;
1589:
1590: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F from cogs fact'||SQL%ROWCOUNT);
1591: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1592:
1593: END IF;
1594: /****************************************************************************************+
1595: *** Find Max of SHIP_DATE and INVOICE_DATE based on that populate Margin Date FK Key ***

Line 1684: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F generated period FK KEY'||SQL%ROWCOUNT);

1680: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1681: SET STATUS =0;
1682: COMMIT;
1683:
1684: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F generated period FK KEY'||SQL%ROWCOUNT);
1685: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1686: /***************************************************************************************+
1687: ***** Delete Snapshot log of margin. Since this on derived fact collection engine *****
1688: ***** doesn't delete it. *****

Line 1685: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1681: SET STATUS =0;
1682: COMMIT;
1683:
1684: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows udated OPI_EDW_MARGIN_F generated period FK KEY'||SQL%ROWCOUNT);
1685: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1686: /***************************************************************************************+
1687: ***** Delete Snapshot log of margin. Since this on derived fact collection engine *****
1688: ***** doesn't delete it. *****
1689: +****************************************************************************************/

Line 1701: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows in processing'||SQL%ROWCOUNT);

1697: ROWNUM < l_chunk_size;
1698: IF SQL%ROWCOUNT = 0 THEN
1699: EXIT;
1700: END IF;
1701: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows in processing'||SQL%ROWCOUNT);
1702: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1703: COMMIT;
1704: INSERT INTO OPI_EDW_PERD_MARGIN_FT(
1705: ITEM_ORG_FK_KEY

Line 1702: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1698: IF SQL%ROWCOUNT = 0 THEN
1699: EXIT;
1700: END IF;
1701: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows in processing'||SQL%ROWCOUNT);
1702: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1703: COMMIT;
1704: INSERT INTO OPI_EDW_PERD_MARGIN_FT(
1705: ITEM_ORG_FK_KEY
1706: ,OPERATING_UNIT_FK_KEY

Line 1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);

1794: ,USER_FK3_KEY
1795: ,USER_FK2_KEY
1796: ,USER_FK1_KEY);
1797:
1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);
1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
1801:
1802:

Line 1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1795: ,USER_FK2_KEY
1796: ,USER_FK1_KEY);
1797:
1798: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FT '||SQL%ROWCOUNT);
1799: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1800: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FT');
1801:
1802:
1803: INSERT INTO OPI_EDW_PERD_MARGIN_FUR(

Line 1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);

1854: AND NVL(MRGF.USER_FK3_KEY,0)=NVL(MRGFT.USER_FK3_KEY,0)
1855: AND NVL(MRGF.USER_FK2_KEY,0)=NVL(MRGFT.USER_FK2_KEY,0)
1856: AND NVL(MRGF.USER_FK1_KEY,0)=NVL(MRGFT.USER_FK1_KEY,0));
1857:
1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);
1859: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1860: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
1861:
1862:

Line 1859: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1855: AND NVL(MRGF.USER_FK2_KEY,0)=NVL(MRGFT.USER_FK2_KEY,0)
1856: AND NVL(MRGF.USER_FK1_KEY,0)=NVL(MRGFT.USER_FK1_KEY,0));
1857:
1858: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows moved to OPI_EDW_PERD_MARGIN_FUR '||SQL%ROWCOUNT);
1859: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1860: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_FUR');
1861:
1862:
1863: COMMIT;

Line 1870: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be inserted into Margin period summary '||SQL%ROWCOUNT);

1866: SELECT /*+ ALL_ROWS */ ROWID ROW_ID FROM OPI_EDW_PERD_MARGIN_FT
1867: MINUS
1868: SELECT /*+ ALL_ROWS */ ROW_ID ROW_ID FROM OPI_EDW_PERD_MARGIN_FUR);
1869:
1870: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be inserted into Margin period summary '||SQL%ROWCOUNT);
1871:
1872: l_insert := SQL%ROWCOUNT;
1873:
1874: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

Line 1874: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1870: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be inserted into Margin period summary '||SQL%ROWCOUNT);
1871:
1872: l_insert := SQL%ROWCOUNT;
1873:
1874: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1875: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MARGIN_PERD_FIR');
1876:
1877:
1878: IF l_insert <> 0 THEN

Line 1954: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into Margin period summary '||SQL%ROWCOUNT);

1950: ,USER_MEASURE1
1951: FROM OPI_EDW_PERD_MARGIN_FT ,
1952: OPI_EDW_MARGIN_PERD_FIR
1953: WHERE OPI_EDW_PERD_MARGIN_FT.ROWID = OPI_EDW_MARGIN_PERD_FIR.ROW_ID;
1954: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into Margin period summary '||SQL%ROWCOUNT);
1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1956: END IF;
1957: COMMIT;
1958:

Line 1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1951: FROM OPI_EDW_PERD_MARGIN_FT ,
1952: OPI_EDW_MARGIN_PERD_FIR
1953: WHERE OPI_EDW_PERD_MARGIN_FT.ROWID = OPI_EDW_MARGIN_PERD_FIR.ROW_ID;
1954: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows inserted into Margin period summary '||SQL%ROWCOUNT);
1955: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1956: END IF;
1957: COMMIT;
1958:
1959: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_PERD_MARGIN_F');

Line 1995: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows updated in Margin period summary '||SQL%ROWCOUNT);

1991: WHERE MRGF.ROWID = MRGFU.ROW_ID1)
1992: WHERE EXISTS (SELECT 1
1993: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1994: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
1995: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows updated in Margin period summary '||SQL%ROWCOUNT);
1996: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1997: COMMIT;
1998: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1999: SET STATUS =2

Line 1996: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1992: WHERE EXISTS (SELECT 1
1993: FROM OPI_EDW_PERD_MARGIN_FUR MRGFU
1994: WHERE MRGF.ROWID = MRGFU.ROW_ID1);
1995: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows updated in Margin period summary '||SQL%ROWCOUNT);
1996: EDW_OWB_COLLECTION_UTIL.write_to_log_file('end Time '||to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1997: COMMIT;
1998: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1999: SET STATUS =2
2000: WHERE STATUS = 1;