eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 107: select/+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)/ count(time_attribute_usage_id)

103: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_PK ) parallel (t,4)*/ count(time_building_block_id)
104: into p_tbb_count from hxc_time_building_blocks t;
105:
106: -- Attributes Usages
107: select/*+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
108: into p_tau_count from hxc_time_attribute_usages t;
109:
110: -- Attributes
111: select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (t,4)*/ count(time_attribute_id)

Line 108: into p_tau_count from hxc_time_attribute_usages t;

104: into p_tbb_count from hxc_time_building_blocks t;
105:
106: -- Attributes Usages
107: select/*+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
108: into p_tau_count from hxc_time_attribute_usages t;
109:
110: -- Attributes
111: select /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (t,4)*/ count(time_attribute_id)
112: into p_ta_count from hxc_time_attributes t;

Line 147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);

143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);

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);

Line 433: (SELECT 1 FROM hxc_time_attribute_usages tau

429: INTO l_att_diff_check
430: FROM hxc_time_attributes ta, hxc_time_attributes_ar tabkup
431: WHERE ta.time_attribute_id = tabkup.time_attribute_id
432: AND EXISTS
433: (SELECT 1 FROM hxc_time_attribute_usages tau
434: WHERE tau.time_attribute_id = ta.time_attribute_id);
435:
436: --l_att_diff_check := sql%rowcount;
437: