Product: | GME - Process Manufacturing Process Execution |
---|---|
Description: | Supplementary view data based on table mtl_material_transacions |
Implementation/DBA Data: | APPS.GME_INV_TXNS_POSTED_ERES_V |
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