APPS.OPI_EDW_RES_UTIL_FOPM_SZ dependencies on OPI_PMI_UOMS_MST

Line 59: OPI_PMI_UOMS_MST UOM

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
61: PCPND.trans_date(+)=RSRC.trans_date and
62: PCPND.resources(+) = RSRC.resources and
63: RSRC.ORGN_CODE = SY.ORGN_CODE AND

Line 117: FROM OPI_PMI_UOMS_MST;

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;
118: CURSOR LOC_PK is
119: SELECT avg(nvl(vsize(ORGN_CODE), 0))
120: FROM SY_ORGN_MST;
121: