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_COGSPOSTCOLL_FUR

Line 567: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

563: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_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

Line 1114: INSERT INTO OPI_EDW_MRGIN_COGSPOSTCOLL_FUR

1110: ROWNUM < l_chunk_size;
1111: IF SQL%ROWCOUNT = 0 THEN
1112: EXIT;
1113: END IF;
1114: INSERT INTO OPI_EDW_MRGIN_COGSPOSTCOLL_FUR
1115: (MAX_ORDER_DATE,
1116: SHIP_INV_LOCATOR_FK_KEY ,
1117: COGS_DATE_FK_KEY,
1118: MAX_ORDER_NUMBER,

Line 1148: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

1144: AND MAXVALS.SOB_FK_KEY = MRG.SOB_FK_KEY
1145: AND LOG.ROW_ID = MRG.ROWID
1146: AND LOG.STATUS = 1;
1147:
1148: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');
1149:
1150: UPDATE OPI_EDW_MARGIN_F MRG
1151: SET (ORDER_DATE
1152: ,ORDER_NO

Line 1160: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS

1156: ,MAXVALS.MAX_ORDER_NUMBER
1157: ,MAXVALS.MAX_COGS_DATE
1158: ,MAXVALS.SHIP_INV_LOCATOR_FK_KEY
1159: ,MAXVALS.COGS_DATE_FK_KEY
1160: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1161: WHERE MRG.rowid = MAXVALS.ROW_ID)
1162: where EXISTS (SELECT 1
1163: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1164: WHERE MRG.rowid = MAXVALS.ROW_ID);

Line 1163: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS

1159: ,MAXVALS.COGS_DATE_FK_KEY
1160: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1161: WHERE MRG.rowid = MAXVALS.ROW_ID)
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'));

Line 1169: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

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

Line 1525: INSERT INTO OPI_EDW_MRGIN_COGSPOSTCOLL_FUR

1521: ROWNUM < l_chunk_size;
1522: IF SQL%ROWCOUNT = 0 THEN
1523: EXIT;
1524: END IF;
1525: INSERT INTO OPI_EDW_MRGIN_COGSPOSTCOLL_FUR
1526: (MAX_ORDER_DATE,
1527: SHIP_INV_LOCATOR_FK_KEY ,
1528: COGS_DATE_FK_KEY,
1529: MAX_ORDER_NUMBER,

Line 1559: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

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
1563: ,ORDER_NO

Line 1571: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS

1567: ,MAXVALS.MAX_ORDER_NUMBER
1568: ,MAXVALS.MAX_COGS_DATE
1569: ,MAXVALS.SHIP_INV_LOCATOR_FK_KEY
1570: ,MAXVALS.COGS_DATE_FK_KEY
1571: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1572: WHERE MRG.rowid = MAXVALS.ROW_ID)
1573: where EXISTS (SELECT 1
1574: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1575: WHERE MRG.rowid = MAXVALS.ROW_ID);

Line 1574: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS

1570: ,MAXVALS.COGS_DATE_FK_KEY
1571: FROM OPI_EDW_MRGIN_COGSPOSTCOLL_FUR MAXVALS
1572: WHERE MRG.rowid = MAXVALS.ROW_ID)
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'));

Line 1580: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

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

Line 2204: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRGIN_COGSPOSTCOLL_FUR');

2200: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_REV_LOG');
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