APPS.WMS_CROSS_DOCK_PVT dependencies on RCV_TRANSACTIONS

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

1469:
1470: -- Bug# 3281512 - Performance Fixes
1471: -- Take the decode out of the query and just use an IF condition
1472: -- to decide if we should go against transaction_id or interface_transaction_id
1473: -- in the rcv_transactions_table depending on if we are on
1474: -- patchset J or higher.
1475:
1476: BEGIN
1477: SELECT Nvl(po_header_id, -1)

Line 1479: FROM rcv_transactions

1475:
1476: BEGIN
1477: SELECT Nvl(po_header_id, -1)
1478: INTO l_query_rsv_rec.supply_source_header_id
1479: FROM rcv_transactions
1480: -- patchset j changes
1481: WHERE transaction_id = l_txn_supply_source_id;
1482: EXCEPTION
1483: WHEN OTHERS THEN