APPS.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_IDS_OPICOLLB_LOG

Line 19: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';

15: g_industry, g_opi_schema)) THEN
16: RAISE_APPLICATION_ERROR (-20000, 'Unable to get session information.');
17: END IF;
18:
19: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';
20: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';
21: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';
22:
23: COMMIT;

Line 33: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)

29: EDW_OWB_COLLECTION_UTIL.write_to_log_file('get distinct row ids from IDS Snapshot Log log table');
30: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
31: /* get distinct row ids from IDS Snapshot Log log table */
32: IF FACT_NAME = 'OPI_EDW_INV_DAILY_STAT_F' THEN
33: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)
34: SELECT DISTINCT M_ROW$$
35: FROM MLOG$_OPI_EDW_INV_DAILY_ST ;
36: ELSIF FACT_NAME = 'OPI_EDW_INV_PERD_STAT_F' THEN
37: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)

Line 37: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)

33: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)
34: SELECT DISTINCT M_ROW$$
35: FROM MLOG$_OPI_EDW_INV_DAILY_ST ;
36: ELSIF FACT_NAME = 'OPI_EDW_INV_PERD_STAT_F' THEN
37: INSERT INTO OPI_EDW_IDS_OPICOLLB_LOG (ROW_ID)
38: SELECT ROWID
39: FROM OPI_EDW_INV_DAILY_STAT_F
40: WHERE period_flag = 1 ; -- add this condition to minimize join below for the
41: -- initial load

Line 47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');

43:
44: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Number of rows changed in IDS'||SQL%ROWCOUNT);
45: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
46:
47: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_IDS_OPICOLLB_LOG');
48:
49: /* Move Non Attribute Columns into Tep Table 1 */
50:
51: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Populate Non key attributes into OPI_EDW_IDS_NET_CHG Table');

Line 79: FROM OPI_EDW_INV_DAILY_STAT_F IDS, OPI_EDW_IDS_OPICOLLB_LOG CHANGED

75: PRD_DATE_FK_KEY,
76: COST_GROUP,
77: MAX(NETTABLE_FLAG),
78: MAX(ITEM_STATUS)
79: FROM OPI_EDW_INV_DAILY_STAT_F IDS, OPI_EDW_IDS_OPICOLLB_LOG CHANGED
80: WHERE IDS.ROWID = CHANGED.ROW_ID
81: AND IDS.PERIOD_FLAG = 1
82: GROUP BY
83: BASE_UOM_FK_KEY,

Line 539: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';

535: EDW_OWB_COLLECTION_UTIL.write_to_log_file(to_char(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
536:
537: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_PERD_STAT_F');
538:
539: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_OPICOLLB_LOG';
540: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IDS_NET_CHG';
541: execute immediate 'truncate table ' || g_opi_schema || '.OPI_EDW_IPS_NET_CHG';
542:
543: COMMIT;