APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on EDW_LOCAL_INSTANCE

Line 56: EDW_LOCAL_INSTANCE inst,

52: WHERE b.completed_ind=1
53: GROUP BY
54: A.ORGN_CODE,a.resources,trunc(trans_date)
55: ) RSRC,
56: EDW_LOCAL_INSTANCE inst,
57: SY_ORGN_MST SY,
58: GL_PLCY_MST GPM,
59: OPI_PMI_UOMS_MST UOM
60: WHERE PCPND.orgn_code(+)= RSRC.ORGN_CODE and

Line 108: FROM EDW_LOCAL_INSTANCE ;

104:
105: CURSOR INST_PK IS
106: SELECT
107: avg(nvl(vsize(instance_code), 0))
108: FROM EDW_LOCAL_INSTANCE ;
109:
110:
111: CURSOR RSRC_PK is
112: SELECT avg(nvl(vsize(RESOURCES||'-OPM'), 0))