View: INVFV_LOT_TRANSACTIONS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_LOT_TRANSACTIONS

View Text

SELECT MLN.TRANSACTION_ID
, MLN.LOT_NUMBER
, MLN.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI' /* KEYFLEX */
, MLN.ORGANIZATION_ID
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MMT.REVISION
, MLN.TRANSACTION_DATE
, MLN.TRANSACTION_SOURCE_ID
, MLN.TRANSACTION_SOURCE_TYPE_ID
, MTS.TRANSACTION_SOURCE_TYPE_NAME
, MLN.TRANSACTION_SOURCE_NAME
, MLN.SERIAL_TRANSACTION_ID
, MLN.TRANSACTION_QUANTITY
, MLN.PRIMARY_QUANTITY
, MMT.TRANSACTION_UOM
, MSI.PRIMARY_UOM_CODE
FROM MTL_SYSTEM_ITEMS MSI
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTS
, MTL_TRANSACTION_LOT_NUMBERS MLN
WHERE MLN.TRANSACTION_SOURCE_TYPE_ID = MTS.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_ID = MLN.TRANSACTION_ID
AND MSI.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MLN.ORGANIZATION_ID
AND '_SEC:MLN.ORGANIZATION_ID' IS NOT NULL
AND MMT.ORGANIZATION_ID = NVL (MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID)
AND NVL(MMT.OWNING_TP_TYPE
, 2) = 2
AND NVL(MMT.LOGICAL_TRANSACTION
, -99) <> 1 WITH READ ONLY

Columns