APPS.AD_ZD_PREP dependencies on DBA_TAB_COLUMNS

Line 1270: from dba_tab_columns col

1266: || x_column);
1267: -- get old column type information
1268: select col.data_type_owner, col.data_type
1269: into l_type_owner, l_type_name
1270: from dba_tab_columns col
1271: where col.owner = x_owner
1272: and col.table_name = x_table
1273: and col.column_name = x_column;
1274: --

Line 1476: , dba_tab_columns acol

1472: , atab.table_name table_name
1473: , acol.column_name column_name
1474: from
1475: dba_tables atab
1476: , dba_tab_columns acol
1477: where atab.owner in
1478: ( select oracle_username
1479: from SYSTEM.fnd_oracle_userid
1480: where read_only_flag in ('A','B', 'E', 'U', 'C')

Line 1501: , dba_tab_columns acol

1497: , atab.table_name table_name
1498: , acol.column_name column_name
1499: from
1500: dba_tables atab
1501: , dba_tab_columns acol
1502: where acol.owner = atab.owner
1503: and acol.table_name = atab.table_name
1504: and atab.owner IN -- table owner
1505: ( select oracle_username

Line 1836: , dba_tab_columns col

1832: , col.data_type type_name
1833: , col.data_type_owner type_owner
1834: from
1835: dba_tables tab
1836: , dba_tab_columns col
1837: where tab.owner = x_user
1838: and col.owner = tab.owner
1839: and col.table_name = tab.table_name
1840: and col.data_type_owner in -- User defined data type (UDT)

Line 1923: -- such tables will not show up in dba_tab_columns

1919: end loop;
1920:
1921: --(SSTOMAR)
1922: -- TODO: Fix the tables created directly by using a UDT.
1923: -- such tables will not show up in dba_tab_columns
1924: -- e.g. > create table sh_table of sh_type;
1925:
1926: --CASE#2: Table dependent on an XML schema
1927: -- (and TYPES descended from XML schema will also be covered)