Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view data based on table MTL_TRANSACTION_LOTS_TEMP. |
Implementation/DBA Data: | APPS.GME_INV_TXN_LOTS_TEMP_ERES_V |
SELECT MTLT.GROUP_HEADER_ID
, MTLT.TRANSACTION_TEMP_ID
, MTLT.LOT_NUMBER
, MLN.PARENT_LOT_NUMBER
, MLN.GRADE_CODE
, MLN.STATUS_ID LOT_STATUS_ID
, MMST.STATUS_CODE LOT_STATUS
, MTLT.TRANSACTION_QUANTITY
, MLN.EXPIRATION_DATE LOT_EXPIRATION_DATE
, FND_DATE.DATE_TO_DISPLAYDT(MLN.EXPIRATION_DATE) LOT_EXPIRATION_DISPLAY_DATE
, MTLT.SECONDARY_QUANTITY
, MTLT.PRIMARY_QUANTITY
FROM MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_LOT_NUMBERS MLN
, MTL_MATERIAL_STATUSES_TL MMST
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
WHERE MTLT.TRANSACTION_TEMP_ID = MMTT.TRANSACTION_TEMP_ID
AND MLN.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
AND MLN.LOT_NUMBER = MTLT.LOT_NUMBER
AND MMST.STATUS_ID (+) = MLN.STATUS_ID
AND MMST.LANGUAGE (+) = USERENV('LANG')