APPS.BSC_MIGRATION dependencies on BSC_DB_TABLES_RELS

Line 2081: ' FROM BSC_DB_TABLES_RELS'||

2077: CLOSE h_cursor;
2078:
2079: -- BSC-MV Note: Also Drop all MV used for targets
2080: h_sql := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME'||
2081: ' FROM BSC_DB_TABLES_RELS'||
2082: ' WHERE TABLE_NAME IN ('||
2083: ' SELECT TABLE_NAME'||
2084: ' FROM BSC_KPI_DATA_TABLES'||
2085: ' WHERE TABLE_NAME IS NOT NULL'||

Line 3031: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3027:
3028: -- This table will copy relationships between DATA tables
3029: -- according to the kpis being migrated
3030: g_num_metadata_tables := g_num_metadata_tables + 1;
3031: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
3032: g_metadata_tables(g_num_metadata_tables).level := 3;
3033: g_metadata_tables(g_num_metadata_tables).level_column := 'TABLE_NAME';
3034: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3035: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3040: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3036: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3037:
3038: -- This is for relations between dimension tables and input tables which are system level objects
3039: g_num_metadata_tables := g_num_metadata_tables + 1;
3040: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
3041: g_metadata_tables(g_num_metadata_tables).level := 0;
3042: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3043: g_metadata_tables(g_num_metadata_tables).level_condition := 'TABLE_NAME IN ('||
3044: ' SELECT LEVEL_TABLE_NAME'||

Line 3052: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3048:
3049: -- Add for bug#2728248
3050: -- This is for relations between MN dimension tables and its input tables which are system level objects
3051: g_num_metadata_tables := g_num_metadata_tables + 1;
3052: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
3053: g_metadata_tables(g_num_metadata_tables).level := 0;
3054: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3055: g_metadata_tables(g_num_metadata_tables).level_condition := 'TABLE_NAME IN ('||
3056: ' SELECT RELATION_COL'||

Line 4246: FROM bsc_db_tables t, bsc_db_tables_rels r

4242: ) RETURN BOOLEAN IS
4243:
4244: CURSOR c_table_type IS
4245: SELECT t.table_type
4246: FROM bsc_db_tables t, bsc_db_tables_rels r
4247: WHERE t.table_name = r.source_table_name and
4248: r.table_name = x_table_name;
4249:
4250: h_table_type NUMBER;

Line 4297: ' FROM bsc_db_tables_rels@'||g_db_link||

4293: BSC_APPS.Add_Value_Big_In_Cond(1, x_tables(h_i));
4294: END LOOP;
4295:
4296: h_sql := 'SELECT DISTINCT source_table_name'||
4297: ' FROM bsc_db_tables_rels@'||g_db_link||
4298: ' WHERE '||h_table_cond;
4299: OPEN h_cursor FOR h_sql;
4300:
4301: LOOP

Line 5969: h_sql := 'SELECT table_name FROM bsc_db_tables_rels'||

5965: -- Refresh all MV in the system
5966: -- Get all the base tables
5967: --AW_INTEGRATION: We need to get only the base tables used by MV indicators
5968: h_num_base_tables := 0;
5969: h_sql := 'SELECT table_name FROM bsc_db_tables_rels'||
5970: ' WHERE source_table_name IN ('||
5971: ' SELECT table_name FROM bsc_db_tables'||
5972: ' WHERE table_type = :1)';
5973: OPEN h_cursor FOR h_sql USING 0;

Line 7003: ' from bsc_db_tables_rels@'||g_db_link||

6999: ' where t.indicator = k.indicator and'||
7000: ' (t.table_name = :1 or'||
7001: ' t.table_name in ('||
7002: ' select distinct table_name'||
7003: ' from bsc_db_tables_rels@'||g_db_link||
7004: ' start with source_table_name = :2'||
7005: ' connect by source_table_name = prior table_name))';
7006: OPEN h_cursor FOR h_sql USING h_invalid_tables(h_i), h_invalid_tables(h_i);
7007: LOOP