APPS.BSC_UPDATE dependencies on BSC_DB_TABLES_RELS

Line 92: ' FROM bsc_db_tables_rels'||

88:
89: /*
90: c_origin_tables t_cursor; -- x_system_table
91: c_origin_tables_sql VARCHAR2(2000) := 'SELECT source_table_name'||
92: ' FROM bsc_db_tables_rels'||
93: ' WHERE table_name = :1';
94: */
95: CURSOR c_origin_tables (p_table_name VARCHAR2) IS
96: SELECT source_table_name

Line 97: FROM bsc_db_tables_rels

93: ' WHERE table_name = :1';
94: */
95: CURSOR c_origin_tables (p_table_name VARCHAR2) IS
96: SELECT source_table_name
97: FROM bsc_db_tables_rels
98: WHERE table_name = p_table_name;
99:
100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
101: h_ret BOOLEAN;

Line 100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;

96: SELECT source_table_name
97: FROM bsc_db_tables_rels
98: WHERE table_name = p_table_name;
99:
100: h_origin_table bsc_db_tables_rels.source_table_name%TYPE;
101: h_ret BOOLEAN;
102:
103: BEGIN
104: h_ret := TRUE;

Line 282: FROM bsc_db_tables_rels

278: SELECT table_name, column_name
279: FROM bsc_db_tables_cols
280: WHERE table_name IN (
281: SELECT table_name
282: FROM bsc_db_tables_rels
283: WHERE source_table_name IN (
284: SELECT table_name
285: FROM bsc_db_tables
286: WHERE table_type = p_table_type

Line 1031: FROM bsc_db_tables_rels r, bsc_db_tables b

1027: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1028: p.calendar_id = p_calendar_id AND
1029: t.table_name IN (
1030: SELECT r.table_name
1031: FROM bsc_db_tables_rels r, bsc_db_tables b
1032: WHERE r.source_table_name = b.table_name and b.table_type = p_table_type0
1033: );
1034:
1035: -- BSC-BIS-DIMENSION: I am fixing this query. We should return the PT tables, that are the

Line 1047: FROM bsc_db_tables_rels r, bsc_db_tables b

1043: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1044: p.calendar_id = p_calendar_id AND
1045: NOT (t.table_name IN (
1046: SELECT r.table_name
1047: FROM bsc_db_tables_rels r, bsc_db_tables b
1048: WHERE r.source_table_name = b.table_name and b.table_type = p_table_type0
1049: ));
1050: */
1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl

Line 1730: ' FROM bsc_db_tables_rels'||

1726:
1727: /*
1728: c_base_table t_cursor; -- x_input_table, 0
1729: c_base_table_sql VARCHAR2(2000) := 'SELECT table_name'||
1730: ' FROM bsc_db_tables_rels'||
1731: ' WHERE UPPER(source_table_name) = UPPER(:1) AND relation_type = :2';
1732: */
1733:
1734: BEGIN

Line 1747: FROM bsc_db_tables_rels

1743:
1744: BEGIN
1745: SELECT table_name
1746: INTO x_base_table
1747: FROM bsc_db_tables_rels
1748: WHERE UPPER(source_table_name) = UPPER(x_input_table) AND relation_type = 0;
1749: EXCEPTION
1750: WHEN NO_DATA_FOUND THEN
1751: x_base_table := NULL;

Line 2415: FROM bsc_db_tables_rels

2411: --h_cursor t_cursor;
2412:
2413: CURSOR c_tables (p_source_table_name VARCHAR2) IS
2414: SELECT table_name
2415: FROM bsc_db_tables_rels
2416: WHERE source_table_name = p_source_table_name;
2417:
2418: h_new_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
2419: h_num_new_tables NUMBER;

Line 2433: ' FROM bsc_db_tables_rels'||

2429:
2430: FOR h_i IN 1 .. x_num_tables LOOP
2431: /*
2432: h_sql := 'SELECT table_name'||
2433: ' FROM bsc_db_tables_rels'||
2434: ' WHERE source_table_name = :1';
2435: --OPEN h_cursor FOR h_sql USING x_tables(h_i);
2436: */
2437: OPEN c_tables(x_tables(h_i));

Line 5614: cursor c1(p_table varchar2) is select table_name from bsc_db_tables_rels where source_table_name=p_table;

5610: x_indicators IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_number,
5611: x_num_indicators IN OUT NOCOPY NUMBER
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;

Line 5704: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||

5700: BSC_APPS.Add_Value_Big_In_Cond(1, x_indicators(h_i));
5701: END LOOP;
5702:
5703: h_sql := 'SELECT DISTINCT source_table_name'||
5704: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||
5705: ' WHERE ('||h_where_indics||') AND k.level_source = :1 '||
5706: ' AND k.level_table_name = r.table_name';
5707:
5708: OPEN h_cursor FOR h_sql USING h_source;

Line 5720: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||

5716: CLOSE h_cursor;
5717:
5718: -- Also include Input tables for MN dimensions
5719: h_sql := 'SELECT DISTINCT source_table_name'||
5720: ' FROM bsc_kpi_dim_levels_vl k, bsc_db_tables_rels r'||
5721: ' WHERE ('||h_where_indics||') AND k.level_source = :1 '||
5722: ' AND k.table_relation = r.table_name';
5723:
5724: OPEN h_cursor FOR h_sql USING h_source;