[Home] [Help]
APPS.OPI_EDW_JOB_RSRC_FOPM_SZ dependencies on EDW_LOCAL_INSTANCE
Line 47: EDW_LOCAL_INSTANCE inst,
43: FM_OPRN_DTL OPRD,
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
Line 153: FROM EDW_LOCAL_INSTANCE ;
149:
150: CURSOR INST_PK IS
151: SELECT
152: avg(nvl(vsize(instance_code), 0))
153: FROM EDW_LOCAL_INSTANCE ;
154:
155:
156: CURSOR CURR_PK is
157: SELECT avg(nvl(vsize(BASE_CURRENCY_CODE), 0))