View: CSP_MATERIAL_TRANSACTIONS_V1

Product:	CSP - Spares Management
Description:	Shows material transactions for usage and sales order transactions
Implementation/DBA Data:	APPS.CSP_MATERIAL_TRANSACTIONS_V1

View Text

SELECT MMT.TRANSACTION_DATE
, MMT.ORGANIZATION_ID
, MMT.INVENTORY_ITEM_ID
, MMT.SUBINVENTORY_CODE
, MILK.CONCATENATED_SEGMENTS
, MMT.PRIMARY_QUANTITY * -1
, FU.USER_NAME
, MMT.TRANSACTION_TYPE_ID
, MMT.ERROR_CODE
FROM MTL_ITEM_LOCATIONS_KFV MILK
, FND_USER FU
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.LOCATOR_ID = MILK.INVENTORY_LOCATION_ID (+)
AND FU.USER_ID = MMT.CREATED_BY

Columns