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_DB_TABLES

Line 1105: ' FROM bsc_db_tables'||

1101: CLOSE h_cursor;
1102:
1103: -- Input tables for dimensions
1104: h_sql := 'SELECT table_name'||
1105: ' FROM bsc_db_tables'||
1106: ' WHERE table_type = 2';
1107: OPEN h_cursor FOR h_sql;
1108: LOOP
1109: FETCH h_cursor INTO h_table;

Line 1374: ' FROM bsc_db_tables'||

1370: CLOSE h_cursor;
1371:
1372: -- Dimension input tables
1373: h_sql := 'SELECT table_name'||
1374: ' FROM bsc_db_tables'||
1375: ' WHERE table_type = 2';
1376: OPEN h_cursor FOR h_sql;
1377: LOOP
1378: FETCH h_cursor INTO h_table;

Line 1841: FROM bsc_db_tables;

1837: FUNCTION Drop_Dynamic_Objects RETURN BOOLEAN IS
1838:
1839: CURSOR c_data_tables IS
1840: SELECT table_name
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;

Line 1859: from bsc_db_tables

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)
1859: from bsc_db_tables
1860: where table_type = 0;
1861:
1862: -- ENH_B_TABLES_PERF: get rowid tables created for input tables
1863: CURSOR c_proj_tables IS

Line 1865: from bsc_db_tables

1861:
1862: -- ENH_B_TABLES_PERF: get rowid tables created for input tables
1863: CURSOR c_proj_tables IS
1864: select bsc_migration.get_proj_table_name(table_name)
1865: from bsc_db_tables
1866: where table_type = 1;
1867:
1868: h_table VARCHAR2(30);
1869: h_edw_flag NUMBER;

Line 2081: ' FROM BSC_DB_TABLES_RELS'||

2077: CLOSE h_cursor;
2078:
2079: -- BSC-MV Note: Also Drop all MV used for targets
2080: h_sql := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME'||
2081: ' FROM BSC_DB_TABLES_RELS'||
2082: ' WHERE TABLE_NAME IN ('||
2083: ' SELECT TABLE_NAME'||
2084: ' FROM BSC_KPI_DATA_TABLES'||
2085: ' WHERE TABLE_NAME IS NOT NULL'||

Line 3004: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES';

3000: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3001:
3002: -- This table will copy data tables according to the kpis being migrated.
3003: g_num_metadata_tables := g_num_metadata_tables + 1;
3004: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES';
3005: g_metadata_tables(g_num_metadata_tables).level := 3;
3006: g_metadata_tables(g_num_metadata_tables).level_column := 'TABLE_NAME';
3007: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3008: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3013: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES';

3009: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3010:
3011: -- This is for input tables for dimensions which are system level objects
3012: g_num_metadata_tables := g_num_metadata_tables + 1;
3013: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES';
3014: g_metadata_tables(g_num_metadata_tables).level := 0;
3015: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3016: g_metadata_tables(g_num_metadata_tables).level_condition := 'TABLE_TYPE = 2';
3017: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3021: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_COLS';

3017: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3018: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3019:
3020: g_num_metadata_tables := g_num_metadata_tables + 1;
3021: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_COLS';
3022: g_metadata_tables(g_num_metadata_tables).level := 3;
3023: g_metadata_tables(g_num_metadata_tables).level_column := 'TABLE_NAME';
3024: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3025: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3031: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3027:
3028: -- This table will copy relationships between DATA tables
3029: -- according to the kpis being migrated
3030: g_num_metadata_tables := g_num_metadata_tables + 1;
3031: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
3032: g_metadata_tables(g_num_metadata_tables).level := 3;
3033: g_metadata_tables(g_num_metadata_tables).level_column := 'TABLE_NAME';
3034: g_metadata_tables(g_num_metadata_tables).level_condition := NULL;
3035: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3040: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3036: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3037:
3038: -- This is for relations between dimension tables and input tables which are system level objects
3039: g_num_metadata_tables := g_num_metadata_tables + 1;
3040: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
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'||

Line 3052: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';

3048:
3049: -- Add for bug#2728248
3050: -- This is for relations between MN dimension tables and its input tables which are system level objects
3051: g_num_metadata_tables := g_num_metadata_tables + 1;
3052: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_DB_TABLES_RELS';
3053: g_metadata_tables(g_num_metadata_tables).level := 0;
3054: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3055: g_metadata_tables(g_num_metadata_tables).level_condition := 'TABLE_NAME IN ('||
3056: ' SELECT RELATION_COL'||

Line 4214: FROM bsc_db_tables

4210: ) RETURN BOOLEAN IS
4211:
4212: CURSOR c_table_type IS
4213: SELECT table_type
4214: FROM bsc_db_tables
4215: WHERE table_name = x_table_name;
4216:
4217: h_table_type NUMBER;
4218:

Line 4246: FROM bsc_db_tables t, bsc_db_tables_rels r

4242: ) RETURN BOOLEAN IS
4243:
4244: CURSOR c_table_type IS
4245: SELECT t.table_type
4246: FROM bsc_db_tables t, bsc_db_tables_rels r
4247: WHERE t.table_name = r.source_table_name and
4248: r.table_name = x_table_name;
4249:
4250: h_table_type NUMBER;

Line 4297: ' FROM bsc_db_tables_rels@'||g_db_link||

4293: BSC_APPS.Add_Value_Big_In_Cond(1, x_tables(h_i));
4294: END LOOP;
4295:
4296: h_sql := 'SELECT DISTINCT source_table_name'||
4297: ' FROM bsc_db_tables_rels@'||g_db_link||
4298: ' WHERE '||h_table_cond;
4299: OPEN h_cursor FOR h_sql;
4300:
4301: LOOP

Line 5969: h_sql := 'SELECT table_name FROM bsc_db_tables_rels'||

5965: -- Refresh all MV in the system
5966: -- Get all the base tables
5967: --AW_INTEGRATION: We need to get only the base tables used by MV indicators
5968: h_num_base_tables := 0;
5969: h_sql := 'SELECT table_name FROM bsc_db_tables_rels'||
5970: ' WHERE source_table_name IN ('||
5971: ' SELECT table_name FROM bsc_db_tables'||
5972: ' WHERE table_type = :1)';
5973: OPEN h_cursor FOR h_sql USING 0;

Line 5971: ' SELECT table_name FROM bsc_db_tables'||

5967: --AW_INTEGRATION: We need to get only the base tables used by MV indicators
5968: h_num_base_tables := 0;
5969: h_sql := 'SELECT table_name FROM bsc_db_tables_rels'||
5970: ' WHERE source_table_name IN ('||
5971: ' SELECT table_name FROM bsc_db_tables'||
5972: ' WHERE table_type = :1)';
5973: OPEN h_cursor FOR h_sql USING 0;
5974: LOOP
5975: FETCH h_cursor INTO h_table;

Line 7003: ' from bsc_db_tables_rels@'||g_db_link||

6999: ' where t.indicator = k.indicator and'||
7000: ' (t.table_name = :1 or'||
7001: ' t.table_name in ('||
7002: ' select distinct table_name'||
7003: ' from bsc_db_tables_rels@'||g_db_link||
7004: ' start with source_table_name = :2'||
7005: ' connect by source_table_name = prior table_name))';
7006: OPEN h_cursor FOR h_sql USING h_invalid_tables(h_i), h_invalid_tables(h_i);
7007: LOOP

Line 7113: ' FROM bsc_db_tables@'||g_db_link||

7109: BEGIN
7110: h_table_generation_type := NULL;
7111:
7112: h_sql := 'SELECT generation_type'||
7113: ' FROM bsc_db_tables@'||g_db_link||
7114: ' WHERE table_name = :1';
7115: OPEN h_cursor FOR h_sql USING x_table_name;
7116: FETCH h_cursor INTO h_table_generation_type;
7117: IF h_cursor%NOTFOUND THEN

Line 8262: -- Update the property PARTITIONS in BSC_DB_TABLES for this base table

8258: execute immediate h_sql;
8259: commit;
8260: END LOOP;
8261:
8262: -- Update the property PARTITIONS in BSC_DB_TABLES for this base table
8263: IF h_num_key_columns > 0 THEN
8264: bsc_dbgen_metadata_reader.set_table_property(x_base_table, BSC_DBGEN_STD_METADATA.BSC_PARTITION, h_max_partitions);
8265: commit;
8266: END IF;