[Home] [Help]
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
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')
715: , rti.to_organization_id
716: , rti.from_organization_id
717: , rti.transaction_type
718: , oel.flow_status_code
719: FROM oe_order_lines_all oel, rcv_transactions rt, rcv_transactions_interface rti
720: WHERE rti.interface_transaction_id = p_interface_transaction_id
721: AND rti.interface_transaction_id = rt.interface_transaction_id
722: AND oel.line_id = rt.oe_order_line_id
723: AND rti.receipt_source_code = 'CUSTOMER'
735: , rti.to_organization_id
736: , rti.from_organization_id
737: , rti.transaction_type
738: , oel.flow_status_code
739: FROM oe_order_lines_all oel, rcv_transactions rt, rcv_transactions_interface rti
740: WHERE rti.interface_transaction_id = p_interface_transaction_id
741: AND rti.interface_transaction_id = rt.interface_transaction_id
742: AND oel.line_id = rt.oe_order_line_id
743: AND rti.receipt_source_code = 'CUSTOMER'
754: , msn.last_update_date
755: , msn.current_status
756: , wlpn.lpn_context
757: FROM mtl_serial_numbers msn,
758: rcv_transactions_interface rti,
759: mtl_serial_numbers_temp msnt,
760: wms_license_plate_numbers wlpn
761: WHERE rti.interface_transaction_id = p_interface_transaction_id
762: AND msnt.product_code = 'RCV'