DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on RCV_SHIPMENT_LINES

Line 655: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti

651: , rti.item_id
652: , rti.to_organization_id
653: , rti.from_organization_id
654: , rti.transaction_type
655: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti
656: WHERE rti.interface_transaction_id = p_interface_transaction_id
657: AND rti.shipment_line_id = rsl.shipment_line_id
658: AND NOT EXISTS(SELECT 1
659: FROM rcv_shipment_headers rsh

Line 672: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti

668: , rti.item_id
669: , rti.to_organization_id
670: , rti.from_organization_id
671: , rti.transaction_type
672: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti
673: WHERE rti.interface_transaction_id = p_interface_transaction_id
674: AND rti.shipment_line_id = rsl.shipment_line_id
675: AND rsh.shipment_header_id = rsl.shipment_header_id
676: AND rsh.receipt_source_code IN('INTERNAL ORDER', 'INVENTORY')