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_FILTERS_VIEWS

Line 1147: ' FROM bsc_sys_filters_views';

1143: -- Filter views
1144: h_base_message := BSC_APPS.Get_Message('BSC_CREATING_VIEW');
1145:
1146: h_sql := 'SELECT level_view_name'||
1147: ' FROM bsc_sys_filters_views';
1148: OPEN h_cursor FOR h_sql;
1149: LOOP
1150: FETCH h_cursor INTO h_view;
1151: EXIT WHEN h_cursor%NOTFOUND;

Line 1854: FROM bsc_sys_filters_views;

1850: WHERE relation_type = 2;
1851:
1852: CURSOR c_filter_views IS
1853: SELECT level_view_name
1854: FROM bsc_sys_filters_views;
1855:
1856: -- ENH_B_TABLES_PERF: get rowid tables created for input tables
1857: CURSOR c_rowid_tables IS
1858: select bsc_migration.get_rowid_table_name(table_name)

Line 3555: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';

3551: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3552: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3553:
3554: g_num_metadata_tables := g_num_metadata_tables + 1;
3555: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';
3556: g_metadata_tables(g_num_metadata_tables).level := 0;
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 ('||

Line 3567: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';

3563: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3564: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3565:
3566: g_num_metadata_tables := g_num_metadata_tables + 1;
3567: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';
3568: g_metadata_tables(g_num_metadata_tables).level := 1;
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 ('||

Line 3579: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';

3575: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3576: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3577:
3578: g_num_metadata_tables := g_num_metadata_tables + 1;
3579: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_FILTERS_VIEWS';
3580: g_metadata_tables(g_num_metadata_tables).level := 2;
3581: g_metadata_tables(g_num_metadata_tables).level_column := 'SOURCE_CODE';
3582: g_metadata_tables(g_num_metadata_tables).level_condition := 'SOURCE_TYPE = 2';
3583: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;