APPS.AD_ZD_TABLE dependencies on DBA_INDEXES

Line 1841: from dba_indexes idx

1837: -- drop existing revised index, if any
1838: begin
1839: select idx.index_name
1840: into l_revised_name
1841: from dba_indexes idx
1842: where idx.owner = x_index_owner
1843: and idx.index_name = ad_zd_table.revised_index_name(x_index_name);
1844:
1845: exec('drop index "'||x_index_owner||'"."'||l_revised_name||'"', c_module);

Line 1864: from dba_indexes

1860: decode(nvl(tablespace_name,'???'),'???','','tablespace '||tablespace_name)||
1861: ' storage (initial '||nvl(initial_extent, 128*1024)/1024||'K '||
1862: 'next '||nvl(next_extent, 128*1024)/1024||'K)'
1863: into l_table_owner, l_table_name, l_pre_stmt, l_post_stmt
1864: from dba_indexes
1865: where owner = x_index_owner
1866: and index_name = x_index_name;
1867:
1868: -- prepare column clause

Line 1934: from dba_indexes idx

1930: -- A) Original Index with out of date columns and no Revised Index
1931: -- B) Revised Index with out of date columns
1932: cursor c_ood_indexes(x_table_owner varchar2, x_table_name varchar2) is
1933: select idx.owner, idx.index_name, idx.index_type, idx.partitioned
1934: from dba_indexes idx
1935: where idx.owner in
1936: ( select oracle_username from system.fnd_oracle_userid
1937: where read_only_flag in ('A', 'B', 'E', 'U') )
1938: and idx.owner = idx.table_owner

Line 1947: from dba_indexes idt

1943: (
1944: /* Revised Index does not exist and Original Index is out of date */
1945: not exists
1946: ( select idt.index_name
1947: from dba_indexes idt
1948: where idt.owner = idx.owner
1949: and idt.index_name = ad_zd_table.revised_index_name(idx.index_name) )
1950: and exists
1951: ( select col.column_name

Line 1965: from dba_indexes idt

1961: (
1962: /* Revised Index exists, but is out of date */
1963: exists
1964: ( select idt.index_name
1965: from dba_indexes idt
1966: where idt.owner = idx.owner
1967: and idt.index_name = ad_zd_table.revised_index_name(idx.index_name) )
1968: and exists
1969: ( select col.column_name

Line 2027: dba_indexes ridx

2023: , ridx.table_name table_name
2024: , oidx.index_name original_index
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

Line 2028: , dba_indexes oidx

2024: , oidx.index_name original_index
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') )

Line 2398: dba_indexes idx

2394: cursor C_PATCHED_INDEXES is
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') )