RCV_SUPPLIER_RETURN_SERIALS_V

Details

• Schema: FUSION

• Object owner: RCV

• Object type: VIEW

Columns

Name
SUPPLIER_RETURN_SERIAL_ID TRANSACTION_TEMP_ID SUPPLIER_RETURN_LINE_ID FROM_SERIAL_NUMBER TO_SERIAL_NUMBER

Query

SQL_Statement

SELECT rsrs.supplier_return_serial_id , NULL AS transaction_temp_id , rsrs.supplier_return_line_id , rsrs.serial_number AS from_serial_number , rsrs.serial_number AS to_serial_number FROM rcv_supplier_return_serials rsrs , rcv_supplier_return_lines rsrl WHERE rsrs.supplier_return_line_id = rsrl.supplier_return_line_id AND rsrl.return_line_status <> 'INCOMPLETE' UNION SELECT NULL AS supplier_return_serial_id , isnt.transaction_temp_id , rsrl.supplier_return_line_id , isnt.fm_serial_number AS from_serial_number , isnt.to_serial_number AS to_serial_number FROM inv_serial_numbers_temp isnt , rcv_supplier_return_lines rsrl WHERE isnt.product_code = 'URTV' AND isnt.product_transaction_id = rsrl.supplier_return_line_id AND rsrl.return_line_status = 'INCOMPLETE'