DBA Data[Home] [Help]

APPS.CN_SYS_TABLES_PVT dependencies on ALL_TAB_COLUMNS

Line 880: FROM all_tab_columns

876: AND object_type = 'TBL';
877:
878: CURSOR l_valid_col_csr(p_table_id number) IS
879: SELECT count(*)
880: FROM all_tab_columns
881: WHERE owner = p_schema_name
882: AND table_name = p_table_name
883: AND column_name = p_column_name
884: AND NOT EXISTS

Line 894: FROM all_tab_columns

890: AND object_type = 'COL');
891:
892: CURSOR l_col_data_csr IS
893: SELECT data_type, data_length
894: FROM all_tab_columns
895: WHERE owner = p_schema_name
896: AND table_name = p_table_name
897: AND column_name = p_column_name
898: AND data_type IN