APPS.AD_ZD_SEED dependencies on DBA_IND_COLUMNS

Line 316: from dba_ind_columns c

312: and i.table_name = x_tab_name
313: and i.uniqueness = 'UNIQUE'
314: and i.index_type <> 'LOB'
315: and not exists ( select null
316: from dba_ind_columns c
317: where c.index_owner = i.owner
318: and c.index_name = i.index_name
319: and c.column_name = 'ZD_EDITION_NAME' );
320:

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 943: from dba_ind_columns c

939: and i.table_name = x_tab_name
940: and i.uniqueness = 'UNIQUE'
941: and i.index_type <> 'LOB'
942: and exists ( select null
943: from dba_ind_columns c
944: where c.index_owner = i.owner
945: and c.index_name = i.index_name
946: and c.column_name = 'ZD_EDITION_NAME' );
947: