DBA Data[Home] [Help]

APPS.AD_PARALLEL_UPDATES_PKG dependencies on AD_EXTENTS

Line 242: -- For bug 3447980, a view ad_extents is created via adgrants.sql,

238: init_g_cache_update_info(x_owner, x_table, x_script);
239:
240: END create_update_record;
241:
242: -- For bug 3447980, a view ad_extents is created via adgrants.sql,
243: -- using the huge select tested by APPS Performance team.
244: -- This is to replace the Rule optimization
245: -- in ad_parallel_updates_pkg() package.
246:

Line 259: from sys.ad_extents

255: partition_name,
256: segment_type,
257: data_object_id,
258: relative_fno, block_id, blocks
259: from sys.ad_extents
260: where owner = X_owner
261: and segment_name = X_table
262: and segment_type in ('TABLE', 'TABLE PARTITION',
263: 'TABLE SUBPARTITION')