APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on OPI_PMI_UOMS_MST

Line 48: OPI_PMI_UOMS_MST UOM

44: MTL_SYSTEM_ITEMS ITEM_FK_V,
45: IC_WHSE_MST IW,
46: GL_SETS_OF_BOOKS SOB,
47: EDW_LOCAL_INSTANCE inst,
48: OPI_PMI_UOMS_MST UOM
49: WHERE
50: BH.BATCH_ID = BR.BATCH_ID
51: AND BH.BATCH_ID = BD.BATCH_ID
52: AND BH.PLANT_CODE = OM.ORGN_CODE

Line 170: FROM OPI_PMI_UOMS_MST;

166: FROM CR_RSRC_MST;
167:
168: CURSOR UOM_PK is
169: SELECT avg(nvl(vsize(UOM_CODE), 0))
170: FROM OPI_PMI_UOMS_MST;
171: CURSOR LOC_PK is
172: SELECT avg(nvl(vsize(ORGN_CODE), 0))
173: FROM SY_ORGN_MST;
174: