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_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_TRANSACTIONS

Line 1754: hxc_transactions ht

1750: det.detail_bb_ovn
1751: FROM hxc_rpt_tc_details_all det,
1752: hxc_rpt_tc_resource_temp gt,
1753: hxc_transaction_details htd,
1754: hxc_transactions ht
1755: WHERE gt.tc_start_time = det.tc_start_time
1756: AND gt.tc_stop_time = det.tc_stop_time
1757: AND gt.resource_id = det.resource_id
1758: AND det.detail_bb_id = htd.time_building_block_id

Line 1867: -- and HXC_TRANSACTIONS to pick up all the transactions and

1863: BEGIN
1864:
1865: -- Public Procedure update_transaction_ids
1866: -- Joins HXC_RPT_TC_DETAILS_ALL against HXC_TRANSACTION_DETAILS,
1867: -- and HXC_TRANSACTIONS to pick up all the transactions and
1868: -- transaction_details for a successful deposit.
1869: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
1870: -- If p_record_save is set to Y, we need to give pseudo transaction_ids
1871: -- to the working status timecards. Do it in the following way.

Line 1899: -- records in hxc_transactions, and have a transaction_id.

1895: -- Saved NULL
1896: -- Submitted 436
1897: --
1898: -- If you observe the above table, all actions except Save creates transaction
1899: -- records in hxc_transactions, and have a transaction_id.
1900: --
1901: -- We need to populate some pseudo transaction_id to the Save actions, and this
1902: -- can be done in the following way.
1903: --