APPS.OKE_VERSION_PVT dependencies on ALL_TAB_COLUMNS

Line 154: FROM ALL_TAB_COLUMNS TC,

150:
151: --for bugfix 16433403
152:
153: SELECT /*+ leading(US) MERGE(TC) */ COLUMN_NAME , COLUMN_ID
154: FROM ALL_TAB_COLUMNS TC,
155: (SELECT US.TABLE_OWNER , US.TABLE_NAME
156: FROM USER_SYNONYMS US
157: WHERE US.SYNONYM_NAME = p_table_name ) US
158: WHERE TC.OWNER = US.table_owner

Line 163: FROM USER_SYNONYMS US2 , ALL_TAB_COLUMNS TC2

159: AND TC.TABLE_NAME = US.TABLE_NAME
160: AND TC.COLUMN_NAME <> 'MAJOR_VERSION'
161: AND TC.DATA_TYPE NOT IN ( 'LONG' , 'LONG RAW' )
162: AND EXISTS ( SELECT /*+ no_unnest */ 1
163: FROM USER_SYNONYMS US2 , ALL_TAB_COLUMNS TC2
164: WHERE US2.SYNONYM_NAME = p_hist_table_name
165: AND TC2.TABLE_NAME = US2.TABLE_NAME
166: AND TC2.OWNER = US2.TABLE_OWNER
167: AND TC2.COLUMN_NAME = TC.COLUMN_NAME )

Line 173: from all_tab_columns tc

169:
170: /*
171: -- bug 3720887
172: select column_name, column_id
173: from all_tab_columns tc
174: where (tc.owner,tc.table_name) in (
175: select us.table_owner,us.table_name --modified for bugfix 15926104
176: from user_synonyms us
177: where us.synonym_name = p_table_name)

Line 183: all_tab_columns tc2

179: and tc.data_type not in ('LONG', 'LONG RAW')
180: and exists (
181: select 1
182: from user_synonyms us2,
183: all_tab_columns tc2
184: where us2.synonym_name = p_hist_table_name
185: and tc2.table_name = us2.table_name --modified for bugfix 15926104
186: and tc2.owner = us2.table_owner
187: and tc2.column_name = tc.column_name

Line 193: from all_tab_columns tc

189: order by column_id;*/
190:
191: /*
192: select distinct column_name, column_id
193: from all_tab_columns tc
194: , user_synonyms us
195: where us.synonym_name = p_table_name
196: and tc.table_name = us.synonym_name
197: and tc.owner = us.table_owner

Line 202: from all_tab_columns tc2

198: and tc.column_name <> 'MAJOR_VERSION'
199: and tc.data_type not in ('LONG', 'LONG RAW')
200: and exists (
201: select null
202: from all_tab_columns tc2
203: , user_synonyms us2
204: where us2.synonym_name = p_hist_table_name
205: and tc2.table_name = us2.synonym_name
206: and tc2.owner = us2.table_owner

Line 307: FROM ALL_TAB_COLUMNS TC,

303:
304: --for bugfix 16433403
305:
306: SELECT /*+ leading(US) MERGE(TC) */ COLUMN_NAME , COLUMN_ID
307: FROM ALL_TAB_COLUMNS TC,
308: (SELECT US.TABLE_OWNER , US.TABLE_NAME
309: FROM USER_SYNONYMS US
310: WHERE US.SYNONYM_NAME = p_table_name ) US
311: WHERE TC.OWNER = US.table_owner

Line 316: FROM USER_SYNONYMS US2 , ALL_TAB_COLUMNS TC2

312: AND TC.TABLE_NAME = US.TABLE_NAME
313: AND TC.COLUMN_NAME <> 'MAJOR_VERSION'
314: AND TC.DATA_TYPE NOT IN ( 'LONG' , 'LONG RAW' )
315: AND EXISTS ( SELECT /*+ no_unnest */ 1
316: FROM USER_SYNONYMS US2 , ALL_TAB_COLUMNS TC2
317: WHERE US2.SYNONYM_NAME = p_hist_table_name
318: AND TC2.TABLE_NAME = US2.TABLE_NAME
319: AND TC2.OWNER = US2.TABLE_OWNER
320: AND TC2.COLUMN_NAME = TC.COLUMN_NAME )

Line 326: from all_tab_columns tc

322:
323: /*
324: -- bug 3720887
325: select column_name, column_id
326: from all_tab_columns tc
327: where (tc.owner,tc.table_name) in (
328: select us.table_owner,us.table_name --modified for bugfix 15926104
329: from user_synonyms us
330: where us.synonym_name = p_table_name)

Line 336: all_tab_columns tc2

332: and tc.data_type not in ('LONG', 'LONG RAW')
333: and exists (
334: select 1
335: from user_synonyms us2,
336: all_tab_columns tc2
337: where us2.synonym_name = p_hist_table_name
338: and tc2.table_name = us2.table_name --modified for bugfix 15926104
339: and tc2.owner = us2.table_owner
340: and tc2.column_name = tc.column_name

Line 346: from all_tab_columns tc

342: order by column_id;
343: */
344: /*
345: select distinct column_name, column_id
346: from all_tab_columns tc
347: , user_synonyms us
348: where us.synonym_name = p_table_name
349: and tc.table_name = us.synonym_name
350: and tc.owner = us.table_owner

Line 355: from all_tab_columns tc2

351: and tc.column_name <> 'MAJOR_VERSION'
352: and tc.data_type not in ('LONG', 'LONG RAW')
353: and exists (
354: select null
355: from all_tab_columns tc2
356: , user_synonyms us2
357: where us2.synonym_name = p_hist_table_name
358: and tc2.table_name = us2.synonym_name
359: and tc2.owner = us2.table_owner