DBA Data[Home] [Help]

APPS.AD_ZD_TABLE dependencies on DBA_CONSTRAINTS

Line 2029: , dba_constraints con

2025: , con.constraint_name constraint_name
2026: from
2027: dba_indexes ridx
2028: , dba_indexes oidx
2029: , dba_constraints con
2030: where ridx.owner in
2031: ( select oracle_username from system.fnd_oracle_userid
2032: where read_only_flag in ('A', 'B', 'E', 'U') )
2033: and ridx.table_owner = x_table_owner

Line 2399: , dba_constraints con

2395: select idx.owner, idx.index_name,
2396: con.owner table_owner, con.table_name, con.constraint_name
2397: from
2398: dba_indexes idx
2399: , dba_constraints con
2400: where idx.owner in
2401: ( select oracle_username from system.fnd_oracle_userid
2402: where read_only_flag in ('A', 'B', 'E', 'U') )
2403: and regexp_like(idx.index_name, ad_zd_table.revised_index_regexp, 'c')