APPS.AD_ZD_TABLE dependencies on DBA_EDITIONING_VIEW_COLS

Line 194: from dba_editioning_view_cols evc

190: L_COLUMN_NAME varchar2(30);
191: begin
192: select evc.table_column_name
193: into l_column_name
194: from dba_editioning_view_cols evc
195: where evc.owner = replace(x_ev_owner, '$', '#')
196: and evc.view_name = x_ev_name
197: and evc.view_column_name = x_column_name;
198:

Line 1025: dba_editioning_view_cols evc

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
1029: and evc.view_name(+) = ad_zd_table.ev_view(col.table_name)

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 2212: from dba_editioning_view_cols evc

2208: and ev.owner = col.owner
2209: and ev.view_name = substrb(col.table_name, 1, 29)||'#'
2210: and not exists
2211: ( select evc.table_column_name
2212: from dba_editioning_view_cols evc
2213: where evc.owner = ev.owner
2214: and evc.view_name = ev.view_name
2215: and evc.table_column_name = col.column_name )
2216: order by col.owner, col.table_name, col.column_name;

Line 2327: from dba_editioning_view_cols evc

2323: and ev.owner = col.owner
2324: and ev.table_name = col.table_name
2325: and not exists
2326: ( select evc.table_column_name
2327: from dba_editioning_view_cols evc
2328: where evc.owner = ev.owner
2329: and evc.view_name = ev.view_name
2330: and evc.table_column_name = col.column_name
2331: )

Line 2425: from dba_editioning_view_cols evc

2421: and ev.owner = col.owner
2422: and ev.view_name = substrb(col.table_name, 1, 29)||'#'
2423: and not exists
2424: ( select evc.table_column_name
2425: from dba_editioning_view_cols evc
2426: where evc.owner = ev.owner
2427: and evc.view_name = ev.view_name
2428: and evc.table_column_name = col.column_name )
2429: order by col.owner, col.table_name, col.column_name;