APPS.BSC_MIGRATION dependencies on ALL_TABLES

Line 872: ' FROM all_tables@'||g_db_link||

868: ' where table_owner = :1 and table_name = :2';
869: OPEN h_cursor FOR h_sql USING g_src_bsc_schema, h_table;
870: ELSE
871: h_sql := 'SELECT initial_extent, next_extent, max_extents, pct_increase'||
872: ' FROM all_tables@'||g_db_link||
873: ' WHERE table_name = :1 AND'||
874: ' owner = :2';
875: OPEN h_cursor FOR h_sql USING h_table, g_src_bsc_schema;
876: END IF;

Line 879: ' FROM all_tables@'||g_db_link||

875: OPEN h_cursor FOR h_sql USING h_table, g_src_bsc_schema;
876: END IF;
877: ELSE
878: h_sql := 'SELECT initial_extent, next_extent, max_extents, pct_increase'||
879: ' FROM all_tables@'||g_db_link||
880: ' WHERE table_name = :1 AND'||
881: ' owner = :2';
882: OPEN h_cursor FOR h_sql USING h_table, g_src_bsc_schema;
883: END IF;

Line 5137: ALL_TABLES WHERE TABLE_NAME = pTableName

5133: +============================================================================*/
5134: FUNCTION table_exists(pTableName IN VARCHAR2, pSchema IN VARCHAR2) return boolean IS
5135: CURSOR cTable IS
5136: SELECT COUNT(1) FROM
5137: ALL_TABLES WHERE TABLE_NAME = pTableName
5138: AND OWNER = pSchema;
5139: l_count NUMBER := 0;
5140: BEGIN
5141: OPEN cTable;

Line 6902: ' FROM all_tables@'||g_db_link||

6898: ' FROM bsc_sys_dim_levels_vl@'||g_db_link||
6899: ' WHERE NVL(source, ''BSC'') = ''BSC'' AND '||
6900: ' UPPER(level_table_name) NOT IN ('||
6901: ' SELECT table_name'||
6902: ' FROM all_tables@'||g_db_link||
6903: ' WHERE owner = :1)';
6904: OPEN h_cursor FOR h_sql USING g_src_bsc_schema;
6905: LOOP
6906: FETCH h_cursor INTO h_dim_table, h_dim_obj;

Line 6927: ' FROM all_tables@'||g_db_link||

6923: ' WHERE r.relation_type = 2 AND r.dim_level_id = c.dim_level_id (+)'||
6924: ' AND r.parent_dim_level_id = p.dim_level_id (+)'||
6925: ' AND UPPER(r.relation_col) NOT IN ('||
6926: ' SELECT table_name'||
6927: ' FROM all_tables@'||g_db_link||
6928: ' WHERE owner = :1)';
6929: OPEN h_cursor FOR h_sql USING g_src_bsc_schema;
6930: LOOP
6931: FETCH h_cursor INTO h_dim_table, h_dim_obj, h_dim_obj1;

Line 7082: ' from all_tables@'||g_db_link||

7078: h_count NUMBER;
7079:
7080: BEGIN
7081: h_sql := 'select count(*)'||
7082: ' from all_tables@'||g_db_link||
7083: ' where owner = :1 and table_name = :2';
7084: OPEN h_cursor FOR h_sql USING g_src_bsc_schema, x_table_name;
7085: FETCH h_cursor INTO h_count;
7086: CLOSE h_cursor;

Line 9562: l_table_name all_tables.table_name%TYPE;

9558: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
9559: l_Table_Number NUMBER;
9560: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
9561: l_sql VARCHAR2(32700);
9562: l_table_name all_tables.table_name%TYPE;
9563: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
9564: l_num_columns NUMBER;
9565: l_colum VARCHAR2(100);
9566: l_key_name VARCHAR2(30);