eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 418: FROM BSC_KPI_ANALYSIS_GROUPS

414: FROM (SELECT DISTINCT KM.INDICATOR, DS.DATASET_ID, DS.SOURCE --, KM.PROTOTYPE_FLAG
415: FROM BSC_TAB_INDICATORS TI,
416: BSC_KPI_ANALYSIS_MEASURES_B KM ,
417: (SELECT INDICATOR, DEFAULT_VALUE
418: FROM BSC_KPI_ANALYSIS_GROUPS
419: WHERE ANALYSIS_GROUP_ID = 0 ) A0,
420: (SELECT INDICATOR, DEFAULT_VALUE
421: FROM BSC_KPI_ANALYSIS_GROUPS
422: WHERE ANALYSIS_GROUP_ID = 1 ) A1,

Line 421: FROM BSC_KPI_ANALYSIS_GROUPS

417: (SELECT INDICATOR, DEFAULT_VALUE
418: FROM BSC_KPI_ANALYSIS_GROUPS
419: WHERE ANALYSIS_GROUP_ID = 0 ) A0,
420: (SELECT INDICATOR, DEFAULT_VALUE
421: FROM BSC_KPI_ANALYSIS_GROUPS
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,

Line 424: FROM BSC_KPI_ANALYSIS_GROUPS

420: (SELECT INDICATOR, DEFAULT_VALUE
421: FROM BSC_KPI_ANALYSIS_GROUPS
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