APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on EDW_LOCAL_INSTANCE

Line 48: EDW_LOCAL_INSTANCE inst,

44: GL_SETS_OF_BOOKS SOB,
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

Line 141: FROM EDW_LOCAL_INSTANCE ;

137:
138: CURSOR INST_PK IS
139: SELECT
140: avg(nvl(vsize(instance_code), 0))
141: FROM EDW_LOCAL_INSTANCE ;
142:
143:
144: CURSOR CURR_PK is
145: SELECT avg(nvl(vsize(BASE_CURRENCY_CODE), 0))