APPS.AD_ZD_TABLE dependencies on DBA_TAB_COLUMNS

Line 231: from dba_tab_columns c

227: begin
228: begin
229: select 'Y'
230: into l_is_seed
231: from dba_tab_columns c
232: where c.owner = x_table_owner
233: and c.table_name = x_table_name
234: and c.column_name = 'ZD_EDITION_NAME';
235: exception

Line 1024: from dba_tab_columns col,

1020: select
1021: ad_zd_table.ev_view_column(col.column_name) view_column_name
1022: , max(col.column_name) table_column_name
1023: , min(nvl(evc.view_column_id, 1000+col.column_id)) view_column_id
1024: from dba_tab_columns col,
1025: dba_editioning_view_cols evc
1026: where col.owner = x_table_owner
1027: and col.table_name = x_table_name
1028: and evc.owner(+) = col.owner

Line 1646: from dba_tab_columns col

1642:
1643: -- use first column of base table as triggering column for stub trigger
1644: -- this is to minimize uncessary firing of the stub
1645: select col.column_name into l_upd_column
1646: from dba_tab_columns col
1647: where col.owner = l_table_owner
1648: and col.table_name = l_table_name
1649: and col.column_id = 1;
1650:

Line 1716: from dba_tab_columns col, dba_ind_columns idc, dba_editioning_view_cols evc

1712: -- for seed data sync FCET, update least indexed smallest column in EV
1713: l_upd_ev_name := ad_zd_table.ev_view(l_table_name);
1714: select x.view_column_name into l_upd_column from
1715: ( select evc.view_column_name, count(idc.index_name), col.data_length
1716: from dba_tab_columns col, dba_ind_columns idc, dba_editioning_view_cols evc
1717: where col.owner = l_table_owner
1718: and col.table_name = l_table_name
1719: and evc.owner = col.owner
1720: and evc.view_name = l_upd_ev_name

Line 1735: from dba_tab_columns col, dba_ind_columns idc

1731: -- for ordinary FCET, update least indexed smallest column in base table
1732: l_upd_ev_name := NULL;
1733: select x.column_name into l_upd_column from
1734: ( select col.column_name, count(idc.index_name), col.data_length
1735: from dba_tab_columns col, dba_ind_columns idc
1736: where col.owner = l_table_owner
1737: and col.table_name = l_table_name
1738: and idc.table_owner(+) = col.owner
1739: and idc.table_name(+) = col.table_name

Line 1952: from dba_tab_columns col, dba_ind_columns idc

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
1952: from dba_tab_columns col, dba_ind_columns idc
1953: where col.owner = idx.table_owner
1954: and col.table_name = idx.table_name
1955: and idc.index_owner = idx.owner
1956: and idc.index_name = idx.index_name

Line 1970: from dba_tab_columns col, dba_ind_columns idc

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
1970: from dba_tab_columns col, dba_ind_columns idc
1971: where col.owner = idx.table_owner
1972: and col.table_name = idx.table_name
1973: and idc.index_owner = idx.owner
1974: and idc.index_name = ad_zd_table.revised_index_name(idx.index_name)

Line 2197: , dba_tab_columns col

2193: -- Obsolete columns
2194: cursor C_OBSOLETE_COLUMNS(X_OWNER varchar2, X_TABLE_NAME varchar2) is
2195: select col.owner, col.table_name, col.column_name, col.nullable, col.data_default
2196: from dba_tables tab
2197: , dba_tab_columns col
2198: , dba_editioning_views ev
2199: where tab.owner in
2200: ( select oracle_username
2201: from system.fnd_oracle_userid

Line 2313: from dba_tab_columns col

2309:
2310: -- Obsolete Columns
2311: cursor C_OBSOLETE_COLUMNS(X_TABLE_OWNER varchar2, X_TABLE_NAME varchar2) is
2312: select col.owner, col.table_name, col.column_name
2313: from dba_tab_columns col
2314: , dba_editioning_views ev
2315: where ev.owner in
2316: ( select oracle_username
2317: from system.fnd_oracle_userid

Line 2412: from dba_tab_columns col

2408:
2409: -- Unused Not-Null columns with no default
2410: cursor C_UNUSED_NN_COLUMNS is
2411: select col.owner, col.table_name, col.column_name, col.data_default
2412: from dba_tab_columns col
2413: , dba_editioning_views ev
2414: where col.owner in
2415: ( select oracle_username
2416: from system.fnd_oracle_userid