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_UPGRADE_PKG dependencies on HXC_TRANSACTION_DETAILS

Line 52: FROM hxc_transaction_details htd,

48: CURSOR get_pay_detail_ids(p_retr_id IN NUMBER)
49: IS SELECT hld.time_building_block_id
50: FROM hxc_latest_details hld
51: WHERE NOT EXISTS ( SELECT 1
52: FROM hxc_transaction_details htd,
53: hxc_transactions ht
54: WHERE hld.time_building_block_id = htd.time_building_block_id
55: AND hld.object_version_number = htd.time_building_block_ovn
56: AND htd.status = 'SUCCESS'

Line 78: FROM hxc_transaction_details htd,

74: CURSOR get_pa_detail_ids(p_retr_id IN NUMBER)
75: IS SELECT hld.time_building_block_id
76: FROM hxc_latest_details hld
77: WHERE NOT EXISTS ( SELECT 1
78: FROM hxc_transaction_details htd,
79: hxc_transactions ht
80: WHERE hld.time_building_block_id = htd.time_building_block_id
81: AND hld.object_version_number = htd.time_building_block_ovn
82: AND htd.status = 'SUCCESS'

Line 881: FROM hxc_transaction_details htd,

877: AND day.object_version_number = det.parent_building_block_ovn
878: AND tc.time_building_block_id = day.parent_building_block_id
879: AND tc.object_version_number = day.parent_building_block_ovn
880: AND NOT EXISTS ( SELECT 1
881: FROM hxc_transaction_details htd,
882: hxc_transactions ht
883: WHERE htd.time_building_block_id = hld.time_building_block_id
884: AND htd.time_building_block_ovn = hld.object_version_number
885: AND htd.transaction_id = ht.transaction_id

Line 933: FROM hxc_transaction_details htd,

929: AND day.object_version_number = det.parent_building_block_ovn
930: AND tc.time_building_block_id = day.parent_building_block_id
931: AND tc.object_version_number = day.parent_building_block_ovn
932: AND NOT EXISTS ( SELECT 1
933: FROM hxc_transaction_details htd,
934: hxc_transactions ht
935: WHERE htd.time_building_block_id = hld.time_building_block_id
936: AND htd.time_building_block_ovn = hld.object_version_number
937: AND htd.transaction_id = ht.transaction_id

Line 1030: FROM hxc_transaction_details htd,

1026: FROM hxc_upg_details_temp temp
1027: WHERE temp.thread_id = p_thread_id
1028: AND temp.detail_attribute2 = 'D'
1029: AND NOT EXISTS ( SELECT 1
1030: FROM hxc_transaction_details htd,
1031: hxc_transactions ht
1032: WHERE htd.time_building_block_id = temp.detail_id
1033: AND htd.time_building_block_ovn < temp.detail_ovn
1034: AND htd.transaction_id = ht.transaction_id

Line 1050: FROM hxc_transaction_details htd,

1046: TO_NUMBER(temp.detail_attribute1)
1047: FROM hxc_upg_details_temp temp
1048: WHERE temp.thread_id = p_thread_id
1049: AND NOT EXISTS ( SELECT 1
1050: FROM hxc_transaction_details htd,
1051: hxc_transactions ht
1052: WHERE htd.time_building_block_id = temp.detail_id
1053: AND htd.time_building_block_ovn = temp.detail_ovn
1054: AND htd.transaction_id = ht.transaction_id

Line 1771: FROM hxc_transaction_details

1767: last_update_date,
1768: last_update_login,
1769: time_building_block_ovn,
1770: data_set_id
1771: FROM hxc_transaction_details
1772: WHERE transaction_id = txnidtab(i)) ;
1773:
1774: put_log('Migrated data to HXC_DEP_TRANSACTION_DETAILS');
1775:

Line 1776: -- Delete DEPOSIT transaction detail records from HXC_TRANSACTION_DETAILS

1772: WHERE transaction_id = txnidtab(i)) ;
1773:
1774: put_log('Migrated data to HXC_DEP_TRANSACTION_DETAILS');
1775:
1776: -- Delete DEPOSIT transaction detail records from HXC_TRANSACTION_DETAILS
1777: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1778: DELETE
1779: FROM hxc_transaction_details
1780: WHERE transaction_id = txnidtab(i) ;

Line 1779: FROM hxc_transaction_details

1775:
1776: -- Delete DEPOSIT transaction detail records from HXC_TRANSACTION_DETAILS
1777: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1778: DELETE
1779: FROM hxc_transaction_details
1780: WHERE transaction_id = txnidtab(i) ;
1781:
1782: put_log('Deleted migrated records from HXC_TRANSACTION_DETAILS');
1783:

Line 1782: put_log('Deleted migrated records from HXC_TRANSACTION_DETAILS');

1778: DELETE
1779: FROM hxc_transaction_details
1780: WHERE transaction_id = txnidtab(i) ;
1781:
1782: put_log('Deleted migrated records from HXC_TRANSACTION_DETAILS');
1783:
1784: COMMIT;
1785: END LOOP;
1786: