CSE_TXN_ERROR_SERIALS_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
TRANSACTION_SOURCE TRANSACTION_ID INVENTORY_ITEM_ID SERIAL_NUMBER

Query

SQL_Statement

SELECT cte.transaction_source, cte.transaction_id, cte.inventory_item_id, txn_serials.serial_number FROM (SELECT iut_srl.transaction_id transaction_id, iut_srl.serial_number serial_number FROM inv_unit_transactions iut_srl UNION SELECT ilt.transaction_id transaction_id, iut_lot_srl.serial_number serial_number FROM inv_transaction_lot_numbers ilt, inv_unit_transactions iut_lot_srl WHERE iut_lot_srl.transaction_id = ilt.serial_transaction_id ) txn_serials, cse_txn_errors_v cte WHERE (cte.transaction_source = 'WIE_INV_TXN' OR cte.transaction_source = 'INV_MTL_TXN') AND cte.transaction_id = txn_serials.transaction_id