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_LOCK dependencies on BSC_KPIS_VL

Line 448: from bsc_kpis_vl

444: h_num_input_tables NUMBER;
445:
446: CURSOR c_mod_cal_kpis IS
447: select distinct indicator
448: from bsc_kpis_vl
449: where calendar_id in (
450: select calendar_id
451: from bsc_sys_calendars_b
452: where fiscal_change = 1

Line 485: ' FROM bsc_kpis_vl'||

481: -- Lock indicators with prototype flag 6 or 7
482: -- If Loader is running only for some specific indicators then we need to lock
483: -- only those indicators
484: h_sql := 'SELECT DISTINCT indicator'||
485: ' FROM bsc_kpis_vl'||
486: ' WHERE prototype_flag IN (6,7)';
487: IF BSC_UPDATE.g_kpi_mode THEN
488: IF BSC_UPDATE.g_num_indicators > 0 THEN
489: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

Line 1137: ' FROM bsc_kpis_vl'||

1133: BEGIN
1134: h_num_objects := 0;
1135:
1136: h_sql := 'SELECT DISTINCT indicator'||
1137: ' FROM bsc_kpis_vl'||
1138: ' WHERE prototype_flag IN (6,7)';
1139: IF BSC_UPDATE.g_kpi_mode THEN
1140: IF BSC_UPDATE.g_num_indicators > 0 THEN
1141: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');