RCV_SUPPLIER_RETURN_SERIALS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: RCV
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SUPPLIER_RETURN_SERIAL_ID TRANSACTION_TEMP_ID SUPPLIER_RETURN_LINE_ID FROM_SERIAL_NUMBER TO_SERIAL_NUMBER |
問合せ
| 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' |