View: GME_INV_TXNS_TEMP_ERES_V

Product:	GME - Process Manufacturing Process Execution
Description:	Supplementary view data based on table mtl_material_transacions_temp.
Implementation/DBA Data:	APPS.GME_INV_TXNS_TEMP_ERES_V

View Text

SELECT MMTT.INVENTORY_ITEM_ID
, MMTT.ORGANIZATION_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.TRANSACTION_SOURCE_ID
, MMTT.TRANSACTION_ACTION_ID
, MMTT.TRANSACTION_TYPE_ID
, MMTT.TRANSACTION_SOURCE_NAME
, MMTT.TRX_SOURCE_LINE_ID
, MMTT.TRANSACTION_HEADER_ID
, MMTT.TRANSACTION_TEMP_ID
, MMTT.REVISION
, MMTT.LOT_NUMBER
, MLN.PARENT_LOT_NUMBER
, MLN.GRADE_CODE
, MLN.STATUS_ID LOT_STATUS_ID
, MMST.STATUS_CODE LOT_STATUS
, MMTT.SUBINVENTORY_CODE
, MMTT.LOCATOR_ID
, MILK.CONCATENATED_SEGMENTS LOCATOR
, MMTT.TRANSACTION_QUANTITY
, MMTT.TRANSACTION_UOM
, MMTT.TRANSACTION_DATE
, FND_DATE.DATE_TO_DISPLAYDT(MMTT.TRANSACTION_DATE) TRANSACTION_DISPLAY_DATE
, MMTT.REASON_ID
, MTR.REASON_NAME
, MLN.EXPIRATION_DATE LOT_EXPIRATION_DATE
, FND_DATE.DATE_TO_DISPLAYDT(MLN.EXPIRATION_DATE) LOT_EXPIRATION_DISPLAY_DATE
, MMTT.WIP_ENTITY_TYPE
, MMTT.TRANSACTION_LINE_NUMBER
, MMTT.SECONDARY_UOM_CODE
, MMTT.SECONDARY_TRANSACTION_QUANTITY
, MMTT.PRIMARY_QUANTITY
, MMTT.ORIGINAL_TRANSACTION_TEMP_ID
, MMTT.SOURCE_LINE_ID
, MTT.TRANSACTION_TYPE_NAME
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_LOT_NUMBERS MLN
, MTL_TRANSACTION_REASONS MTR
, MTL_ITEM_LOCATIONS_KFV MILK
, MTL_MATERIAL_STATUSES_TL MMST
, MTL_TRANSACTION_TYPES MTT
WHERE MLN.INVENTORY_ITEM_ID (+) = MMTT.INVENTORY_ITEM_ID
AND MLN.ORGANIZATION_ID (+) = MMTT.ORGANIZATION_ID
AND MLN.LOT_NUMBER (+) = MMTT.LOT_NUMBER
AND MTR.REASON_ID (+) = MMTT.REASON_ID
AND MILK.ORGANIZATION_ID (+) = MMTT.ORGANIZATION_ID
AND MILK.SUBINVENTORY_CODE (+) = MMTT.SUBINVENTORY_CODE
AND MILK.INVENTORY_LOCATION_ID (+) = MMTT.LOCATOR_ID
AND MMST.STATUS_ID (+) = MLN.STATUS_ID
AND MMST.LANGUAGE (+) = USERENV('LANG')
AND MTT.TRANSACTION_TYPE_ID = MMTT.TRANSACTION_TYPE_ID

Columns