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: CSI.CSI_INV_DISCREPANCY_TEMP#

Source

View Text - Preformatted


select DISCREPANCY_ID DISCREPANCY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, INV_REVISION INV_REVISION, INV_LOT_NUMBER INV_LOT_NUMBER, INV_QUANTITY INV_QUANTITY, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME, INV_LOCATOR_ID INV_LOCATOR_ID, INSTANCE_ID INSTANCE_ID, II_REVISION II_REVISION, II_LOT_NUMBER II_LOT_NUMBER, II_QUANTITY II_QUANTITY, II_LOCATION_TYPE_CODE II_LOCATION_TYPE_CODE, II_ORGANIZATION_ID II_ORGANIZATION_ID, II_SUBINVENTORY_NAME II_SUBINVENTORY_NAME, II_LOCATOR_ID II_LOCATOR_ID, INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE, MASTER_ORG_TRACKABLE_FLAG MASTER_ORG_TRACKABLE_FLAG, CHILD_ORG_TRACKABLE_FLAG CHILD_ORG_TRACKABLE_FLAG, ERROR_TEXT ERROR_TEXT from "CSI"."CSI_INV_DISCREPANCY_TEMP"

View Text - HTML Formatted

SELECT DISCREPANCY_ID DISCREPANCY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, INV_REVISION INV_REVISION
, INV_LOT_NUMBER INV_LOT_NUMBER
, INV_QUANTITY INV_QUANTITY
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, INV_SUBINVENTORY_NAME INV_SUBINVENTORY_NAME
, INV_LOCATOR_ID INV_LOCATOR_ID
, INSTANCE_ID INSTANCE_ID
, II_REVISION II_REVISION
, II_LOT_NUMBER II_LOT_NUMBER
, II_QUANTITY II_QUANTITY
, II_LOCATION_TYPE_CODE II_LOCATION_TYPE_CODE
, II_ORGANIZATION_ID II_ORGANIZATION_ID
, II_SUBINVENTORY_NAME II_SUBINVENTORY_NAME
, II_LOCATOR_ID II_LOCATOR_ID
, INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, MASTER_ORG_TRACKABLE_FLAG MASTER_ORG_TRACKABLE_FLAG
, CHILD_ORG_TRACKABLE_FLAG CHILD_ORG_TRACKABLE_FLAG
, ERROR_TEXT ERROR_TEXT
FROM "CSI"."CSI_INV_DISCREPANCY_TEMP"