Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view data based on table MTL_TRANSACTION_LOT_NUMBERS. |
Implementation/DBA Data: | APPS.GME_INV_TXN_LOTS_POSTED_ERES_V |
SELECT MTLN.TRANSACTION_ID
, MTLN.LOT_NUMBER
, MLN.PARENT_LOT_NUMBER
, MLN.GRADE_CODE
, MLN.STATUS_ID LOT_STATUS_ID
, MMST.STATUS_CODE LOT_STATUS
, MTLN.TRANSACTION_QUANTITY
, MLN.EXPIRATION_DATE LOT_EXPIRATION_DATE
, FND_DATE.DATE_TO_DISPLAYDT(MLN.EXPIRATION_DATE) LOT_EXPIRATION_DISPLAY_DATE
, MTLN.SECONDARY_TRANSACTION_QUANTITY
, MTLN.PRIMARY_QUANTITY
FROM MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_LOT_NUMBERS MLN
, MTL_MATERIAL_STATUSES_TL MMST
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
AND MLN.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID = MMT.ORGANIZATION_ID
AND MLN.LOT_NUMBER = MTLN.LOT_NUMBER
AND MMST.STATUS_ID (+) = MLN.STATUS_ID
AND MMST.LANGUAGE (+) = USERENV('LANG')