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_TRANSACTIONS

Line 119: select /+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)/ count(transaction_id)

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;
117:
118: -- Transactions
119: select /*+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)*/ count(transaction_id)
120: into p_trans_count from hxc_transactions t;
121:
122: -- Timecard Approver Links
123: select /*+ index_ffs (t HXC_TC_AP_LINKS_PK ) parallel (t,4)*/ count(timecard_id)

Line 120: into p_trans_count from hxc_transactions t;

116: into p_td_count from hxc_transaction_details t;
117:
118: -- Transactions
119: select /*+ index_ffs (t HXC_TRANSACTIONS_PK ) parallel (t,4)*/ count(transaction_id)
120: into p_trans_count from hxc_transactions t;
121:
122: -- Timecard Approver Links
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;

Line 150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);

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

Line 195: select /+ index_ffs (t HXC_TRANSACTIONS_AR_PK ) parallel (t,4)/ count(transaction_id)

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;
193:
194: -- Transactions
195: select /*+ index_ffs (t HXC_TRANSACTIONS_AR_PK ) parallel (t,4)*/ count(transaction_id)
196: into p_trans_ar_count from hxc_transactions_ar t;
197:
198: -- Timecard Approver Links
199: select /*+ index_ffs (t HXC_TC_AP_LINKS_AR_PK ) parallel (t,4)*/ count(timecard_id)

Line 196: into p_trans_ar_count from hxc_transactions_ar t;

192: into p_td_ar_count from hxc_transaction_details_ar t;
193:
194: -- Transactions
195: select /*+ index_ffs (t HXC_TRANSACTIONS_AR_PK ) parallel (t,4)*/ count(transaction_id)
196: into p_trans_ar_count from hxc_transactions_ar t;
197:
198: -- Timecard Approver Links
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;

Line 219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);

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);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223: