DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_HISTORY_PKG dependencies on RCV_SHIPMENT_LINES

Line 321: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl

317: WHERE rt.parent_transaction_id = rt3.transaction_id
318: AND rt3.transaction_type = 'RETURN TO RECEIVING')
319: )
320: )
321: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl
322: WHERE rsl.shipment_line_id = rt.shipment_line_id
323: AND wms_deploy.get_client_code(rsl.item_id) = p_txns_history_rec.client_code);
324:
325: ELSE