[Home] [Help]
View: MTL_LOT_ISSUES_VAL_V
View Text
SELECT MOQ.LOT_NUMBER LOT_NUMBER
, MLN.EXPIRATION_DATE EXPIRATION_DATE
, MOQ.PRIMARY_TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MOQ.SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY
, MOQ.ORGANIZATION_ID
, MOQ.SUBINVENTORY_CODE
, MOQ.REVISION
, MOQ.LOCATOR_ID
, MOQ.INVENTORY_ITEM_ID
, MLN.PARENT_LOT_NUMBER
, MLN.GRADE_CODE
FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ
, MTL_LOT_NUMBERS MLN
WHERE MOQ.ORGANIZATION_ID = MLN.ORGANIZATION_ID
AND MOQ.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID
AND MOQ.LOT_NUMBER = MLN.LOT_NUMBER
AND MOQ.LOT_NUMBER IS NOT NULL
Columns
Name |
LOT_NUMBER |
EXPIRATION_DATE |
TRANSACTION_QUANTITY |
SECONDARY_TRANSACTION_QUANTITY |
ORGANIZATION_ID |
SUBINVENTORY_CODE |
REVISION |
LOCATOR_ID |
INVENTORY_ITEM_ID |
PARENT_LOT_NUMBER |
GRADE_CODE |