VIEW: APPS.GME_INV_TXNS_TEMP_ERES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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