APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_TRANSACTION_DETAILS

Line 61: INDEX(txd HXC_TRANSACTION_DETAILS_FK1)

57: AND dyovn.date_to <> hr_general.end_of_time)
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

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 77: FROM hxc_transaction_details txd1

73: tbb.object_version_number);
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'

Line 3981: FROM hxc_transaction_details td,

3977: BEGIN
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'