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_MRG_MAX_VALUES

Line 560: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');

556: -- Clean up Temporary work tables data. if previous run failed these tables will have data.
557: --
558: --
559: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');
560: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
561: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
562: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
563: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
564: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');

Line 807: INSERT INTO OPI_EDW_MRG_MAX_VALUES

803: WHERE GL_DATE_FK_KEY <> 0
804: AND FII_AR_TRX_DIST_F.ROWID = OPI_EDW_REV_LOG.row_id;
805:
806: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');
807: INSERT INTO OPI_EDW_MRG_MAX_VALUES
808: (ORDER_LINE_ID,
809: UOM_FK_KEY,
810: PROJECT_FK_KEY,
811: SHIP_TO_LOC_FK_KEY,

Line 903: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');

899: AND MAXVALS.FUNCTIONAL_CURRENCY_FK_KEY = REV.FUNCTIONAL_CURRENCY_FK_KEY
900: AND MAXVALS.SET_OF_BOOKS_FK_KEY = REV.SET_OF_BOOKS_FK_KEY
901: AND REV.GL_DATE_FK_KEY <> 0;
902:
903: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
904:
905: LOOP
906: UPDATE OPI_EDW_MARGIN_PERD_ILOG
907: SET STATUS =1

Line 927: OPI_EDW_MRG_MAX_VALUES MAXVALS

923: MRG.ROWID
924: FROM
925: OPI_EDW_MARGIN_PERD_ILOG LOG,
926: OPI_EDW_MARGIN_F MRG,
927: OPI_EDW_MRG_MAX_VALUES MAXVALS
928: WHERE
929: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID
930: AND MAXVALS.UOM_FK_KEY = MRG.UOM_FK_KEY
931: AND MAXVALS.PROJECT_FK_KEY = MRG.PROJECT_FK_KEY

Line 1001: INSERT INTO OPI_EDW_MRG_MAX_VALUES

997: WHERE OPI_EDW_COGS_F.ROWID = OPI_EDW_COGS_LOG.row_id;
998:
999: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');
1000:
1001: INSERT INTO OPI_EDW_MRG_MAX_VALUES
1002: (ORDER_LINE_ID,
1003: UOM_FK_KEY,
1004: PROJECT_FK_KEY,
1005: SHIP_TO_LOC_FK_KEY,

Line 1102: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');

1098: AND MAXVALS.ITEM_ORG_FK_KEY = COGS.top_model_item_fk_key
1099: AND MAXVALS.BASE_CURRENCY_FK_KEY = COGS.BASE_CURRENCY_FK_KEY
1100: AND MAXVALS.GL_SET_OF_BOOKS_FK_KEY= COGS.GL_SET_OF_BOOKS_FK_KEY;
1101:
1102: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
1103:
1104:
1105:
1106: LOOP

Line 1130: OPI_EDW_MRG_MAX_VALUES MAXVALS

1126: MRG.ROWID
1127: FROM
1128: OPI_EDW_MARGIN_PERD_ILOG LOG,
1129: OPI_EDW_MARGIN_F MRG,
1130: OPI_EDW_MRG_MAX_VALUES MAXVALS
1131: WHERE
1132: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID
1133: AND MAXVALS.UOM_FK_KEY = MRG.UOM_FK_KEY
1134: AND MAXVALS.PROJECT_FK_KEY = MRG.PROJECT_FK_KEY

Line 1212: INSERT INTO OPI_EDW_MRG_MAX_VALUES

1208:
1209: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');
1210:
1211:
1212: INSERT INTO OPI_EDW_MRG_MAX_VALUES
1213: (ORDER_LINE_ID,
1214: UOM_FK_KEY,
1215: PROJECT_FK_KEY,
1216: SHIP_TO_LOC_FK_KEY,

Line 1308: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');

1304: AND MAXVALS.FUNCTIONAL_CURRENCY_FK_KEY = REV.FUNCTIONAL_CURRENCY_FK_KEY
1305: AND MAXVALS.SET_OF_BOOKS_FK_KEY = REV.SET_OF_BOOKS_FK_KEY
1306: AND REV.GL_DATE_FK_KEY <> 0;
1307:
1308: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');
1309:
1310: LOOP
1311: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1312: SET STATUS =1

Line 1330: OPI_EDW_MRG_MAX_VALUES MAXVALS

1326: MRG.ROWID
1327: FROM
1328: OPI_EDW_MARGIN_PERD_ILOG LOG,
1329: OPI_EDW_MARGIN_F MRG,
1330: OPI_EDW_MRG_MAX_VALUES MAXVALS
1331: WHERE
1332: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID
1333: AND MAXVALS.UOM_FK_KEY = MRG.UOM_FK_KEY
1334: AND MAXVALS.PROJECT_FK_KEY = MRG.PROJECT_FK_KEY

Line 1375: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');

1371: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1372: SET STATUS =0;
1373: COMMIT;
1374:
1375: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');
1376: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');
1377:
1378: /*********************************************************************************************
1379: *** Populate COGS data for full refresh ****

Line 1412: INSERT INTO OPI_EDW_MRG_MAX_VALUES

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,
1414: UOM_FK_KEY,
1415: PROJECT_FK_KEY,
1416: SHIP_TO_LOC_FK_KEY,

Line 1513: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_MAX_VALUES');

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

Line 1541: OPI_EDW_MRG_MAX_VALUES MAXVALS

1537: MRG.ROWID
1538: FROM
1539: OPI_EDW_MARGIN_PERD_ILOG LOG,
1540: OPI_EDW_MARGIN_F MRG,
1541: OPI_EDW_MRG_MAX_VALUES MAXVALS
1542: WHERE
1543: MAXVALS.ORDER_LINE_ID = MRG.ORDER_LINE_ID
1544: AND MAXVALS.UOM_FK_KEY = MRG.UOM_FK_KEY
1545: AND MAXVALS.PROJECT_FK_KEY = MRG.PROJECT_FK_KEY

Line 2201: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_MAX_VALUES');

2197: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FDLG');
2198: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FD');
2199: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_ILOG');
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');