APPS.EDW_OPI_ACTV_MOPM_SZ dependencies on FM_ACTV_MST

Line 11: FROM FM_ACTV_MST FA

7: p_to_date IN DATE,
8: p_num_rows OUT NOCOPY NUMBER) IS
9: BEGIN
10: SELECT count(*) into p_num_rows
11: FROM FM_ACTV_MST FA
12: WHERE FA.last_update_date between p_from_date and p_to_date;
13: -- dbms_output.put_line ('Number of rows : '||p_num_rows);
14: EXCEPTION
15: WHEN OTHERS THEN

Line 45: FROM FM_ACTV_MST

41: avg(nvl(vsize(ACTIVITY_DESC),0)),
42: avg(nvl(vsize(COST_ANALYSIS_CODE),0)),
43: avg(nvl(vsize(ACTIVITY||'-'||'OPM'||'-'),0)) ACT_PK,
44: avg(vsize('ACTV'))
45: FROM FM_ACTV_MST
46: WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;
47: BEGIN
48: OPEN CUR_INSTANCE_SIZE;
49: FETCH CUR_INSTANCE_SIZE INTO x_INSTANCE;