APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on CR_RSRC_MST

Line 45: CR_RSRC_MST RSRC

41: RSRC.RESOURCES,
42: RSRC.STD_USAGE_UM,
43: GREATEST(ORG.LAST_UPDATE_DATE,RSRC.LAST_UPDATE_DATE) LAST_UPDATE_DATE
44: FROM SY_ORGN_MST ORG,
45: CR_RSRC_MST RSRC
46: ) RS,
47: CR_RSRC_DTL RD
48: WHERE RS.RESOURCES = RD.RESOURCES(+)
49: AND RS.ORGN_CODE = RD.ORGN_CODE(+)

Line 113: FROM CR_RSRC_MST;

109:
110:
111: CURSOR RSRC_PK is
112: SELECT avg(nvl(vsize(RESOURCES||'-OPM'), 0))
113: FROM CR_RSRC_MST;
114:
115: CURSOR UOM_PK is
116: SELECT avg(nvl(vsize(UOM_CODE), 0))
117: FROM OPI_PMI_UOMS_MST;