APPS.AD_ZD_SEED dependencies on DBA_TAB_COLUMNS

Line 543: from dba_tab_columns

539:
540: -- Table columns (excluding zd_edition_name)
541: cursor C_TAB_COLS(x_tab_owner varchar2, x_tab_name varchar2 ) is
542: select column_name
543: from dba_tab_columns
544: where owner = x_tab_owner
545: and table_name = x_tab_name
546: and column_name <> 'ZD_EDITION_NAME'
547: order by column_id;

Line 571: dba_ind_columns ic, dba_tab_columns col

567: and c.constraint_type(+) = 'P'
568: and i.index_name not like '%~%' /*exclude revised indexes created by a patch */
569: and rownum = 1
570: order by 3,1,2 /* puts PK row first, if it exists */) up,
571: dba_ind_columns ic, dba_tab_columns col
572: where ic.index_owner = up.owner
573: and ic.index_name = up.index_name
574: and ic.column_name <> 'ZD_EDITION_NAME'
575: and ic.table_owner = x_owner

Line 840: from dba_tab_columns

836: -- Check if long column exists
837: select 'Y' into l_exists from dual
838: where exists
839: ( select column_name
840: from dba_tab_columns
841: where owner = l_table_owner
842: and table_name = l_table_name
843: and data_type = 'LONG' );
844:

Line 1293: dba_tab_columns col

1289: -- in the current RUN EDITION
1290: cursor C_PATCHED_SEED_TABLES is
1291: select col.owner, col.table_name
1292: from
1293: dba_tab_columns col
1294: , user_objects obj
1295: where col.owner in
1296: ( select oracle_username from system.fnd_oracle_userid
1297: where read_only_flag in ('A','E') )

Line 1370: dba_tab_columns col

1366:
1367: cursor C_PREPARED_SEED_TABLES is
1368: select col.owner, col.table_name
1369: from
1370: dba_tab_columns col
1371: , user_objects_ae obj
1372: where col.owner in
1373: ( select oracle_username from system.fnd_oracle_userid
1374: where read_only_flag in ('A','E') )