APPS.BSC_MIGRATION dependencies on USER_TAB_COLUMNS

Line 334: FROM user_tab_columns

330: h_lst_select VARCHAR2(32700);
331:
332: CURSOR c_columns IS
333: SELECT column_name
334: FROM user_tab_columns
335: WHERE table_name = UPPER(h_table_name);
336:
337: CURSOR c_columns_apps IS
338: SELECT column_name

Line 795: ' FROM user_tab_columns@'||g_db_link||

791: IF NOT g_src_apps_flag THEN
792: -- The source is Non-Enterprise version
793: h_sql := 'SELECT column_id, column_name, data_type, data_length,'||
794: ' data_precision, data_scale, nullable'||
795: ' FROM user_tab_columns@'||g_db_link||
796: ' WHERE table_name = :1'||
797: ' ORDER BY column_id';
798: OPEN h_cursor FOR h_sql USING h_table;
799: ELSE

Line 961: -- The columns of the view are in user_tab_columns.

957: BEGIN
958: h_view := UPPER(x_view);
959:
960: -- Get the columns of the view
961: -- The columns of the view are in user_tab_columns.
962: -- Because it is view, we know it should be in APPS scheme so qe can use
963: -- user_tab_columns even when in Apps environment.
964: h_sql := 'SELECT column_id, column_name'||
965: ' FROM user_tab_columns@'||g_db_link||

Line 963: -- user_tab_columns even when in Apps environment.

959:
960: -- Get the columns of the view
961: -- The columns of the view are in user_tab_columns.
962: -- Because it is view, we know it should be in APPS scheme so qe can use
963: -- user_tab_columns even when in Apps environment.
964: h_sql := 'SELECT column_id, column_name'||
965: ' FROM user_tab_columns@'||g_db_link||
966: ' WHERE table_name = :1'||
967: ' ORDER BY column_id';

Line 965: ' FROM user_tab_columns@'||g_db_link||

961: -- The columns of the view are in user_tab_columns.
962: -- Because it is view, we know it should be in APPS scheme so qe can use
963: -- user_tab_columns even when in Apps environment.
964: h_sql := 'SELECT column_id, column_name'||
965: ' FROM user_tab_columns@'||g_db_link||
966: ' WHERE table_name = :1'||
967: ' ORDER BY column_id';
968: OPEN h_cursor FOR h_sql USING h_view;
969:

Line 2552: FROM user_tab_columns

2548: h_column_name VARCHAR2(30);
2549:
2550: CURSOR c_columns IS
2551: SELECT column_name
2552: FROM user_tab_columns
2553: WHERE table_name = UPPER(x_table);
2554:
2555: CURSOR c_columns_apps IS
2556: SELECT column_name