DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on DBA_TAB_COLUMNS

Line 7133: ' FROM user_synonyms syn, dba_tab_columns col ' ||

7129: ***/
7130:
7131: -- bug#15835530 fix for 12.2 OLP compatible
7132: l_dynamic_sql := ' SELECT COLUMN_NAME, Decode(DATA_TYPE,''NUMBER'',''N'', ''DATE'',''D'',''VARCHAR2'',''V'',NULL) COLUMN_TYPE '|| --BugFix:5503749 (FND_COLUMNS has the TL columns registered for the B table also hence cannot FND_COLUMNS now)
7133: ' FROM user_synonyms syn, dba_tab_columns col ' ||
7134: ' WHERE syn.synonym_name = :1 AND col.owner = syn.table_owner AND col.table_name = syn.table_name ';
7135:
7136: --Bug No:5346472
7137: -- We can't use a bind as :3 which is replaced by

Line 18874: FROM user_synonyms syn, dba_tab_columns col

18870:
18871: -- bug#15835530 fix for 12.2 OLP compatible
18872: SELECT 1
18873: INTO l_dummy_number
18874: FROM user_synonyms syn, dba_tab_columns col
18875: WHERE syn.synonym_name = p_object_name
18876: AND col.owner = syn.table_owner
18877: AND col.table_name = syn.table_name
18878: AND col.column_name = p_column_name;