APPS.BSC_MIGRATION dependencies on BIS_LEVELS

Line 2782: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_dl, bis_levels pmf_dl'||

2778:
2779: -- Get all the invalid dimension levels. PMF dimension levels not existing in the target
2780: g_num_invalid_pmf_dim_levels := 0;
2781: h_sql := 'SELECT DISTINCT bsc_dl.short_name'||
2782: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_dl, bis_levels pmf_dl'||
2783: ' WHERE bsc_dl.source = :1 AND'||
2784: ' bsc_dl.short_name = pmf_dl.short_name(+) AND'||
2785: ' pmf_dl.short_name IS NULL';
2786: OPEN h_cursor FOR h_sql USING h_pmf;

Line 2800: ' bis_levels pmf_dl'||

2796: -- Get indicators using those invalid dimension levels
2797: h_sql := 'SELECT DISTINCT k.indicator'||
2798: ' FROM bsc_kpi_dim_levels_b@'||g_db_link||' k,'||
2799: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_dl,'||
2800: ' bis_levels pmf_dl'||
2801: ' WHERE k.level_table_name = bsc_dl.level_table_name AND'||
2802: ' bsc_dl.source = :1 AND'||
2803: ' bsc_dl.short_name = pmf_dl.short_name(+) AND'||
2804: ' pmf_dl.short_name IS NULL';

Line 6215: bis_levels spmf_dl

6211: --bug 5099776
6212: CURSOR c_dim_objects (p1 NUMBER, p2 NUMBER, p3 NUMBER, p4 NUMBER) IS
6213: SELECT DISTINCT spmf_dl.level_id
6214: FROM bsc_sys_dim_levels_b sbsc_dl,
6215: bis_levels spmf_dl
6216: WHERE sbsc_dl.short_name = spmf_dl.short_name AND
6217: spmf_dl.created_by NOT IN (p1, p2,p3,p4);
6218:
6219: h_level_id NUMBER;

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 7258: ' FROM bis_levels@'||g_db_link||' l,'||

7254: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dim_levels(h_i));
7255: END LOOP;
7256:
7257: h_sql := 'SELECT DISTINCT ltl.name, l.short_name, f.application_name'||
7258: ' FROM bis_levels@'||g_db_link||' l,'||
7259: ' bis_levels_tl@'||g_db_link||' ltl,'||
7260: ' fnd_application_vl@'||g_db_link||' f'||
7261: ' WHERE l.level_id = ltl.level_id AND'||
7262: ' ltl.language = USERENV(''LANG'') AND'||

Line 7259: ' bis_levels_tl@'||g_db_link||' ltl,'||

7255: END LOOP;
7256:
7257: h_sql := 'SELECT DISTINCT ltl.name, l.short_name, f.application_name'||
7258: ' FROM bis_levels@'||g_db_link||' l,'||
7259: ' bis_levels_tl@'||g_db_link||' ltl,'||
7260: ' fnd_application_vl@'||g_db_link||' f'||
7261: ' WHERE l.level_id = ltl.level_id AND'||
7262: ' ltl.language = USERENV(''LANG'') AND'||
7263: ' l.application_id = f.application_id (+) AND '||h_condition;

Line 7439: ' bis_levels@'||g_db_link||' spmf_dl'||

7435: --We will need to create/update those dimension levels in the target
7436: -- bug 5099776
7437: h_sql := 'SELECT DISTINCT sbsc_dl.short_name, sbsc_dl.source'||
7438: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' sbsc_dl,'||
7439: ' bis_levels@'||g_db_link||' spmf_dl'||
7440: ' WHERE sbsc_dl.short_name = spmf_dl.short_name AND'||
7441: ' spmf_dl.created_by NOT IN (:1, :2, :3, :4)';
7442: OPEN h_cursor FOR h_sql USING 1, 2,120,121;
7443: LOOP

Line 7539: from bis_levels

7535: --check if the dimension level exists in the target
7536: h_count := 0;
7537: select count(short_name)
7538: into h_count
7539: from bis_levels
7540: where short_name = h_dimension_level_short_name;
7541:
7542: IF h_count = 0 THEN
7543: -- Dimension level does not exists, create it