[Home] [Help]
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
Name |
TXN_DATE |
ORGID |
ITEM_ID |
SUBINV |
LOCATOR |
QUANTITY |
USER_NAME |
TXNTYPEID |
ERR |