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_DATASETS_B

Line 102: ', bsc_sys_datasets_b@'||g_db_link||' sd'||

98:
99: BEGIN
100: h_sql := 'SELECT DISTINCT si.short_name,si.dataset_id'||
101: ' FROM bis_indicators@'||g_db_link||' si'||
102: ', bsc_sys_datasets_b@'||g_db_link||' sd'||
103: ' WHERE sd.dataset_id = si.dataset_id AND'||
104: ' si.created_by NOT IN (:2, :3, :4, :5)';
105: IF(h_cursor%ISOPEN) THEN
106: CLOSE h_cursor;

Line 590: ' FROM bsc_sys_datasets_b'||

586: -- BSC_SYS_DATASET_CALC
587: h_sql := 'DELETE FROM bsc_sys_dataset_calc'||
588: ' WHERE dataset_id IN ('||
589: ' SELECT dataset_id'||
590: ' FROM bsc_sys_datasets_b'||
591: ' WHERE measure_id1 IN ('||
592: ' SELECT measure_id'||
593: ' FROM bsc_sys_measures'||
594: ' WHERE '||h_condition||

Line 603: ' FROM bsc_sys_datasets_b'||

599: -- BSC_SYS_DATASETS_TL
600: h_sql := 'DELETE FROM bsc_sys_datasets_tl'||
601: ' WHERE dataset_id IN ('||
602: ' SELECT dataset_id'||
603: ' FROM bsc_sys_datasets_b'||
604: ' WHERE measure_id1 IN ('||
605: ' SELECT measure_id'||
606: ' FROM bsc_sys_measures'||
607: ' WHERE '||h_condition||

Line 612: -- BSC_SYS_DATASETS_B

608: ' )'||
609: ' )';
610: BSC_APPS.Execute_Immediate(h_sql);
611:
612: -- BSC_SYS_DATASETS_B
613: h_sql := 'DELETE FROM bsc_sys_datasets_b'||
614: ' WHERE measure_id1 IN ('||
615: ' SELECT measure_id'||
616: ' FROM bsc_sys_measures'||

Line 613: h_sql := 'DELETE FROM bsc_sys_datasets_b'||

609: ' )';
610: BSC_APPS.Execute_Immediate(h_sql);
611:
612: -- BSC_SYS_DATASETS_B
613: h_sql := 'DELETE FROM bsc_sys_datasets_b'||
614: ' WHERE measure_id1 IN ('||
615: ' SELECT measure_id'||
616: ' FROM bsc_sys_measures'||
617: ' WHERE '||h_condition||

Line 2849: ' bsc_sys_datasets_b@'||g_db_link||' d,'||

2845: --g_num_invalid_kpis := 0;
2846:
2847: h_sql := 'SELECT DISTINCT k.indicator'||
2848: ' FROM bsc_kpi_analysis_measures_b@'||g_db_link||' k,'||
2849: ' bsc_sys_datasets_b@'||g_db_link||' d,'||
2850: ' bsc_sys_measures@'||g_db_link||' m,'||
2851: ' bis_indicators i'||
2852: ' WHERE k.dataset_id = d.dataset_id AND'||
2853: ' d.measure_id1 = m.measure_id AND'||

Line 2894: ' bsc_sys_datasets_b@'||g_db_link||' d,'||

2890:
2891: --Fix bug#4226188: Now get the indicators using PMF measures whose dimensions does not exists in the target
2892: h_sql := 'SELECT DISTINCT k.indicator'||
2893: ' FROM bsc_kpi_analysis_measures_b@'||g_db_link||' k,'||
2894: ' bsc_sys_datasets_b@'||g_db_link||' d,'||
2895: ' bsc_sys_measures@'||g_db_link||' m,'||
2896: ' bis_indicator_dimensions@'||g_db_link||' id,'||
2897: ' bis_indicators@'||g_db_link||' i,'||
2898: ' bis_dimensions@'||g_db_link||' sd,'||

Line 3425: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DATASETS_B';

3421: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3422: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3423:
3424: g_num_metadata_tables := g_num_metadata_tables + 1;
3425: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_DATASETS_B';
3426: g_metadata_tables(g_num_metadata_tables).level := 0;
3427: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3428: g_metadata_tables(g_num_metadata_tables).level_condition := 'NVL(EDW_FLAG, 0) = 0';
3429: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3438: ' FROM BSC_SYS_DATASETS_B@'||g_db_link||

3434: g_metadata_tables(g_num_metadata_tables).level := 0;
3435: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3436: g_metadata_tables(g_num_metadata_tables).level_condition := 'DATASET_ID IN ('||
3437: ' SELECT DATASET_ID'||
3438: ' FROM BSC_SYS_DATASETS_B@'||g_db_link||
3439: ' WHERE NVL(EDW_FLAG,0) = 0)';
3440: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3441: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3442:

Line 3449: ' FROM BSC_SYS_DATASETS_B@'||g_db_link||

3445: g_metadata_tables(g_num_metadata_tables).level := 0;
3446: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3447: g_metadata_tables(g_num_metadata_tables).level_condition := 'DATASET_ID IN ('||
3448: ' SELECT DATASET_ID'||
3449: ' FROM BSC_SYS_DATASETS_B@'||g_db_link||
3450: ' WHERE NVL(EDW_FLAG,0) = 0)';
3451: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3452: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3453:

Line 5684: -- we need to sync up dataset_ids between bis_indicators and bsc_sys_datasets_b

5680: -- g_invalid_dimenisions and g_invalid_dim_levels
5681: Clean_Metadata_Invalid_PMF;
5682:
5683:
5684: -- we need to sync up dataset_ids between bis_indicators and bsc_sys_datasets_b
5685: -- because there can be many datasets pointing to same measure as measure_id1
5686: -- sync up is not able to handle this issue.
5687: -- bug 5990096
5688: syncup_dataset_id_in_target;

Line 6362: bsc_sys_datasets_b sd

6358: -- bug 5099776 modified cursor correct join is with dataset_ids
6359: CURSOR c_measures (p1 NUMBER, p2 NUMBER, p3 NUMBER, p4 NUMBER) IS
6360: SELECT DISTINCT si.indicator_id
6361: FROM bis_indicators si,
6362: bsc_sys_datasets_b sd
6363: WHERE sd.dataset_id = si.dataset_id AND
6364: si.created_by NOT IN (p1, p2, p3,p4);
6365:
6366: h_indicator_id NUMBER;

Line 7649: ' bsc_sys_datasets_b@'||g_db_link||' sd'||

7645: --We will need to create/update those measures in the target
7646: -- bug 5099776
7647: h_sql := 'SELECT DISTINCT si.short_name'||
7648: ' FROM bis_indicators@'||g_db_link||' si,'||
7649: ' bsc_sys_datasets_b@'||g_db_link||' sd'||
7650: ' WHERE sd.dataset_id= si.dataset_id AND'||
7651: ' si.created_by NOT IN (:2, :3, :4, :5)';
7652: OPEN h_cursor FOR h_sql USING 1, 2,120,121;
7653: LOOP