DBA Data[Home] [Help]

APPS.WMS_CROSS_DOCK_PVT dependencies on RCV_TRANSACTIONS

Line 1769: -- in the rcv_transactions_table depending on if we are on

1765:
1766: -- Bug# 3281512 - Performance Fixes
1767: -- Take the decode out of the query and just use an IF condition
1768: -- to decide if we should go against transaction_id or interface_transaction_id
1769: -- in the rcv_transactions_table depending on if we are on
1770: -- patchset J or higher.
1771:
1772: BEGIN
1773: SELECT Nvl(po_header_id, -1)

Line 1775: FROM rcv_transactions

1771:
1772: BEGIN
1773: SELECT Nvl(po_header_id, -1)
1774: INTO l_query_rsv_rec.supply_source_header_id
1775: FROM rcv_transactions
1776: -- patchset j changes
1777: WHERE transaction_id = l_txn_supply_source_id;
1778: EXCEPTION
1779: WHEN OTHERS THEN