CSE_TXN_ERROR_LOTS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CSE
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
TRANSACTION_SOURCE TRANSACTION_ID INVENTORY_ITEM_ID LOT_NUMBER |
問合せ
| 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 |