DBA Data[Home] [Help]

APPS.CN_CNSYTC_TABLES_PVT dependencies on ALL_TAB_COLUMNS

Line 83: FROM all_tab_columns col, user_synonyms syn

79: CURSOR ext_cols_cur IS
80: SELECT column_name,
81: data_type,
82: data_length
83: FROM all_tab_columns col, user_synonyms syn
84: WHERE syn.synonym_name = p_table_rec.name
85: AND col.owner = syn.table_owner
86: AND col.table_name = syn.table_name
87: AND data_type IN ('CHAR','NCHAR','VARCHAR2','VARCHAR','NVARCHAR2','LONG','NUMBER','DATE');