APPS.CZ_MIGRATE dependencies on ALL_TAB_COLUMNS

Line 695: ' FROM all_tab_columns ' ||

691:
692: cdyn := dbms_sql.open_cursor;
693: dbms_sql.parse(cdyn,
694: '(SELECT column_name, data_type, nullable, data_length ' ||
695: ' FROM all_tab_columns ' ||
696: ' WHERE table_name = ''' || upper(inTableName) || '''' ||
697: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
698: ' MINUS ' ||
699: ' SELECT column_name, data_type, nullable, data_length ' ||

Line 700: ' FROM all_tab_columns@' || dbLinkName ||

696: ' WHERE table_name = ''' || upper(inTableName) || '''' ||
697: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
698: ' MINUS ' ||
699: ' SELECT column_name, data_type, nullable, data_length ' ||
700: ' FROM all_tab_columns@' || dbLinkName ||
701: ' WHERE table_name = '''|| upper(inTableName) || '''' ||
702: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')' ||
703: ' UNION ' ||
704: '(SELECT column_name, data_type, nullable, data_length ' ||

Line 705: ' FROM all_tab_columns@' || dbLinkName ||

701: ' WHERE table_name = '''|| upper(inTableName) || '''' ||
702: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')' ||
703: ' UNION ' ||
704: '(SELECT column_name, data_type, nullable, data_length ' ||
705: ' FROM all_tab_columns@' || dbLinkName ||
706: ' WHERE table_name = ''' || upper(inTableName) || ''''||
707: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
708: ' MINUS ' ||
709: ' SELECT column_name, data_type, nullable, data_length ' ||

Line 710: ' FROM all_tab_columns ' ||

706: ' WHERE table_name = ''' || upper(inTableName) || ''''||
707: ' AND owner = ''' || CONFIGURATOR_SCHEMA || '''' ||
708: ' MINUS ' ||
709: ' SELECT column_name, data_type, nullable, data_length ' ||
710: ' FROM all_tab_columns ' ||
711: ' WHERE table_name = ''' || upper(inTableName) || '''' ||
712: ' AND owner = ''' || CONFIGURATOR_SCHEMA || ''')',
713: dbms_sql.native);
714: dbms_sql.define_array(cdyn,1,ColumnName,100,1);

Line 759: SELECT column_name FROM all_tab_columns

755: ------------------------------------------------------------------------------------------------------------
756: function get_table_columns(inTableName in varchar2, outNamesArray OUT NOCOPY ColumnNameArray)
757: return integer is
758: cursor c_getcolumns is
759: SELECT column_name FROM all_tab_columns
760: WHERE table_name = upper(inTableName)
761: AND owner = CONFIGURATOR_SCHEMA;
762: nCounter integer := 1;
763: begin