DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_KPI_DIM_GROUPS

Line 260: FROM BSC_KPI_DIM_GROUPS A

256: -- as common dimension level
257:
258: CURSOR c_tabs_to_check is
259: SELECT DISTINCT B.TAB_ID
260: FROM BSC_KPI_DIM_GROUPS A
261: ,BSC_TAB_INDICATORS B
262: WHERE A.INDICATOR = B.INDICATOR
263: AND A.DIM_GROUP_ID = p_Dimension_Id;
264:

Line 386: , BSC_KPI_DIM_GROUPS KG

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
390: AND KB.INDICATOR = TI.INDICATOR

Line 455: BSC_KPI_DIM_GROUPS KDG,

451: ( SELECT KB.INDICATOR, KDS.DIM_SET_ID, SL.DIM_LEVEL_ID, SL.SOURCE
452: FROM BSC_TAB_INDICATORS TI,
453: BSC_KPIS_B KB,
454: BSC_KPI_DIM_SETS_VL KDS,
455: BSC_KPI_DIM_GROUPS KDG,
456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,
457: BSC_SYS_DIM_LEVELS_B SL
458: WHERE TI.TAB_ID = p_Tab_Id
459: AND KB.INDICATOR = TI.INDICATOR