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_UPDATE_COLOR dependencies on BSC_KPI_DIM_LEVELS_B

Line 2437: FROM bsc_kpi_dim_levels_b

2433: h_key_belong_to_list BOOLEAN;
2434:
2435: cursor c_key_item ( pIndicator number, pDimSetId number, pLevelPkCol varchar2) is
2436: SELECT default_key_value
2437: FROM bsc_kpi_dim_levels_b
2438: WHERE indicator = pIndicator
2439: AND dim_set_id = pDimSetId
2440: AND level_pk_col = pLevelPkCol
2441: AND default_key_value IS NOT NULL ;

Line 2761: FROM bsc_kpi_dim_levels_b

2757: TYPE t_cursor IS REF CURSOR;
2758:
2759: cursor c_drill_index(pIndicator number, pDimSetId number, pLevelPkCol varchar2) is
2760: SELECT dim_level_index
2761: FROM bsc_kpi_dim_levels_b
2762: WHERE indicator = pIndicator
2763: AND dim_set_id = pDimSetId
2764: AND level_pk_col = pLevelPkCol;
2765:

Line 2768: FROM bsc_kpi_dim_levels_b

2764: AND level_pk_col = pLevelPkCol;
2765:
2766: cursor c_key_items(pIndicator number, pDimSetId number, pStatus varchar2) is
2767: SELECT dim_level_index
2768: FROM bsc_kpi_dim_levels_b
2769: WHERE indicator = pIndicator
2770: AND dim_set_id = pDimSetId
2771: AND status = pStatus
2772: AND default_key_value IS NOT NULL ;

Line 2776: FROM bsc_kpi_dim_levels_b

2772: AND default_key_value IS NOT NULL ;
2773:
2774: cursor c_indic_drills(pIndicator number, pDImSetId number, pStatus varchar2) is
2775: SELECT dim_level_index
2776: FROM bsc_kpi_dim_levels_b
2777: WHERE indicator = pIndicator
2778: AND dim_set_id = pDImSetId
2779: AND status = pStatus
2780: ORDER BY dim_level_index ;