View: MTL_ADJ_SYNC_WRAPPER_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_ADJ_SYNC_WRAPPER_V

View Text

SELECT TRANSACTION_NUMBER
, TRANSACTION_DATE
, CATEGORY
, CATEGORY_ID
, WAREHOUSE
, ORGANIZATION_ID
, ITEM
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY
, LOCATOR
, TRANSFER_WAREHOUSE
, TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR
, LPN
, TRANSFER_LPN
, CONTENT_LPN
, TRANSACTION_TYPE
, TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE
, CREATION_DATE
, TRANSACTION_EXTRACTED
, XML_DOCUMENT_ID
, SUM(TRANSACTION_QUANTITY)
, TRANSACTION_UOM
, SUM(PRIMARY_QUANTITY)
, PRIMARY_UOM
, SUM(SECONDARY_QUANTITY)
, SECONDARY_UOM
FROM MTL_ADJUSTMENT_TXN_SYNC_V GROUP BY TRANSACTION_NUMBER
, TRANSACTION_DATE
, CATEGORY
, CATEGORY_ID
, WAREHOUSE
, ORGANIZATION_ID
, ITEM
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, REVISION
, SUBINVENTORY
, LOCATOR
, TRANSFER_WAREHOUSE
, TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR
, LPN
, TRANSFER_LPN
, CONTENT_LPN
, TRANSACTION_TYPE
, TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE
, CREATION_DATE
, TRANSACTION_EXTRACTED
, XML_DOCUMENT_ID
, TRANSACTION_UOM
, PRIMARY_UOM
, SECONDARY_UOM

Columns