APPS.AMS_LISTSOURCETYPE_PVT dependencies on DBA_TAB_COLUMNS

Line 35: -- with user_synonyms and dba_tab_columns

31: -- creating ANALYTICS data sources.
32: -- 24-Mar-2003 choang bug 2866418 - added UK validation for list source
33: -- type and source type code.
34: -- 16-NOV-2012 annsrini Fix for bug 15876260 - Replaced all_tab_columns
35: -- with user_synonyms and dba_tab_columns
36: ------------------------------------------------------------
37:
38: PROCEDURE Check_ListSrcType_Req_Items (
39: p_listsrctype_rec IN ListSourceType_Rec_Type,

Line 1689: FROM user_synonyms syn, dba_tab_columns col

1685: WHERE table_name = p_source_name
1686: AND data_type IN ('NUMBER', 'VARCHAR2') ; */
1687:
1688: SELECT column_name, data_type
1689: FROM user_synonyms syn, dba_tab_columns col
1690: WHERE syn.synonym_name = p_source_name
1691: AND col.owner = syn.table_owner
1692: AND col.table_name = syn.table_name
1693: AND data_type IN ('NUMBER', 'VARCHAR2')