[Home] [Help]
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
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')
687: , rti.to_organization_id
688: , rti.from_organization_id
689: , rti.transaction_type
690: , oel.flow_status_code
691: FROM oe_order_lines_all oel, rcv_transactions rt, rcv_transactions_interface rti
692: WHERE rti.interface_transaction_id = p_interface_transaction_id
693: AND rti.interface_transaction_id = rt.interface_transaction_id
694: AND oel.line_id = rt.oe_order_line_id
695: AND rti.receipt_source_code = 'CUSTOMER'
707: , rti.to_organization_id
708: , rti.from_organization_id
709: , rti.transaction_type
710: , oel.flow_status_code
711: FROM oe_order_lines_all oel, rcv_transactions rt, rcv_transactions_interface rti
712: WHERE rti.interface_transaction_id = p_interface_transaction_id
713: AND rti.interface_transaction_id = rt.interface_transaction_id
714: AND oel.line_id = rt.oe_order_line_id
715: AND rti.receipt_source_code = 'CUSTOMER'
726: , msn.last_update_date
727: , msn.current_status
728: , wlpn.lpn_context
729: FROM mtl_serial_numbers msn,
730: rcv_transactions_interface rti,
731: mtl_serial_numbers_temp msnt,
732: wms_license_plate_numbers wlpn
733: WHERE rti.interface_transaction_id = p_interface_transaction_id
734: AND msnt.product_code = 'RCV'