eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MIGRATION dependencies on BSC_SYS_DIM_LEVELS_B

Line 472: ' FROM bsc_sys_dim_levels_b'||

468: END LOOP;
469:
470: -- Fix dimension tables. They are TL tables too.
471: h_sql := 'SELECT level_table_name'||
472: ' FROM bsc_sys_dim_levels_b'||
473: ' WHERE nvl(source, ''BSC'') = ''BSC''';
474: OPEN h_cursor FOR h_sql;
475: LOOP
476: FETCH h_cursor INTO h_table_name;

Line 645: -- BSC_SYS_DIM_LEVELS_BY_GROUP

641: FOR h_i IN 1 .. g_num_invalid_pmf_dimensions LOOP
642: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dimensions(h_i));
643: END LOOP;
644:
645: -- BSC_SYS_DIM_LEVELS_BY_GROUP
646: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||
647: ' WHERE dim_group_id IN ('||
648: ' SELECT dim_group_id'||
649: ' FROM bsc_sys_dim_groups_tl'||

Line 646: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||

642: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dimensions(h_i));
643: END LOOP;
644:
645: -- BSC_SYS_DIM_LEVELS_BY_GROUP
646: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||
647: ' WHERE dim_group_id IN ('||
648: ' SELECT dim_group_id'||
649: ' FROM bsc_sys_dim_groups_tl'||
650: ' WHERE '||h_condition||

Line 669: -- BSC_SYS_DIM_LEVELS_BY_GROUP

665: FOR h_i IN 1 .. g_num_invalid_pmf_dim_levels LOOP
666: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dim_levels(h_i));
667: END LOOP;
668:
669: -- BSC_SYS_DIM_LEVELS_BY_GROUP
670: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||
671: ' WHERE dim_level_id IN ('||
672: ' SELECT dim_level_id'||
673: ' FROM bsc_sys_dim_levels_b'||

Line 670: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||

666: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dim_levels(h_i));
667: END LOOP;
668:
669: -- BSC_SYS_DIM_LEVELS_BY_GROUP
670: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||
671: ' WHERE dim_level_id IN ('||
672: ' SELECT dim_level_id'||
673: ' FROM bsc_sys_dim_levels_b'||
674: ' WHERE '||h_condition||

Line 673: ' FROM bsc_sys_dim_levels_b'||

669: -- BSC_SYS_DIM_LEVELS_BY_GROUP
670: h_sql := 'DELETE FROM bsc_sys_dim_levels_by_group'||
671: ' WHERE dim_level_id IN ('||
672: ' SELECT dim_level_id'||
673: ' FROM bsc_sys_dim_levels_b'||
674: ' WHERE '||h_condition||
675: ' )';
676: BSC_APPS.Execute_Immediate(h_sql);
677:

Line 682: ' FROM bsc_sys_dim_levels_b'||

678: -- BSC_SYS_DIM_LEVEL_COLS
679: h_sql := 'DELETE FROM bsc_sys_dim_level_cols'||
680: ' WHERE dim_level_id IN ('||
681: ' SELECT dim_level_id'||
682: ' FROM bsc_sys_dim_levels_b'||
683: ' WHERE '||h_condition||
684: ' )';
685: BSC_APPS.Execute_Immediate(h_sql);
686:

Line 691: ' FROM bsc_sys_dim_levels_b'||

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||
693: ' )';
694: BSC_APPS.Execute_Immediate(h_sql);
695:

Line 700: ' FROM bsc_sys_dim_levels_b'||

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||
702: ' )';
703: BSC_APPS.Execute_Immediate(h_sql);
704:

Line 709: ' FROM bsc_sys_dim_levels_b'||

705: -- BSC_SYS_DIM_LEVELS_TL
706: h_sql := 'DELETE FROM bsc_sys_dim_levels_tl'||
707: ' WHERE dim_level_id IN ('||
708: ' SELECT dim_level_id'||
709: ' FROM bsc_sys_dim_levels_b'||
710: ' WHERE '||h_condition||
711: ' )';
712: BSC_APPS.Execute_Immediate(h_sql);
713:

Line 714: -- BSC_SYS_DIM_LEVELS_B

710: ' WHERE '||h_condition||
711: ' )';
712: BSC_APPS.Execute_Immediate(h_sql);
713:
714: -- BSC_SYS_DIM_LEVELS_B
715: h_sql := 'DELETE FROM bsc_sys_dim_levels_b'||
716: ' WHERE '||h_condition;
717: BSC_APPS.Execute_Immediate(h_sql);
718:

Line 715: h_sql := 'DELETE FROM bsc_sys_dim_levels_b'||

711: ' )';
712: BSC_APPS.Execute_Immediate(h_sql);
713:
714: -- BSC_SYS_DIM_LEVELS_B
715: h_sql := 'DELETE FROM bsc_sys_dim_levels_b'||
716: ' WHERE '||h_condition;
717: BSC_APPS.Execute_Immediate(h_sql);
718:
719: END IF;

Line 1073: ' FROM bsc_sys_dim_levels_b';

1069: h_base_message_v := BSC_APPS.Get_Message('BSC_CREATING_VIEW');
1070:
1071: -- Dimension tables
1072: h_sql := 'SELECT level_table_name, level_view_name, nvl(source, ''BSC'')'||
1073: ' FROM bsc_sys_dim_levels_b';
1074: OPEN h_cursor FOR h_sql;
1075: LOOP
1076: FETCH h_cursor INTO h_table, h_view, h_source;
1077: EXIT WHEN h_cursor%NOTFOUND;

Line 1361: ' FROM bsc_sys_dim_levels_b';

1357: BSC_APPS.Write_Line_Log(BSC_APPS.Get_Message('BSC_MIG_CREATE_INDEXES'), BSC_APPS.OUTPUT_FILE);
1358:
1359: -- Dimension tables
1360: h_sql := 'SELECT level_table_name'||
1361: ' FROM bsc_sys_dim_levels_b';
1362: OPEN h_cursor FOR h_sql;
1363: LOOP
1364: FETCH h_cursor INTO h_table;
1365: EXIT WHEN h_cursor%NOTFOUND;

Line 1542: ' FROM bsc_sys_dim_levels_b'||

1538: BEGIN
1539:
1540: -- Dimension tables
1541: h_sql := 'SELECT level_table_name'||
1542: ' FROM bsc_sys_dim_levels_b'||
1543: ' WHERE NVL(source, ''BSC'') = ''BSC''';
1544: OPEN h_cursor FOR h_sql;
1545: LOOP
1546: FETCH h_cursor INTO h_table;

Line 1845: FROM bsc_sys_dim_levels_b;

1841: FROM bsc_db_tables;
1842:
1843: CURSOR c_dim_tables IS
1844: SELECT level_table_name, level_view_name, nvl(edw_flag,0)
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

Line 2726: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||

2722:
2723: -- Get all the invalid dimensions. PMF dimensions not existing in the target
2724: g_num_invalid_pmf_dimensions := 0;
2725: h_sql := 'SELECT DISTINCT bsc_d.short_name'||
2726: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2727: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2728: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2729: ' bis_dimensions pmf_d'||
2730: ' WHERE bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||

Line 2728: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||

2724: g_num_invalid_pmf_dimensions := 0;
2725: h_sql := 'SELECT DISTINCT bsc_d.short_name'||
2726: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2727: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2728: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2729: ' bis_dimensions pmf_d'||
2730: ' WHERE bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
2731: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||
2732: ' bsc_do.source = :1 AND'||

Line 2748: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||

2744:
2745: -- Get indicators using those invalid dimensions
2746: h_sql := 'SELECT DISTINCT k.indicator'||
2747: ' FROM bsc_kpi_dim_groups@'||g_db_link||' k,'||
2748: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2749: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2750: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2751: ' bis_dimensions pmf_d'||
2752: ' WHERE k.dim_group_id = bsc_d.dim_group_id AND'||

Line 2750: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||

2746: h_sql := 'SELECT DISTINCT k.indicator'||
2747: ' FROM bsc_kpi_dim_groups@'||g_db_link||' k,'||
2748: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_do,'||
2749: ' bsc_sys_dim_groups_vl@'||g_db_link||' bsc_d,'||
2750: ' bsc_sys_dim_levels_by_group@'||g_db_link||' bsc_dlg,'||
2751: ' bis_dimensions pmf_d'||
2752: ' WHERE k.dim_group_id = bsc_d.dim_group_id AND'||
2753: ' bsc_do.dim_level_id = bsc_dlg.dim_level_id AND'||
2754: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||

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 2799: ' bsc_sys_dim_levels_b@'||g_db_link||' bsc_dl,'||

2795:
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'||

Line 3045: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||')';

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'||
3045: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||')';
3046: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3047: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3048:
3049: -- Add for bug#2728248

Line 3419: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3415: g_metadata_tables(g_num_metadata_tables).level := 1;
3416: g_metadata_tables(g_num_metadata_tables).level_column := 'TAB_ID';
3417: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3418: ' SELECT DIM_LEVEL_ID'||
3419: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3420: ' WHERE NVL(EDW_FLAG,0) = 0)';
3421: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3422: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3423:

Line 3463: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_B';

3459: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3460: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3461:
3462: g_num_metadata_tables := g_num_metadata_tables + 1;
3463: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_B';
3464: g_metadata_tables(g_num_metadata_tables).level := 0;
3465: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3466: g_metadata_tables(g_num_metadata_tables).level_condition := 'NVL(EDW_FLAG, 0) = 0';
3467: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3471: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_BY_GROUP';

3467: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3468: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3469:
3470: g_num_metadata_tables := g_num_metadata_tables + 1;
3471: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DIM_LEVELS_BY_GROUP';
3472: g_metadata_tables(g_num_metadata_tables).level := 0;
3473: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3474: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3475: ' SELECT DIM_LEVEL_ID'||

Line 3476: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3472: g_metadata_tables(g_num_metadata_tables).level := 0;
3473: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3474: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3475: ' SELECT DIM_LEVEL_ID'||
3476: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3477: ' WHERE NVL(EDW_FLAG,0) = 0)';
3478: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3479: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3480:

Line 3487: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3483: g_metadata_tables(g_num_metadata_tables).level := 0;
3484: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3485: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3486: ' SELECT DIM_LEVEL_ID'||
3487: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3488: ' WHERE NVL(EDW_FLAG,0) = 0)';
3489: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3490: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3491:

Line 3498: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3494: g_metadata_tables(g_num_metadata_tables).level := 0;
3495: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3496: g_metadata_tables(g_num_metadata_tables).level_condition := 'DIM_LEVEL_ID IN ('||
3497: ' SELECT DIM_LEVEL_ID'||
3498: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3499: ' WHERE NVL(EDW_FLAG,0) = 0)';
3500: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3501: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3502:

Line 3509: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

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'||
3509: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3510: ' WHERE NVL(EDW_FLAG,0) = 0)';
3511: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3512: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3513:

Line 3529: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3525: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3526: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 0 AND'||
3527: ' DIM_LEVEL_ID IN ('||
3528: ' SELECT DIM_LEVEL_ID'||
3529: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3530: ' WHERE NVL(EDW_FLAG,0) = 0)';
3531: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3532: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3533:

Line 3541: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3537: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3538: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 1 AND'||
3539: ' DIM_LEVEL_ID IN ('||
3540: ' SELECT DIM_LEVEL_ID'||
3541: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3542: ' WHERE NVL(EDW_FLAG,0) = 0)';
3543: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3544: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3545:

Line 3561: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3557: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3558: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 0 AND'||
3559: ' DIM_LEVEL_ID IN ('||
3560: ' SELECT DIM_LEVEL_ID'||
3561: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3562: ' WHERE NVL(EDW_FLAG,0) = 0)';
3563: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3564: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3565:

Line 3573: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||

3569: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3570: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 1 AND'||
3571: ' DIM_LEVEL_ID IN ('||
3572: ' SELECT DIM_LEVEL_ID'||
3573: ' FROM BSC_SYS_DIM_LEVELS_B@'||g_db_link||
3574: ' WHERE NVL(EDW_FLAG,0) = 0)';
3575: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3576: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3577:

Line 4452: ' FROM bsc_sys_dim_levels_b'||

4448: h_base_message := BSC_APPS.Get_Message('BSC_MIG_DATA');
4449:
4450: -- Dimension tables
4451: h_sql := 'SELECT level_table_name'||
4452: ' FROM bsc_sys_dim_levels_b'||
4453: ' WHERE NVL(source, ''BSC'') = ''BSC''';
4454: OPEN h_cursor FOR h_sql;
4455: LOOP
4456: FETCH h_cursor INTO h_table;

Line 5879: ' from bsc_sys_dim_levels_b'||

5875: RAISE e_creating_dbi_dim_tables;
5876: END IF;
5877:
5878: h_sql := 'select distinct short_name'||
5879: ' from bsc_sys_dim_levels_b'||
5880: ' where source = :1';
5881: OPEN h_cursor FOR h_sql USING 'PMF';
5882: LOOP
5883: FETCH h_cursor INTO h_dbi_short_name;

Line 6214: FROM bsc_sys_dim_levels_b sbsc_dl,

6210: FUNCTION Remove_Custom_Dim_Objs_In_PMF RETURN BOOLEAN IS
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:

Line 6461: ' bsc_sys_dim_levels_by_group bsc_dlg'||

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'||
6464: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||
6465: ' bsc_d.short_name = pmf_d.short_name'||

Line 6506: ' bsc_sys_dim_levels_by_group bsc_dlg'||

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'||
6509: ' bsc_dlg.dim_group_id = bsc_d.dim_group_id AND'||
6510: ' bsc_d.short_name = pmf_d.short_name'||

Line 7438: ' FROM bsc_sys_dim_levels_b@'||g_db_link||' sbsc_dl,'||

7434: --Query to get non-pre-seeded BSC/PMF dimension levels from the source
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;

Line 8174: FROM bsc_sys_dim_levels_b

8170: -- to the dimension table because the code and user_code is the same. We
8171: -- do not need to translate code into user_code
8172: SELECT source
8173: INTO h_level_source
8174: FROM bsc_sys_dim_levels_b
8175: WHERE level_view_name = h_key_dim_tables(h_i);
8176: IF h_level_source = 'PMF' THEN
8177: h_key_dim_tables(h_i) := null;
8178: END IF;

Line 9200: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_dim_levels_b');

9196: --Dim Object Sync Up
9197: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9198: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9199: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9200: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_dim_levels_b');
9201: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d , bsc_sys_dim_groups_vl');
9202: l_sql := l_sql || ' g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';
9203: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = d.short_name AND';
9204: l_sql := l_sql || ' SUBSTR(ak_item.attribute2,0,INSTR(ak_item.attribute2,''+'') - 1) = g.short_name AND k.indicator = :1 MINUS';

Line 9209: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p,bsc_sys_dim_levels_b');

9205: l_sql := l_sql || ' SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9206: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9207: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9208: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_periodicities');
9209: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p,bsc_sys_dim_levels_b');
9210: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d,bsc_sys_dim_groups_vl');
9211: l_sql := l_sql || 'g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';
9212: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = p.short_name AND d.short_name = p.short_name';
9213: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,0,INSTR(ak_item.attribute2,''+'') - 1) = g.short_name';

Line 9278: bsc_sys_dim_levels_b b

9274: attribute_label_long = (SELECT
9275: tl.name
9276: FROM
9277: bsc_sys_dim_levels_tl tl,
9278: bsc_sys_dim_levels_b b
9279: WHERE
9280: b.short_name = l_Dim_Lev_Sht_Name AND
9281: b.dim_level_id = tl.dim_level_id AND
9282: tl.language = ak_item.language)