APPS.AD_ZD_SEED dependencies on DBA_INDEXES

Line 310: from dba_indexes i

306: L_DDL_STMT varchar2(32767);
307:
308: cursor C_IND_CUR (x_tab_owner varchar2, x_tab_name varchar2) is
309: select i.owner, i.index_name
310: from dba_indexes i
311: where i.table_owner = x_tab_owner
312: and i.table_name = x_tab_name
313: and i.uniqueness = 'UNIQUE'
314: and i.index_type <> 'LOB'

Line 558: from dba_indexes i, dba_constraints c

554: , ic.column_name
555: , nvl(col.nullable, 'Y') nullable
556: from
557: ( select i.owner, i.index_name, c.constraint_name
558: from dba_indexes i, dba_constraints c
559: where i.table_owner = x_owner
560: and i.table_name = x_tab_name
561: and i.uniqueness = 'UNIQUE'
562: and i.index_type = 'NORMAL' /* exclude other index types */

Line 937: from dba_indexes i

933: PRAGMA EXCEPTION_INIT(DUPLICATE_INDEX, -1408);
934:
935: cursor C_IND_CUR (x_tab_owner varchar2, x_tab_name varchar2) is
936: select i.owner, i.index_name
937: from dba_indexes i
938: where i.table_owner = x_tab_owner
939: and i.table_name = x_tab_name
940: and i.uniqueness = 'UNIQUE'
941: and i.index_type <> 'LOB'