[Home] [Help]
1008: CLOSE c_table_columns;
1009:
1010: h_fact_table := NULL;
1011: h_sql := 'SELECT DISTINCT mv_name, data_source, sql_stmt'||
1012: ' FROM bsc_kpi_data_tables'||
1013: ' WHERE indicator = :1 AND periodicity_id = :2'||
1014: ' AND dim_set_id = :3 AND table_name = :4';
1015:
1016: OPEN h_cursor FOR h_sql USING x_indic_code, x_periodicity_id, x_dim_set_id, h_table_name;
1064:
1065: ELSE
1066: -- There is no list button (Common case)
1067: h_sql := 'SELECT mv_name, data_source, sql_stmt'||
1068: ' FROM bsc_kpi_data_tables'||
1069: ' WHERE indicator = :1 AND periodicity_id = :2'||
1070: ' AND dim_set_id = :3 AND level_comb = :4';
1071: OPEN h_cursor FOR h_sql USING x_indic_code, x_periodicity_id, x_dim_set_id, h_level_comb;
1072: FETCH h_cursor INTO h_mv_name, h_data_source, h_sql_stmt;
2665:
2666:
2667: CURSOR c_indic_tables(pIndicator NUMBER, pPeriodicity NUMBER, pDimSetId NUMBER) IS
2668: SELECT level_comb, table_name
2669: FROM bsc_kpi_data_tables
2670: WHERE indicator = pIndicator
2671: AND periodicity_id = pPeriodicity
2672: AND dim_set_id = pDimSetId
2673: AND table_name IS NOT NULL;