eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: INV.MTL_ADJUSTMENT_SYNC_TEMP#

Source

View Text - Preformatted


select TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSACTION_DATE TRANSACTION_DATE, CATEGORY CATEGORY, CATEGORY_ID CATEGORY_ID, WAREHOUSE WAREHOUSE, ORGANIZATION_ID ORGANIZATION_ID, ITEM ITEM, ITEM_DESCRIPTION ITEM_DESCRIPTION, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, SUBINVENTORY SUBINVENTORY, LOCATOR LOCATOR, TRANSFER_WAREHOUSE TRANSFER_WAREHOUSE, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY, TRANSFER_LOCATOR TRANSFER_LOCATOR, LPN LPN, TRANSFER_LPN TRANSFER_LPN, CONTENT_LPN CONTENT_LPN, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE TRANSACTION_SOURCE, CREATION_DATE CREATION_DATE, TRANSACTION_EXTRACTED TRANSACTION_EXTRACTED, XML_DOCUMENT_ID XML_DOCUMENT_ID, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UOM PRIMARY_UOM, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UOM SECONDARY_UOM, ENTITY_ID ENTITY_ID from "INV"."MTL_ADJUSTMENT_SYNC_TEMP"

View Text - HTML Formatted

SELECT TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSACTION_DATE TRANSACTION_DATE
, CATEGORY CATEGORY
, CATEGORY_ID CATEGORY_ID
, WAREHOUSE WAREHOUSE
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM ITEM
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, SUBINVENTORY SUBINVENTORY
, LOCATOR LOCATOR
, TRANSFER_WAREHOUSE TRANSFER_WAREHOUSE
, TRANSFER_SUBINVENTORY TRANSFER_SUBINVENTORY
, TRANSFER_LOCATOR TRANSFER_LOCATOR
, LPN LPN
, TRANSFER_LPN TRANSFER_LPN
, CONTENT_LPN CONTENT_LPN
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, CREATION_DATE CREATION_DATE
, TRANSACTION_EXTRACTED TRANSACTION_EXTRACTED
, XML_DOCUMENT_ID XML_DOCUMENT_ID
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UOM PRIMARY_UOM
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UOM SECONDARY_UOM
, ENTITY_ID ENTITY_ID
FROM "INV"."MTL_ADJUSTMENT_SYNC_TEMP"