VIEW: APPS.GME_INV_TXN_LOTS_TEMP_ERES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')