APPS.EDW_OPI_OPRN_MOPM_SZ dependencies on FM_OPRN_CLS

Line 12: FROM FM_OPRN_CLS

8: p_num_rows OUT NOCOPY NUMBER) IS
9: BEGIN
10: SELECT sum(cnt) into p_num_rows
11: FROM (SELECT count(*) cnt
12: FROM FM_OPRN_CLS
13: WHERE last_update_date between p_from_date and p_to_date
14: UNION ALL
15: SELECT count(*) cnt
16: FROM FM_OPRN_MST

Line 72: FROM FM_OPRN_CLS

68: avg(nvl(vsize(OPRN_CLASS||'-'||'-OPM'),0)),
69: avg(nvl(vsize('OPRC'),0)),
70: avg(nvl(vsize(OPRN_CLASS_DESC||'('||OPRN_CLASS||')'),0)),
71: avg(nvl(vsize(OPRN_CLASS_DESC),0))
72: FROM FM_OPRN_CLS
73: WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;
74:
75: -- Cursor to get Operation Level Attribute sizes
76: