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.

[Home] [Help]

APPS.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_MRG_KEYS

Line 561: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');

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

Line 776: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,

772: *** COGS and REVENUE based on Fact name passed by collection Engine. ***
773: +*****************************************************************************************/
774: IF p_Base_fact_name = 'FII_AR_TRX_DIST_F' /* Revenue Fact */
775: THEN
776: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,
777: UOM_FK_KEY,
778: PROJECT_FK_KEY,
779: SHIP_TO_LOC_FK_KEY,
780: BILL_TO_LOC_FK_KEY,

Line 806: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');

802: FROM FII_AR_TRX_DIST_F,OPI_EDW_REV_LOG
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,

Line 858: OPI_EDW_MRG_KEYS KEYS

854: REV.SET_OF_BOOKS_FK_KEY,
855: MAX(GL_DATE) GL_DATE,
856: MAX(UNIT_SELLING_PRICE) UNIT_SELLING_PRICE
857: FROM FII_AR_TRX_DIST_F REV,
858: OPI_EDW_MRG_KEYS KEYS
859: WHERE KEYS.ORDER_LINE_ID = REV.ORDER_LINE_ID
860: AND KEYS.UOM_FK_KEY = REV.UOM_FK_KEY
861: AND KEYS.PROJECT_FK_KEY = REV.PROJECT_FK_KEY
862: AND KEYS.SHIP_TO_LOC_FK_KEY = REV.SHIP_TO_SITE_FK_KEY

Line 969: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,

965: SET STATUS =0;
966: COMMIT;
967: ELSIF p_Base_fact_name = 'OPI_EDW_COGS_F' /*COGS Fact */
968: THEN
969: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,
970: UOM_FK_KEY,
971: PROJECT_FK_KEY,
972: SHIP_TO_LOC_FK_KEY,
973: BILL_TO_LOC_FK_KEY,

Line 999: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');

995: FROM OPI_EDW_COGS_F,
996: OPI_EDW_COGS_LOG
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,

Line 1058: OPI_EDW_MRG_KEYS KEYS

1054: MAX(COGS.COGS_DATE) COGS_DATE,
1055: MAX(COGS.ORDER_NUMBER) ORDER_NUMBER,
1056: MAX(COGS.ORDER_DATE) ORDER_DATE
1057: FROM OPI_EDW_COGS_F COGS,
1058: OPI_EDW_MRG_KEYS KEYS
1059: WHERE KEYS.ORDER_LINE_ID = COGS.ORDER_LINE_ID
1060: AND KEYS.UOM_FK_KEY = COGS.BASE_UOM_FK_KEY
1061: AND KEYS.PROJECT_FK_KEY = COGS.PROJECT_FK_KEY
1062: AND KEYS.SHIP_TO_LOC_FK_KEY = COGS.SHIP_TO_LOC_FK_KEY

Line 1180: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,

1176: SET STATUS =0;
1177: COMMIT;
1178: ELSIF p_base_fact_name = 'OPI_EDW_MARGIN_F' /* if it is a full Refesh */
1179: THEN
1180: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,
1181: UOM_FK_KEY,
1182: PROJECT_FK_KEY,
1183: SHIP_TO_LOC_FK_KEY,
1184: BILL_TO_LOC_FK_KEY,

Line 1209: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');

1205: SET_OF_BOOKS_FK_KEY
1206: FROM FII_AR_TRX_DIST_F
1207: WHERE GL_DATE_FK_KEY <> 0;
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,

Line 1263: OPI_EDW_MRG_KEYS KEYS

1259: REV.SET_OF_BOOKS_FK_KEY,
1260: MAX(GL_DATE) GL_DATE,
1261: MAX(UNIT_SELLING_PRICE) UNIT_SELLING_PRICE
1262: FROM FII_AR_TRX_DIST_F REV,
1263: OPI_EDW_MRG_KEYS KEYS
1264: WHERE KEYS.ORDER_LINE_ID = REV.ORDER_LINE_ID
1265: AND KEYS.UOM_FK_KEY = REV.UOM_FK_KEY
1266: AND KEYS.PROJECT_FK_KEY = REV.PROJECT_FK_KEY
1267: AND KEYS.SHIP_TO_LOC_FK_KEY = REV.SHIP_TO_SITE_FK_KEY

Line 1376: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');

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 ****
1380: **********************************************************************************************/

Line 1382: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,

1378: /*********************************************************************************************
1379: *** Populate COGS data for full refresh ****
1380: **********************************************************************************************/
1381:
1382: INSERT INTO OPI_EDW_MRG_KEYS (ORDER_LINE_ID,
1383: UOM_FK_KEY,
1384: PROJECT_FK_KEY,
1385: SHIP_TO_LOC_FK_KEY,
1386: BILL_TO_LOC_FK_KEY,

Line 1410: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_MRG_KEYS');

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,
1414: UOM_FK_KEY,

Line 1469: OPI_EDW_MRG_KEYS KEYS

1465: MAX(COGS.COGS_DATE) COGS_DATE,
1466: MAX(COGS.ORDER_NUMBER) ORDER_NUMBER,
1467: MAX(COGS.ORDER_DATE) ORDER_DATE
1468: FROM OPI_EDW_COGS_F COGS,
1469: OPI_EDW_MRG_KEYS KEYS
1470: WHERE KEYS.ORDER_LINE_ID = COGS.ORDER_LINE_ID
1471: AND KEYS.UOM_FK_KEY = COGS.BASE_UOM_FK_KEY
1472: AND KEYS.PROJECT_FK_KEY = COGS.PROJECT_FK_KEY
1473: AND KEYS.SHIP_TO_LOC_FK_KEY = COGS.SHIP_TO_LOC_FK_KEY

Line 2202: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MRG_KEYS');

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');
2206: END POST_MARGIN_COLL;