APPS.EDW_SYSTEM_PARAMS_PKG dependencies on ALL_TAB_COLUMNS

Line 11: FROM all_tab_columns

7: FROM edw_source_instances_vl
8: WHERE enabled_flag = 'Y';
9: CURSOR cols IS
10: SELECT column_name
11: FROM all_tab_columns
12: WHERE table_name = 'EDW_SYSTEM_PARAMETERS'
13: AND owner=edw_owb_collection_util.get_db_user('BIS')
14: AND column_name NOT IN ('LAST_UPDATE_DATE', 'CREATION_DATE'); --removed Upper for bug#4905343
15: CURSOR sources IS

Line 119: FROM all_tab_columns@' ||l_db_link ||

115: DBMS_SQL.close_cursor(cid);
116:
117: /*
118: l_stmt:='SELECT distinct column_name
119: FROM all_tab_columns@' ||l_db_link ||
120: ' WHERE table_name = ''EDW_LOCAL_SYSTEM_PARAMETERS''
121: AND upper(column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ||
122: ' INTERSECT SELECT distinct column_name from all_tab_columns '||
123: ' WHERE table_name = ''EDW_SYSTEM_PARAMETERS''

Line 122: ' INTERSECT SELECT distinct column_name from all_tab_columns '||

118: l_stmt:='SELECT distinct column_name
119: FROM all_tab_columns@' ||l_db_link ||
120: ' WHERE table_name = ''EDW_LOCAL_SYSTEM_PARAMETERS''
121: AND upper(column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ||
122: ' INTERSECT SELECT distinct column_name from all_tab_columns '||
123: ' WHERE table_name = ''EDW_SYSTEM_PARAMETERS''
124: AND upper(column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ;
125: */
126:

Line 128: l_stmt:= 'SELECT distinct tab.column_name FROM all_tab_columns@'

124: AND upper(column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ;
125: */
126:
127:
128: l_stmt:= 'SELECT distinct tab.column_name FROM all_tab_columns@'
129: ||l_db_link || ' tab ,user_synonyms@' ||l_db_link ||
130: ' syn WHERE tab.table_name = ''EDW_LOCAL_SYSTEM_PARAMETERS''' ||
131: ' and syn.table_name = tab.table_name and tab.owner=syn.table_owner ' ||
132: ' AND upper(tab.column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ||

Line 133: ' INTERSECT SELECT distinct tab.column_name from all_tab_columns tab ,'||

129: ||l_db_link || ' tab ,user_synonyms@' ||l_db_link ||
130: ' syn WHERE tab.table_name = ''EDW_LOCAL_SYSTEM_PARAMETERS''' ||
131: ' and syn.table_name = tab.table_name and tab.owner=syn.table_owner ' ||
132: ' AND upper(tab.column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')' ||
133: ' INTERSECT SELECT distinct tab.column_name from all_tab_columns tab ,'||
134: ' user_synonyms syn WHERE tab.table_name = ''EDW_LOCAL_SYSTEM_PARAMETERS'''||
135: ' and syn.table_name =tab.table_name and tab.owner=syn.table_owner '||
136: 'AND upper(tab.column_name) not in ( ''LAST_UPDATE_DATE'',''CREATION_DATE'')';
137: