APPS.BSC_MIGRATION dependencies on ALL_TAB_COLUMNS

Line 339: FROM all_tab_columns

335: WHERE table_name = UPPER(h_table_name);
336:
337: CURSOR c_columns_apps IS
338: SELECT column_name
339: FROM all_tab_columns
340: WHERE table_name = UPPER(h_table_name) AND
341: owner = UPPER(BSC_APPS.BSC_APPS_SCHEMA);
342:
343: BEGIN

Line 803: ' FROM all_tab_columns@'||g_db_link||

799: ELSE
800: -- The source system is Enterprice version (APPS)
801: h_sql := 'SELECT column_id, column_name, data_type, data_length,'||
802: ' data_precision, data_scale, nullable'||
803: ' FROM all_tab_columns@'||g_db_link||
804: ' WHERE table_name = :1 AND'||
805: ' owner = :2'||
806: ' ORDER BY column_id';
807: OPEN h_cursor FOR h_sql USING h_table, g_src_bsc_schema;

Line 2557: FROM all_tab_columns

2553: WHERE table_name = UPPER(x_table);
2554:
2555: CURSOR c_columns_apps IS
2556: SELECT column_name
2557: FROM all_tab_columns
2558: WHERE table_name = UPPER(x_table) AND
2559: owner = UPPER(BSC_APPS.BSC_APPS_SCHEMA);
2560:
2561: BEGIN

Line 8138: FROM all_tab_columns

8134: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
8135:
8136: CURSOR c_columns(p_table varchar2) IS
8137: SELECT column_name
8138: FROM all_tab_columns
8139: WHERE table_name = UPPER(p_table) AND
8140: owner = UPPER(BSC_APPS.BSC_APPS_SCHEMA);
8141:
8142: h_column VARCHAR2(50);

Line 9568: l_column_name all_tab_columns.column_name%TYPE;

9564: l_num_columns NUMBER;
9565: l_colum VARCHAR2(100);
9566: l_key_name VARCHAR2(30);
9567: l_error_msg VARCHAR2(4000);
9568: l_column_name all_tab_columns.column_name%TYPE;
9569: l_Tl_Table_Column all_tab_columns.column_name%TYPE;
9570: l_condition VARCHAR2(4000);
9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

Line 9569: l_Tl_Table_Column all_tab_columns.column_name%TYPE;

9565: l_colum VARCHAR2(100);
9566: l_key_name VARCHAR2(30);
9567: l_error_msg VARCHAR2(4000);
9568: l_column_name all_tab_columns.column_name%TYPE;
9569: l_Tl_Table_Column all_tab_columns.column_name%TYPE;
9570: l_condition VARCHAR2(4000);
9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

Line 9583: FROM all_tab_columns

9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;
9581: CURSOR c_column IS
9582: SELECT column_name
9583: FROM all_tab_columns
9584: WHERE table_name = UPPER(l_table_name)
9585: AND OWNER = UPPER(BSC_APPS.BSC_APPS_SCHEMA);
9586:
9587: