VIEW: APPS.GME_INV_TXNS_POSTED_ERES_V

Source

View Text - Preformatted

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, MMT.TRANSACTION_ID, MMT.REVISION, 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, 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 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
, MMT.TRANSACTION_ID
, MMT.REVISION
, 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
, 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