APPS.AMS_LIST_SRC_FIELD_PVT dependencies on DBA_TAB_COLUMNS

Line 19: -- with user_synonyms and dba_tab_columns

15: -- 20-SEP-2005 batoleti Added p_column_type parameter to insert_row
16: -- and update_row procedure calls.
17: -- Refer bug# 4619184.
18: -- 15-NOV-2012 annsrini Fix for bug 15876260 - Replaced all_tab_columns
19: -- with user_synonyms and dba_tab_columns
20: -- NOTE
21: --
22: -- End of Comments
23: -- ===============================================================

Line 73: dba_tab_columns col

69: AND column_name = UPPER(p_column_name); */
70:
71: SELECT col.COLUMN_NAME
72: FROM user_synonyms syn,
73: dba_tab_columns col
74: WHERE syn.synonym_name = UPPER(p_table_name)
75: and col.owner = syn.table_owner
76: and col.table_name = syn.table_name
77: and col.column_name = UPPER(p_column_name);

Line 328: dba_tab_columns col

324: AND column_name = UPPER(p_column_name); */
325:
326: SELECT col.COLUMN_NAME
327: FROM user_synonyms syn,
328: dba_tab_columns col
329: WHERE syn.synonym_name = UPPER(p_table_name)
330: and col.owner = syn.table_owner
331: and col.table_name = syn.table_name
332: and col.column_name = UPPER(p_column_name);

Line 423: dba_tab_columns col'||'@'||l_database_link||

419: EXECUTE IMMEDIATE
420: 'BEGIN
421: SELECT col.COLUMN_NAME INTO :1
422: FROM user_synonyms syn,
423: dba_tab_columns col'||'@'||l_database_link||
424: ' WHERE syn.synonym_name = UPPER( :1 )'||
425: ' AND col.column_name = UPPER( :2 ) and col.owner = syn.table_owner and col.table_name = syn.table_name; END;'
426: USING l_table_name,
427: p_list_src_field_rec.source_column_name,