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_APP_PERIOD_SUMMARY

Line 127: select /+ index_ffs (t HXC_APP_PERIOD_SUMMARY_PK ) parallel (t,4)/ count(application_period_id)

123: select /*+ index_ffs (t HXC_TC_AP_LINKS_PK ) parallel (t,4)*/ count(timecard_id)
124: into p_tal_count from hxc_tc_ap_links t;
125:
126: -- Application Period Summary
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)

Line 128: into p_aps_count from hxc_app_period_summary t;

124: into p_tal_count from hxc_tc_ap_links t;
125:
126: -- Application Period Summary
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;

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

Line 207: select /+ index_ffs (t HXC_APP_PERIOD_SUMMARY_AR_PK ) parallel (t,4)/ count(application_period_id)

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;
209:
210:
211: -- Create the report

Line 208: into p_aps_ar_count from hxc_app_period_summary_ar t;

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;
209:
210:
211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

Line 222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_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;
226: