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 OPI_EDW_MRGIN_REV_POSTCOLL_FUR

Line 568: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

564: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
565: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');
566: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FD');
567: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
568: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
569: --
570: --
571: -- Clean up section is over
572: --

Line 913: INSERT INTO OPI_EDW_MRGIN_REV_POSTCOLL_FUR

909: ROWNUM < l_chunk_size;
910: IF SQL%ROWCOUNT = 0 THEN
911: EXIT;
912: END IF;
913: INSERT INTO OPI_EDW_MRGIN_REV_POSTCOLL_FUR
914: (MAX_GL_POSTED_DATE,
915: MAX_UNIT_SELLING_PRICE,
916: GL_DATE_FK_KEY,
917: ROW_ID)

Line 945: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

941: AND MAXVALS.SOB_FK_KEY = MRG.SOB_FK_KEY
942: AND LOG.ROW_ID = MRG.ROWID
943: AND LOG.STATUS = 1;
944:
945: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
946:
947: UPDATE OPI_EDW_MARGIN_F MRG
948: SET (INVOICE_DATE
949: ,REVENUE_DATE_FK_KEY

Line 952: ,MAXVALS.MAX_UNIT_SELLING_PRICE FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS WHERE MRG.rowid = MAXVALS.ROW_ID)

948: SET (INVOICE_DATE
949: ,REVENUE_DATE_FK_KEY
950: ,UNIT_SELLING_PRICE)=(SELECT distinct MAXVALS.MAX_GL_POSTED_DATE
951: ,MAXVALS.GL_DATE_FK_KEY
952: ,MAXVALS.MAX_UNIT_SELLING_PRICE FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS WHERE MRG.rowid = MAXVALS.ROW_ID)
953: where EXISTS (SELECT 1
954: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
955: WHERE MRG.rowid = MAXVALS.ROW_ID);
956:

Line 954: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS

950: ,UNIT_SELLING_PRICE)=(SELECT distinct MAXVALS.MAX_GL_POSTED_DATE
951: ,MAXVALS.GL_DATE_FK_KEY
952: ,MAXVALS.MAX_UNIT_SELLING_PRICE FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS WHERE MRG.rowid = MAXVALS.ROW_ID)
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'));

Line 959: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

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;
963: END LOOP;

Line 1318: INSERT INTO OPI_EDW_MRGIN_REV_POSTCOLL_FUR

1314: ROWNUM < l_chunk_size;
1315: IF SQL%ROWCOUNT = 0 THEN
1316: EXIT;
1317: END IF;
1318: INSERT INTO OPI_EDW_MRGIN_REV_POSTCOLL_FUR
1319: (MAX_GL_POSTED_DATE,
1320: MAX_UNIT_SELLING_PRICE,
1321: GL_DATE_FK_KEY,
1322: ROW_ID)

Line 1348: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

1344: AND MAXVALS.SOB_FK_KEY = MRG.SOB_FK_KEY
1345: AND LOG.ROW_ID = MRG.ROWID
1346: AND LOG.STATUS = 1;
1347:
1348: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
1349:
1350: UPDATE OPI_EDW_MARGIN_F MRG
1351: SET (INVOICE_DATE
1352: ,REVENUE_DATE_FK_KEY

Line 1356: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS

1352: ,REVENUE_DATE_FK_KEY
1353: ,UNIT_SELLING_PRICE)=(SELECT distinct MAXVALS.MAX_GL_POSTED_DATE
1354: ,MAXVALS.GL_DATE_FK_KEY
1355: ,MAXVALS.MAX_UNIT_SELLING_PRICE
1356: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
1357: WHERE MRG.rowid = MAXVALS.ROW_ID)
1358: where EXISTS (SELECT 1
1359: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
1360: WHERE MRG.rowid = MAXVALS.ROW_ID);

Line 1359: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS

1355: ,MAXVALS.MAX_UNIT_SELLING_PRICE
1356: FROM OPI_EDW_MRGIN_REV_POSTCOLL_FUR MAXVALS
1357: WHERE MRG.rowid = MAXVALS.ROW_ID)
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'));

Line 1365: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

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
1368: SET STATUS =2
1369: WHERE STATUS = 1;

Line 2205: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');

2201: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
2202: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
2203: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_COGS_LOG');
2204: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
2205: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_REV_POSTCOLL_FUR');
2206: END POST_MARGIN_COLL;
2207: PROCEDURE PRE_MARGIN_COLL IS
2208: BEGIN
2209: /* get global session parameters */