CSE_TXN_ERROR_LOTS_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
TRANSACTION_SOURCE TRANSACTION_ID INVENTORY_ITEM_ID LOT_NUMBER

Query

SQL_Statement
SELECT cte.transaction_source, cte.transaction_id, cte.inventory_item_id, ilt.lot_number FROM inv_transaction_lot_numbers ilt, cse_txn_errors_v cte WHERE (cte.transaction_source = 'WIE_INV_TXN' OR cte.transaction_source = 'INV_MTL_TXN') AND cte.transaction_id = ilt.transaction_id