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_ATTRIBUTES

Line 111: select /+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (t,4)/ count(time_attribute_id)

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;
113:
114: -- Transaction Details
115: select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)

Line 112: into p_ta_count from hxc_time_attributes t;

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;
113:
114: -- Transaction Details
115: select /*+ index_ffs (t HXC_TRANSACTION_DETAILS_PK ) parallel (t,4)*/ count(transaction_detail_id)
116: into p_td_count from hxc_transaction_details t;

Line 148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);

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);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);

Line 187: select /+ index_ffs (t HXC_TIME_ATTRIBUTES_AR_PK ) parallel (t,4)/ count(time_attribute_id)

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;
189:
190: -- Transaction Details
191: select /*+ index_ffs (t HXC_TRANS_DETAILS_AR_PK ) parallel (t,4)*/ count(transaction_detail_id)

Line 188: into p_ta_ar_count from hxc_time_attributes_ar t;

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;
189:
190: -- Transaction Details
191: select /*+ index_ffs (t HXC_TRANS_DETAILS_AR_PK ) parallel (t,4)*/ count(transaction_detail_id)
192: into p_td_ar_count from hxc_transaction_details_ar t;

Line 217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);

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);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);

Line 428: SELECT /+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (4)/ count(ta.time_attribute_id)

424: -- warning
425: fnd_file.put_line(fnd_file.LOG,'=== > SOME ATTRIBUTES WERE SHARED ');
426: retcode := 1;
427:
428: SELECT /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (4)*/ count(ta.time_attribute_id)
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

Line 430: FROM hxc_time_attributes ta, hxc_time_attributes_ar tabkup

426: retcode := 1;
427:
428: SELECT /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (4)*/ count(ta.time_attribute_id)
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);