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_PHYSICAL_ADJUSTMENTS#

Source

View Text - Preformatted


select ADJUSTMENT_ID ADJUSTMENT_ID, ORGANIZATION_ID ORGANIZATION_ID, PHYSICAL_INVENTORY_ID PHYSICAL_INVENTORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SUBINVENTORY_NAME SUBINVENTORY_NAME, SYSTEM_QUANTITY SYSTEM_QUANTITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COUNT_QUANTITY COUNT_QUANTITY, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY, REVISION REVISION, LOCATOR_ID LOCATOR_ID, LOT_NUMBER LOT_NUMBER, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE, SERIAL_NUMBER SERIAL_NUMBER, ACTUAL_COST ACTUAL_COST, APPROVAL_STATUS APPROVAL_STATUS, APPROVED_BY_EMPLOYEE_ID APPROVED_BY_EMPLOYEE_ID, AUTOMATIC_APPROVAL_CODE AUTOMATIC_APPROVAL_CODE, GL_ADJUST_ACCOUNT GL_ADJUST_ACCOUNT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LOT_SERIAL_CONTROLS LOT_SERIAL_CONTROLS, TEMP_APPROVER TEMP_APPROVER, PARENT_LPN_ID PARENT_LPN_ID, OUTERMOST_LPN_ID OUTERMOST_LPN_ID, COST_GROUP_ID COST_GROUP_ID, SECONDARY_SYSTEM_QTY SECONDARY_SYSTEM_QTY, SECONDARY_COUNT_QTY SECONDARY_COUNT_QTY, SECONDARY_ADJUSTMENT_QTY SECONDARY_ADJUSTMENT_QTY from "INV"."MTL_PHYSICAL_ADJUSTMENTS"

View Text - HTML Formatted

SELECT ADJUSTMENT_ID ADJUSTMENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PHYSICAL_INVENTORY_ID PHYSICAL_INVENTORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUBINVENTORY_NAME SUBINVENTORY_NAME
, SYSTEM_QUANTITY SYSTEM_QUANTITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COUNT_QUANTITY COUNT_QUANTITY
, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY
, REVISION REVISION
, LOCATOR_ID LOCATOR_ID
, LOT_NUMBER LOT_NUMBER
, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, ACTUAL_COST ACTUAL_COST
, APPROVAL_STATUS APPROVAL_STATUS
, APPROVED_BY_EMPLOYEE_ID APPROVED_BY_EMPLOYEE_ID
, AUTOMATIC_APPROVAL_CODE AUTOMATIC_APPROVAL_CODE
, GL_ADJUST_ACCOUNT GL_ADJUST_ACCOUNT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LOT_SERIAL_CONTROLS LOT_SERIAL_CONTROLS
, TEMP_APPROVER TEMP_APPROVER
, PARENT_LPN_ID PARENT_LPN_ID
, OUTERMOST_LPN_ID OUTERMOST_LPN_ID
, COST_GROUP_ID COST_GROUP_ID
, SECONDARY_SYSTEM_QTY SECONDARY_SYSTEM_QTY
, SECONDARY_COUNT_QTY SECONDARY_COUNT_QTY
, SECONDARY_ADJUSTMENT_QTY SECONDARY_ADJUSTMENT_QTY
FROM "INV"."MTL_PHYSICAL_ADJUSTMENTS"