DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 355: BSC_KPI_DIM_LEVELS_VL KL,

351: CURSOR c_Common_Levels IS
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

Line 385: , BSC_KPI_DIM_LEVELS_VL KL

381: , KL.PARENT_LEVEL_INDEX
382: , KL.DEFAULT_KEY_VALUE
383: FROM BSC_TAB_INDICATORS TI
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