DBA Data[Home] [Help]

APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_TIME_ATTRIBUTE_USAGES_AR

Line 184: into p_tau_ar_count from hxc_time_attribute_usages_ar t;

180: into p_tbb_ar_count from hxc_time_building_blocks_ar t;
181:
182: -- Attributes Usages
183: select/*+ index_ffs (t HXC_TIME_ATTR_USAGES_AR_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
184: into p_tau_ar_count from hxc_time_attribute_usages_ar t;
185:
186: -- Attributes
187: select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_AR_PK ) parallel (t,4)*/ count(time_attribute_id)
188: into p_ta_ar_count from hxc_time_attributes_ar t;

Line 216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);

212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);