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_REV_LOG

Line 802: FROM FII_AR_TRX_DIST_F,OPI_EDW_REV_LOG

798: ORGANIZATION_FK_KEY,
799: PARENT_ITEM_FK_KEY,
800: FUNCTIONAL_CURRENCY_FK_KEY,
801: SET_OF_BOOKS_FK_KEY
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');

Line 804: AND FII_AR_TRX_DIST_F.ROWID = OPI_EDW_REV_LOG.row_id;

800: FUNCTIONAL_CURRENCY_FK_KEY,
801: SET_OF_BOOKS_FK_KEY
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,

Line 2200: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_REV_LOG');

2196: OPI_COLLECTION_HOOK_P.TURNC_TAB('MLOG$_OPI_EDW_MARGIN_F');
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');

Line 2230: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_REV_LOG';

2226: RAISE_APPLICATION_ERROR (-20000, 'Unable to get session information.');
2227: END IF;
2228:
2229: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';
2230: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_REV_LOG';
2231:
2232: COMMIT;
2233:
2234: INSERT INTO OPI_EDW_REV_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_FII_AR_TRX_DIST_F);

Line 2234: INSERT INTO OPI_EDW_REV_LOG (select /+ ALL_ROWS / distinct m_row$$,0 from MLOG$_FII_AR_TRX_DIST_F);

2230: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_REV_LOG';
2231:
2232: COMMIT;
2233:
2234: INSERT INTO OPI_EDW_REV_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_FII_AR_TRX_DIST_F);
2235: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_REV_LOG');
2236: END;
2237: PROCEDURE POST_COGS_COLL IS
2238: BEGIN

Line 2235: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_REV_LOG');

2231:
2232: COMMIT;
2233:
2234: INSERT INTO OPI_EDW_REV_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_FII_AR_TRX_DIST_F);
2235: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_REV_LOG');
2236: END;
2237: PROCEDURE POST_COGS_COLL IS
2238: BEGIN
2239: