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_AP_DETAIL_LINKS

Line 131: select /+ index_ffs (t HXC_AP_DETAIL_LINKS_PK ) parallel (t,4)/ count(application_period_id)

127: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_PK ) parallel (t,4)*/ count(application_period_id)
128: into p_aps_count from hxc_app_period_summary t;
129:
130: -- Approval Detail Links
131: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_PK ) parallel (t,4)*/ count(application_period_id)
132: into p_adl_count from hxc_ap_detail_links t;
133:
134: -- Latest Details
135: select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)

Line 132: into p_adl_count from hxc_ap_detail_links t;

128: into p_aps_count from hxc_app_period_summary t;
129:
130: -- Approval Detail Links
131: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_PK ) parallel (t,4)*/ count(application_period_id)
132: into p_adl_count from hxc_ap_detail_links t;
133:
134: -- Latest Details
135: select /*+ index_ffs (t HXC_LATEST_DETAILS_FK ) parallel (t,4)*/ count(time_building_block_id)
136: into p_ld_count from hxc_latest_details t;

Line 153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_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);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:
157:

Line 203: select /+ index_ffs (t HXC_AP_DETAIL_LINKS_AR_PK ) parallel (t,4)/ count(application_period_id)

199: select /*+ index_ffs (t HXC_TC_AP_LINKS_AR_PK ) parallel (t,4)*/ count(timecard_id)
200: into p_tal_ar_count from hxc_tc_ap_links_ar t;
201:
202: -- Application Period Detail links
203: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_AR_PK ) parallel (t,4)*/ count(application_period_id)
204: into p_adl_ar_count from hxc_ap_detail_links_ar t;
205:
206: -- Application Period Summary
207: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)

Line 204: into p_adl_ar_count from hxc_ap_detail_links_ar t;

200: into p_tal_ar_count from hxc_tc_ap_links_ar t;
201:
202: -- Application Period Detail links
203: select /*+ index_ffs (t HXC_AP_DETAIL_LINKS_AR_PK ) parallel (t,4)*/ count(application_period_id)
204: into p_adl_ar_count from hxc_ap_detail_links_ar t;
205:
206: -- Application Period Summary
207: select /*+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)*/ count(application_period_id)
208: into p_aps_ar_count from hxc_app_period_summary_ar t;

Line 221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_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);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:
224:
225: END bkup_table_count_snapshot;