APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_TRANSACTIONS

Line 62: INDEX(tx HXC_TRANSACTIONS_PK) */

58: AND tbb.date_to <> hr_general.end_of_time
59: AND EXISTS (
60: SELECT /*+ LEADING(txd)
61: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)
62: INDEX(tx HXC_TRANSACTIONS_PK) */
63: 'x'
64: FROM hxc_transaction_details txd, hxc_transactions tx
65: WHERE tx.transaction_process_id = -1
66: AND tx.TYPE = 'RETRIEVAL'

Line 64: FROM hxc_transaction_details txd, hxc_transactions tx

60: SELECT /*+ LEADING(txd)
61: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)
62: INDEX(tx HXC_TRANSACTIONS_PK) */
63: 'x'
64: FROM hxc_transaction_details txd, hxc_transactions tx
65: WHERE tx.transaction_process_id = -1
66: AND tx.TYPE = 'RETRIEVAL'
67: AND tx.status = 'SUCCESS'
68: AND tx.transaction_id = txd.transaction_id

Line 78: ,hxc_transactions tx1

74:
75: /*AND NOT EXISTS
76: (select 'x'
77: FROM hxc_transaction_details txd1
78: ,hxc_transactions tx1
79: WHERE tx1.transaction_process_id = -1
80: AND tx1.type = 'RETRIEVAL'
81: AND tx1.status = 'SUCCESS'
82: AND tx1.transaction_id = txd1.transaction_id

Line 3982: hxc_transactions t

3978:
3979: SELECT 1
3980: INTO l_retrieved
3981: FROM hxc_transaction_details td,
3982: hxc_transactions t
3983: WHERE td.time_building_block_id = g_detail_tab(i).detail_bb_id
3984: AND td.time_building_block_ovn <= g_detail_tab(i).detail_bb_ovn
3985: AND td.status = 'SUCCESS'
3986: AND t.transaction_id = td.transaction_id