APPS.OPI_COLLECTION_HOOK_P dependencies on OPI_EDW_INV_DAILY_STAT_F

Line 26: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_DAILY_STAT_F');

22:
23: COMMIT;
24:
25: -- Gather stats on the daily status fact to optimize joins to it.
26: OPI_COLLECTION_HOOK_P.GATHER_STATS('OPI_EDW_INV_DAILY_STAT_F');
27:
28:
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'));

Line 32: IF FACT_NAME = 'OPI_EDW_INV_DAILY_STAT_F' THEN

28:
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

Line 39: FROM OPI_EDW_INV_DAILY_STAT_F

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
42: END IF;
43:

Line 67: SELECT /*+ROWID(OPI_EDW_INV_DAILY_STAT_F)*/

63: PRD_DATE_FK_KEY,
64: COST_GROUP,
65: NETTABLE_FLAG,
66: ITEM_STATUS)
67: SELECT /*+ROWID(OPI_EDW_INV_DAILY_STAT_F)*/
68: BASE_UOM_FK_KEY,
69: BASE_CURRENCY_FK_KEY,
70: INSTANCE_FK_KEY,
71: INV_ORG_FK_KEY,

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,