APPS.BSC_MIGRATION dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 687: -- BSC_SYS_DIM_LEVEL_RELS (dim_level_id)

683: ' WHERE '||h_condition||
684: ' )';
685: BSC_APPS.Execute_Immediate(h_sql);
686:
687: -- BSC_SYS_DIM_LEVEL_RELS (dim_level_id)
688: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||
689: ' WHERE dim_level_id IN ('||
690: ' SELECT dim_level_id'||
691: ' FROM bsc_sys_dim_levels_b'||

Line 688: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||

684: ' )';
685: BSC_APPS.Execute_Immediate(h_sql);
686:
687: -- BSC_SYS_DIM_LEVEL_RELS (dim_level_id)
688: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||
689: ' WHERE dim_level_id IN ('||
690: ' SELECT dim_level_id'||
691: ' FROM bsc_sys_dim_levels_b'||
692: ' WHERE '||h_condition||

Line 696: -- BSC_SYS_DIM_LEVEL_RELS (parent_dim_level_id)

692: ' WHERE '||h_condition||
693: ' )';
694: BSC_APPS.Execute_Immediate(h_sql);
695:
696: -- BSC_SYS_DIM_LEVEL_RELS (parent_dim_level_id)
697: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||
698: ' WHERE parent_dim_level_id IN ('||
699: ' SELECT dim_level_id'||
700: ' FROM bsc_sys_dim_levels_b'||

Line 697: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||

693: ' )';
694: BSC_APPS.Execute_Immediate(h_sql);
695:
696: -- BSC_SYS_DIM_LEVEL_RELS (parent_dim_level_id)
697: h_sql := 'DELETE FROM bsc_sys_dim_level_rels'||
698: ' WHERE parent_dim_level_id IN ('||
699: ' SELECT dim_level_id'||
700: ' FROM bsc_sys_dim_levels_b'||
701: ' WHERE '||h_condition||

Line 1126: ' FROM bsc_sys_dim_level_rels'||

1122:
1123:
1124: -- MN Dimension tables
1125: h_sql := 'SELECT DISTINCT relation_col'||
1126: ' FROM bsc_sys_dim_level_rels'||
1127: ' WHERE relation_type = 2';
1128: OPEN h_cursor FOR h_sql;
1129: LOOP
1130: FETCH h_cursor INTO h_table;

Line 1389: ' FROM bsc_sys_dim_level_rels'||

1385: CLOSE h_cursor;
1386:
1387: -- MN Dimension tables
1388: h_sql := 'SELECT DISTINCT relation_col'||
1389: ' FROM bsc_sys_dim_level_rels'||
1390: ' WHERE relation_type = 2';
1391: OPEN h_cursor FOR h_sql;
1392: LOOP
1393: FETCH h_cursor INTO h_table;

Line 1849: FROM bsc_sys_dim_level_rels

1845: FROM bsc_sys_dim_levels_b;
1846:
1847: CURSOR c_mn_dim_tables IS
1848: SELECT DISTINCT relation_col
1849: FROM bsc_sys_dim_level_rels
1850: WHERE relation_type = 2;
1851:
1852: CURSOR c_filter_views IS
1853: SELECT level_view_name

Line 3057: ' FROM BSC_SYS_DIM_LEVEL_RELS@'||g_db_link||

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'||
3057: ' FROM BSC_SYS_DIM_LEVEL_RELS@'||g_db_link||
3058: ' WHERE RELATION_TYPE = 2)';
3059: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3060: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3061:

Line 3504: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVEL_RELS';

3500: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3501: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3502:
3503: g_num_metadata_tables := g_num_metadata_tables + 1;
3504: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVEL_RELS';
3505: g_metadata_tables(g_num_metadata_tables).level := 0;
3506: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3507: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3508: ' SELECT DIM_LEVEL_ID'||

Line 4476: ' FROM bsc_sys_dim_level_rels'||

4472: -- No need to copy input tables for dimensions.
4473:
4474: -- MN Dimension tables
4475: h_sql := 'SELECT DISTINCT relation_col'||
4476: ' FROM bsc_sys_dim_level_rels'||
4477: ' WHERE relation_type = 2';
4478: OPEN h_cursor FOR h_sql;
4479: LOOP
4480: FETCH h_cursor INTO h_table;

Line 6920: ' FROM bsc_sys_dim_level_rels@'||g_db_link||' r,'||

6916:
6917: -- Get invalid mn dimension tables
6918: --Fix bug#4206368: Fix bug#4206368 the dimension table name may be in lowercase!
6919: h_sql := 'SELECT DISTINCT r.relation_col, c.name, p.name'||
6920: ' FROM bsc_sys_dim_level_rels@'||g_db_link||' r,'||
6921: ' bsc_sys_dim_levels_vl@'||g_db_link||' c, '||
6922: ' bsc_sys_dim_levels_vl@'||g_db_link||' p'||
6923: ' WHERE r.relation_type = 2 AND r.dim_level_id = c.dim_level_id (+)'||
6924: ' AND r.parent_dim_level_id = p.dim_level_id (+)'||