APPS.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_COGS_LOG

Line 996: OPI_EDW_COGS_LOG

992: top_model_item_fk_key,
993: BASE_CURRENCY_FK_KEY,
994: GL_SET_OF_BOOKS_FK_KEY
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:

Line 997: WHERE OPI_EDW_COGS_F.ROWID = OPI_EDW_COGS_LOG.row_id;

993: BASE_CURRENCY_FK_KEY,
994: GL_SET_OF_BOOKS_FK_KEY
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

Line 2203: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_COGS_LOG');

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;
2207: PROCEDURE PRE_MARGIN_COLL IS

Line 2247: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_COGS_LOG';

2243: RAISE_APPLICATION_ERROR (-20000, 'Unable to get session information.');
2244: END IF;
2245:
2246: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';
2247: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_COGS_LOG';
2248:
2249: COMMIT;
2250:
2251: INSERT INTO OPI_EDW_COGS_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_OPI_EDW_COGS_F);

Line 2251: INSERT INTO OPI_EDW_COGS_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_OPI_EDW_COGS_F);

2247: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_COGS_LOG';
2248:
2249: COMMIT;
2250:
2251: INSERT INTO OPI_EDW_COGS_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_OPI_EDW_COGS_F);
2252: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_COGS_LOG');
2253: END;
2254: PROCEDURE GATHER_STATS(P_TABLE_NAME VARCHAR2) IS
2255: l_TABLE_OWNER VARCHAR2(32);

Line 2252: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_COGS_LOG');

2248:
2249: COMMIT;
2250:
2251: INSERT INTO OPI_EDW_COGS_LOG (select /*+ ALL_ROWS */ distinct m_row$$,0 from MLOG$_OPI_EDW_COGS_F);
2252: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_COGS_LOG');
2253: END;
2254: PROCEDURE GATHER_STATS(P_TABLE_NAME VARCHAR2) IS
2255: l_TABLE_OWNER VARCHAR2(32);
2256: BEGIN