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' |