APPS.FA_ASSET_TRACE_PVT dependencies on USER_SYNONYMS

Line 231: FROM user_synonyms syn,all_tab_columns col

227: l_col_exclusions := g_col_exclusions;
228:
229:
230: l_stmt :='SELECT syn.synonym_name, column_name
231: FROM user_synonyms syn,all_tab_columns col
232: WHERE col.owner = syn.table_owner
233: AND col.table_name = syn.table_name
234: AND syn.synonym_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);
235:

Line 895: user_synonyms syn

891: IF p_schema <> 'NONE' THEN
892: SELECT count(*)
893: INTO l_both
894: FROM dba_tab_columns col,
895: user_synonyms syn
896: WHERE syn.synonym_name = p_table
897: AND col.owner = syn.table_owner
898: AND col.table_name = syn.table_name
899: AND col.column_name IN (l_primary_column,l_secondary_column);

Line 910: user_synonyms syn

906:
907: SELECT count(*)
908: INTO l_secondary
909: FROM dba_tab_columns col,
910: user_synonyms syn
911: WHERE syn.synonym_name = p_table
912: AND col.owner = syn.table_owner
913: AND col.table_name = syn.table_name
914: AND column_name = l_secondary_column;