APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on OPI_PMI_UOMS_MST

Line 49: OPI_PMI_UOMS_MST UOM,

45: GL_PLCY_MST PM,
46: MTL_SYSTEM_ITEMS ITEM_FK_V,
47: IC_WHSE_MST IW,
48: EDW_LOCAL_INSTANCE inst,
49: OPI_PMI_UOMS_MST UOM,
50: GEM_LOOKUPS LKUP
51: WHERE
52: B.PLANT_CODE = OM.ORGN_CODE
53: AND B.PLANT_CODE = PI.ORGN_CODE(+)

Line 151: FROM OPI_PMI_UOMS_MST;

147:
148:
149: CURSOR UOM_PK is
150: SELECT avg(nvl(vsize(UOM_CODE), 0))
151: FROM OPI_PMI_UOMS_MST;
152: CURSOR LOC_PK is
153: SELECT avg(nvl(vsize(ORGN_CODE), 0))
154: FROM SY_ORGN_MST;
155: