APPS.BSC_UPDATE dependencies on BSC_KPI_DATA_TABLES

Line 1054: FROM bsc_kpi_data_tables k, bsc_sys_periodicities p

1050: */
1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1052: CURSOR c_sum_tables_mv (p_calendar_id NUMBER) IS
1053: SELECT DISTINCT k.projection_data
1054: FROM bsc_kpi_data_tables k, bsc_sys_periodicities p
1055: WHERE k.periodicity_id = p.periodicity_id AND
1056: p.calendar_id = p_calendar_id AND
1057: projection_data IS NOT NULL;
1058:

Line 1874: 'FROM bsc_kpi_data_tables '||

1870: BSC_APPS.Add_Value_Big_In_Cond(1, h_system_tables(h_i));
1871: END LOOP;
1872:
1873: h_sql := 'SELECT DISTINCT indicator '||
1874: 'FROM bsc_kpi_data_tables '||
1875: 'WHERE '||h_lst_where;
1876:
1877: OPEN h_cursor FOR h_sql;
1878: FETCH h_cursor INTO h_indicator;

Line 5542: ' FROM bsc_kpi_data_tables'||

5538: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));
5539: END LOOP;
5540:
5541: h_sql := 'SELECT table_name'||
5542: ' FROM bsc_kpi_data_tables'||
5543: ' WHERE ('||h_where_indics||') AND table_name IS NOT NULL';
5544:
5545: OPEN h_cursor FOR h_sql;
5546: FETCH h_cursor INTO h_table_name;

Line 5616: cursor c2(p_table varchar2) is select distinct indicator from bsc_kpi_data_tables where table_name=p_table;

5612: )return boolean is
5613: --
5614: cursor c1(p_table varchar2) is select table_name from bsc_db_tables_rels where source_table_name=p_table;
5615: --
5616: cursor c2(p_table varchar2) is select distinct indicator from bsc_kpi_data_tables where table_name=p_table;
5617: --
5618: l_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
5619: l_num_tables number;
5620: l_indicator number;

Line 5835: bsc_kpi_data_tables k,

5831: SET current_period = (
5832: SELECT DISTINCT
5833: NVL(MIN(t.current_period), p.current_period)
5834: FROM
5835: bsc_kpi_data_tables k,
5836: bsc_db_tables t
5837: WHERE
5838: k.table_name = t.table_name AND
5839: k.indicator = p.indicator AND

Line 5870: bsc_kpi_data_tables k,

5866: SET current_period = (
5867: SELECT DISTINCT
5868: NVL(MIN(t.current_period), p.current_period)
5869: FROM
5870: bsc_kpi_data_tables k,
5871: bsc_db_tables t
5872: WHERE
5873: k.table_name = t.table_name AND
5874: k.indicator = p.indicator AND

Line 6381: ' from bsc_kpi_data_tables'||

6377: h_sql := 'select indicator, name'||
6378: ' from bsc_kpis_vl'||
6379: ' where prototype_flag NOT IN (:1, :2, :3) and'||
6380: ' indicator in (select indicator'||
6381: ' from bsc_kpi_data_tables'||
6382: ' where '||h_where_cond||
6383: ' )';
6384: h_i := 0;
6385: OPEN h_cursor FOR h_sql USING 0, 6, 7;