APPS.AD_ZD_TABLE dependencies on DBA_EDITIONING_VIEWS

Line 127: from dba_editioning_views ev

123: L_EV_NAME varchar2(30);
124: begin
125: select ev.view_name
126: into l_ev_name
127: from dba_editioning_views ev
128: where ev.owner = x_table_owner
129: and ev.view_name = ad_zd_table.ev_view(x_table_name);
130:
131: return 'Y';

Line 159: from dba_editioning_views ev

155: L_TABLE_NAME varchar2(30);
156: begin
157: select ev.table_name
158: into l_table_name
159: from dba_editioning_views ev
160: where ev.owner = x_ev_owner
161: and ev.view_name = replace(x_ev_name, '$', '#');
162:
163: return l_table_name;

Line 1322: from dba_editioning_views ev

1318: -- - triggers on base table
1319: -- - TODO: vpd policies on base table
1320: cursor C_REUPGRADE_TABLES is
1321: select ev.owner table_owner, ev.table_name
1322: from dba_editioning_views ev
1323: where ev.owner in
1324: ( select oracle_username from system.fnd_oracle_userid
1325: where read_only_flag in ('A','E','B') )
1326: and ( exists /* uncoverted synonyms */

Line 2198: , dba_editioning_views ev

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
2202: where read_only_flag in ('A','E','B') )

Line 2314: , dba_editioning_views ev

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
2318: where read_only_flag in ('A','E','B')

Line 2339: from dba_unused_col_tabs uct, dba_editioning_views ev

2335: -- EV Tables with unused columns
2336: -- Currently not used, but in future, use this to find tables that need online redef
2337: cursor C_UNUSED_COL_TABS(X_TABLE_OWNER varchar2, X_TABLE_NAME varchar2) is
2338: select ev.owner, ev.table_name
2339: from dba_unused_col_tabs uct, dba_editioning_views ev
2340: where uct.owner in
2341: ( select oracle_username
2342: from system.fnd_oracle_userid
2343: where read_only_flag in ('A','E','B') )

Line 2413: , dba_editioning_views ev

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
2417: where read_only_flag in ('A','E','B') )