DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 356: BSC_SYS_DIM_LEVELS_VL SL

352: SELECT DISTINCT KL.LEVEL_TABLE_NAME, KL.DIM_LEVEL_INDEX, NVL(KL.PARENT_LEVEL_INDEX, -1), SL.DIM_LEVEL_ID
353: FROM BSC_TAB_INDICATORS TI,
354: BSC_KPIS_B KB,
355: BSC_KPI_DIM_LEVELS_VL KL,
356: BSC_SYS_DIM_LEVELS_VL SL
357: WHERE TI.TAB_ID = p_Tab_Id
358: AND KB.INDICATOR = TI.INDICATOR
359: AND KB.PROTOTYPE_FLAG <> 2
360: AND KL.INDICATOR = KB.INDICATOR

Line 388: , BSC_SYS_DIM_LEVELS_VL SL

384: , BSC_KPIS_B KB
385: , BSC_KPI_DIM_LEVELS_VL KL
386: , BSC_KPI_DIM_GROUPS KG
387: , BSC_SYS_DIM_LEVELS_BY_GROUP SLG
388: , BSC_SYS_DIM_LEVELS_VL SL
389: WHERE TI.TAB_ID = p_Tab_Id
390: AND KB.INDICATOR = TI.INDICATOR
391: AND KB.PROTOTYPE_FLAG <> 2
392: AND KL.INDICATOR = KB.INDICATOR