APPS.BSC_MIGRATION dependencies on BSC_SYS_DIM_LEVELS_VL

Line 6459: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||

6455: ' tdtl.language = sdtl.language'||
6456: ' )'||
6457: ' WHERE tdtl.dimension_id IN ('||
6458: ' SELECT DISTINCT pmf_d.dimension_id'||
6459: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||
6460: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||
6461: ' bsc_sys_dim_levels_by_group bsc_dlg'||
6462: ' WHERE pmf_do.short_name = bsc_do.short_name AND'||
6463: ' bsc_do.source = :1 AND bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||

Line 6504: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||

6500: ' source_lang = :2'||
6501: ' WHERE d1.language = :3 AND'||
6502: ' d1.dimension_id IN ('||
6503: ' SELECT DISTINCT pmf_d.dimension_id'||
6504: ' FROM bis_levels pmf_do, bsc_sys_dim_levels_vl bsc_do,'||
6505: ' bis_dimensions pmf_d, bsc_sys_dim_groups_tl bsc_d,'||
6506: ' bsc_sys_dim_levels_by_group bsc_dlg'||
6507: ' WHERE pmf_do.short_name = bsc_do.short_name AND'||
6508: ' bsc_do.source = :4 AND bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||

Line 6898: ' FROM bsc_sys_dim_levels_vl@'||g_db_link||

6894: h_num_invalid_dim_objs := 0;
6895:
6896: --Fix bug#4206368: Fix bug#4206368 the dimension table name may be in lowercase!
6897: h_sql := 'SELECT level_table_name, name'||
6898: ' FROM bsc_sys_dim_levels_vl@'||g_db_link||
6899: ' WHERE NVL(source, ''BSC'') = ''BSC'' AND '||
6900: ' UPPER(level_table_name) NOT IN ('||
6901: ' SELECT table_name'||
6902: ' FROM all_tables@'||g_db_link||

Line 6921: ' bsc_sys_dim_levels_vl@'||g_db_link||' c, '||

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 (+)'||
6925: ' AND UPPER(r.relation_col) NOT IN ('||

Line 6922: ' bsc_sys_dim_levels_vl@'||g_db_link||' p'||

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 (+)'||
6925: ' AND UPPER(r.relation_col) NOT IN ('||
6926: ' SELECT table_name'||

Line 8953: l_Dim_Lev_Sht_Name bsc_sys_dim_levels_vl.short_name%TYPE;

8949: l_Id NUMBER;
8950:
8951: l_Calendar_Sht_Name bsc_sys_calendars_b.short_name%TYPE;
8952: l_Dim_Group_Id bsc_sys_dim_groups_vl.dim_group_Id%TYPE;
8953: l_Dim_Lev_Sht_Name bsc_sys_dim_levels_vl.short_name%TYPE;
8954: l_Dim_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;
8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;

Line 9244: bsc_sys_dim_levels_vl

9240: short_name
9241: INTO
9242: l_Dim_Lev_Sht_Name
9243: FROM
9244: bsc_sys_dim_levels_vl
9245: WHERE
9246: dim_level_id = p_New_Dim_Levels(i);
9247: EXIT;
9248: END IF;