VIEW: APPS.GME_INV_TXNS_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_TEMP_ID, NULL TRANSACTION_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.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 UNION ALL SELECT MMT.INVENTORY_ITEM_ID, MMT.ORGANIZATION_ID, MMT.TRANSACTION_SOURCE_TYPE_ID, MMT.TRANSACTION_SOURCE_ID, MMT.TRANSACTION_ACTION_ID, MMT.TRANSACTION_TYPE_ID, MMT.TRANSACTION_SOURCE_NAME, MMT.TRX_SOURCE_LINE_ID, NULL TRANSACTION_TEMP_ID, MMT.TRANSACTION_ID, MMT.REVISION, NULL LOT_NUMBER, NULL PARENT_LOT_NUMBER, NULL GRADE_CODE, NULL LOT_STATUS_ID, NULL LOT_STATUS, MMT.SUBINVENTORY_CODE, MMT.LOCATOR_ID, MILK.CONCATENATED_SEGMENTS LOCATOR, MMT.TRANSACTION_QUANTITY, MMT.TRANSACTION_UOM, MMT.TRANSACTION_DATE, fnd_date.date_to_displayDT(MMT.TRANSACTION_DATE) TRANSACTION_DISPLAY_DATE, MMT.REASON_ID, MTR.REASON_NAME, NULL LOT_EXPIRATION_DATE, NULL LOT_EXPIRATION_DISPLAY_DATE, MMT.SECONDARY_UOM_CODE, MMT.SECONDARY_TRANSACTION_QUANTITY, MMT.PRIMARY_QUANTITY, MMT.ORIGINAL_TRANSACTION_TEMP_ID, MMT.SOURCE_LINE_ID , MTT.TRANSACTION_TYPE_NAME FROM MTL_MATERIAL_TRANSACTIONS MMT, MTL_TRANSACTION_REASONS MTR, MTL_ITEM_LOCATIONS_KFV MILK , MTL_TRANSACTION_TYPES MTT WHERE MTR.REASON_ID (+) = MMT.REASON_ID AND MILK.ORGANIZATION_ID (+) = MMT.ORGANIZATION_ID AND MILK.SUBINVENTORY_CODE (+) = MMT.SUBINVENTORY_CODE AND MILK.INVENTORY_LOCATION_ID (+) = MMT.LOCATOR_ID AND MTT.TRANSACTION_TYPE_ID = MMT.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_TEMP_ID
, NULL TRANSACTION_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.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 UNION ALL SELECT MMT.INVENTORY_ITEM_ID
, MMT.ORGANIZATION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.TRANSACTION_SOURCE_ID
, MMT.TRANSACTION_ACTION_ID
, MMT.TRANSACTION_TYPE_ID
, MMT.TRANSACTION_SOURCE_NAME
, MMT.TRX_SOURCE_LINE_ID
, NULL TRANSACTION_TEMP_ID
, MMT.TRANSACTION_ID
, MMT.REVISION
, NULL LOT_NUMBER
, NULL PARENT_LOT_NUMBER
, NULL GRADE_CODE
, NULL LOT_STATUS_ID
, NULL LOT_STATUS
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MILK.CONCATENATED_SEGMENTS LOCATOR
, MMT.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MMT.TRANSACTION_DATE
, FND_DATE.DATE_TO_DISPLAYDT(MMT.TRANSACTION_DATE) TRANSACTION_DISPLAY_DATE
, MMT.REASON_ID
, MTR.REASON_NAME
, NULL LOT_EXPIRATION_DATE
, NULL LOT_EXPIRATION_DISPLAY_DATE
, MMT.SECONDARY_UOM_CODE
, MMT.SECONDARY_TRANSACTION_QUANTITY
, MMT.PRIMARY_QUANTITY
, MMT.ORIGINAL_TRANSACTION_TEMP_ID
, MMT.SOURCE_LINE_ID
, MTT.TRANSACTION_TYPE_NAME
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_REASONS MTR
, MTL_ITEM_LOCATIONS_KFV MILK
, MTL_TRANSACTION_TYPES MTT
WHERE MTR.REASON_ID (+) = MMT.REASON_ID
AND MILK.ORGANIZATION_ID (+) = MMT.ORGANIZATION_ID
AND MILK.SUBINVENTORY_CODE (+) = MMT.SUBINVENTORY_CODE
AND MILK.INVENTORY_LOCATION_ID (+) = MMT.LOCATOR_ID
AND MTT.TRANSACTION_TYPE_ID = MMT.TRANSACTION_TYPE_ID