DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_SYS_DATASETS_B

Line 426: BSC_SYS_DATASETS_B DS

422: WHERE ANALYSIS_GROUP_ID = 1 ) A1,
423: (SELECT INDICATOR, DEFAULT_VALUE
424: FROM BSC_KPI_ANALYSIS_GROUPS
425: WHERE ANALYSIS_GROUP_ID = 2 ) A2,
426: BSC_SYS_DATASETS_B DS
427: WHERE TI.TAB_ID = p_Tab_Id
428: AND KM.INDICATOR = TI.INDICATOR
429: AND KM.DEFAULT_VALUE = 1
430: AND KM.INDICATOR = A0.INDICATOR (+)