APPS.OPI_COLLECTION_HOOK_P dependencies on MLOG$_OPI_EDW_MARGIN_F

Line 701: FROM MLOG$_OPI_EDW_MARGIN_F a

697: ,SHIP_LOCATION_FK_KEY
698: ,UNIT_SELLING_PRICE
699: ,LAST_UPDATE_DATE
700: ,MIN(LAST_UPDATE_DATE) OVER (PARTITION BY M_ROW$$) FIRST_UPDATE_DATE
701: FROM MLOG$_OPI_EDW_MARGIN_F a
702: WHERE a.DMLTYPE$$ IN (''D'',''U'')
703: AND a.GL_PERIOD_FK_KEY IS NOT NULL
704: AND a.GL_PERIOD_FK_KEY <> ''0'' )
705: WHERE

Line 746: OPI_COLLECTION_HOOK_P.GATHER_STATS('MLOG$_OPI_EDW_MARGIN_F');

742: -- Gather table statistics these stats will be used by CBO for query optimisation.
743: --
744: --
745:
746: OPI_COLLECTION_HOOK_P.GATHER_STATS('MLOG$_OPI_EDW_MARGIN_F');
747:
748: --
749: --
750: -- Take the backup of changed rows

Line 754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /*+ ALL_ROWS */ distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);

750: -- Take the backup of changed rows
751: --
752: --
753:
754: insert into OPI_EDW_MARGIN_PERD_ILOG(ROW_ID,STATUS) (select /*+ ALL_ROWS */ distinct m_row$$ ,0 from MLOG$_OPI_EDW_MARGIN_F);
755:
756: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows to be processed to build margin period summary'||SQL%ROWCOUNT);
757: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
758:

Line 1692: -- delete MLOG$_OPI_EDW_MARGIN_F;

1688: ***** doesn't delete it. *****
1689: +****************************************************************************************/
1690:
1691:
1692: -- delete MLOG$_OPI_EDW_MARGIN_F;
1693: LOOP
1694: UPDATE OPI_EDW_MARGIN_PERD_ILOG
1695: SET STATUS =1
1696: WHERE STATUS = 0 AND

Line 2196: OPI_COLLECTION_HOOK_P.TURNC_TAB('MLOG$_OPI_EDW_MARGIN_F');

2192: COMMIT;
2193: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FT');
2194: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_PERD_MARGIN_FUR');
2195: OPI_COLLECTION_HOOK_P.TURNC_TAB('OPI_EDW_MARGIN_PERD_FIR');
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');

Line 2215: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';

2211: g_industry, g_opi_schema)) THEN
2212: RAISE_APPLICATION_ERROR (-20000, 'Unable to get session information.');
2213: END IF;
2214:
2215: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';
2216:
2217: COMMIT;
2218:
2219: END PRE_MARGIN_COLL;

Line 2229: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';

2225: g_industry, g_opi_schema)) THEN
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:

Line 2246: execute immediate 'truncate table ' || g_opi_schema || '.MLOG$_OPI_EDW_MARGIN_F';

2242: g_industry, g_opi_schema)) THEN
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: