DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on RCV_SHIPMENT_LINES

Line 683: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti

679: , rti.item_id
680: , rti.to_organization_id
681: , rti.from_organization_id
682: , rti.transaction_type
683: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti
684: WHERE rti.interface_transaction_id = p_interface_transaction_id
685: AND rti.shipment_line_id = rsl.shipment_line_id
686: AND NOT EXISTS(SELECT 1
687: FROM rcv_shipment_headers rsh

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

696: , rti.item_id
697: , rti.to_organization_id
698: , rti.from_organization_id
699: , rti.transaction_type
700: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti
701: WHERE rti.interface_transaction_id = p_interface_transaction_id
702: AND rti.shipment_line_id = rsl.shipment_line_id
703: AND rsh.shipment_header_id = rsl.shipment_header_id
704: AND rsh.receipt_source_code IN('INTERNAL ORDER', 'INVENTORY')