VIEW: APPS.CSP_MATERIAL_TRANSACTIONS_V1

Source

View Text - Preformatted

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

View Text - HTML Formatted

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