View: GME_INV_TXN_LOTS_ERES_V

Product:	GME - Process Manufacturing Process Execution
Description:	Supplementary view data based on union all of tables MTL_TRANSACTION_LOTS_TEMP and MTL_TRANSACTION_LOT_NUMBERS
Implementation/DBA Data:	APPS.GME_INV_TXN_LOTS_ERES_V

View Text

SELECT MTLT.TRANSACTION_TEMP_ID
, NULL TRANSACTION_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') UNION ALL SELECT NULL TRANSACTION_TEMP_ID
, 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')

Columns