APPS.EDW_OPI_OPRN_MOPM_SZ dependencies on FM_OPRN_MST

Line 16: FROM FM_OPRN_MST

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
17: WHERE last_update_date between p_from_date and p_to_date);
18: -- dbms_output.put_line ('Number of rows : '||p_num_rows);
19: EXCEPTION
20: WHEN OTHERS THEN

Line 83: FROM FM_OPRN_MST

79: avg(nvl(vsize('OPRN'),0)),
80: avg(nvl(vsize(OPRN_NO),0)),
81: avg(nvl(vsize(OPRN_DESC),0)),
82: avg(nvl(vsize(PROCESS_QTY_UM),0))
83: FROM FM_OPRN_MST
84: WHERE LAST_UPDATE_DATE BETWEEN P_FROM_DATE AND P_TO_DATE;
85:
86:
87: BEGIN