VIEW: APPS.MTL_ADJ_SYNC_WRAPPER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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