eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GME_INV_TXN_LOTS_ERES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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