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.

[Home] [Help]

VIEW: GMO.GMO_MATERIAL_UNDISPENSES#

Source

View Text - Preformatted


select UNDISPENSE_ID UNDISPENSE_ID, DISPENSE_ID DISPENSE_ID, UNDISPENSE_NUMBER UNDISPENSE_NUMBER, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID, UNDISPENSE_TYPE UNDISPENSE_TYPE, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID, BATCH_ID BATCH_ID, BATCH_STEP_ID BATCH_STEP_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, SECURITY_CODE SECURITY_CODE, DISPENSE_UOM DISPENSE_UOM, SOURCE_CONTAINER_DEVICE_ID SOURCE_CONTAINER_DEVICE_ID, TARGET_CONTAINER_DEVICE_ID TARGET_CONTAINER_DEVICE_ID, UNDISPENSED_DATE UNDISPENSED_DATE, UNDISPENSING_MODE UNDISPENSING_MODE, DISPENSED_QTY DISPENSED_QTY, UNDISPENSED_QTY UNDISPENSED_QTY, GROSS_REQUIRED_WEIGHT GROSS_REQUIRED_WEIGHT, SOURCE_CONTAINER_TARE SOURCE_CONTAINER_TARE, SOURCE_CONTAINER_WEIGHT SOURCE_CONTAINER_WEIGHT, SOURCE_CONTAINER_REWEIGHT SOURCE_CONTAINER_REWEIGHT, ACTUAL_GROSS_WEIGHT ACTUAL_GROSS_WEIGHT, TARGET_CONTAINER_TARE TARGET_CONTAINER_TARE, SOURCE_CONTAINER_ITEM_ID SOURCE_CONTAINER_ITEM_ID, TARGET_CONTAINER_ITEM_ID TARGET_CONTAINER_ITEM_ID, RESERVATION_ID RESERVATION_ID, MATERIAL_STATUS MATERIAL_STATUS, LOT_NUMBER LOT_NUMBER, ERECORD_ID ERECORD_ID, MATERIAL_LOSS MATERIAL_LOSS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INCLUDE_TARE_FLAG INCLUDE_TARE_FLAG, DISPENSE_AREA_ID DISPENSE_AREA_ID, DISPENSE_BOOTH_ID DISPENSE_BOOTH_ID from "GMO"."GMO_MATERIAL_UNDISPENSES"

View Text - HTML Formatted

SELECT UNDISPENSE_ID UNDISPENSE_ID
, DISPENSE_ID DISPENSE_ID
, UNDISPENSE_NUMBER UNDISPENSE_NUMBER
, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID
, UNDISPENSE_TYPE UNDISPENSE_TYPE
, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID
, BATCH_ID BATCH_ID
, BATCH_STEP_ID BATCH_STEP_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, SECURITY_CODE SECURITY_CODE
, DISPENSE_UOM DISPENSE_UOM
, SOURCE_CONTAINER_DEVICE_ID SOURCE_CONTAINER_DEVICE_ID
, TARGET_CONTAINER_DEVICE_ID TARGET_CONTAINER_DEVICE_ID
, UNDISPENSED_DATE UNDISPENSED_DATE
, UNDISPENSING_MODE UNDISPENSING_MODE
, DISPENSED_QTY DISPENSED_QTY
, UNDISPENSED_QTY UNDISPENSED_QTY
, GROSS_REQUIRED_WEIGHT GROSS_REQUIRED_WEIGHT
, SOURCE_CONTAINER_TARE SOURCE_CONTAINER_TARE
, SOURCE_CONTAINER_WEIGHT SOURCE_CONTAINER_WEIGHT
, SOURCE_CONTAINER_REWEIGHT SOURCE_CONTAINER_REWEIGHT
, ACTUAL_GROSS_WEIGHT ACTUAL_GROSS_WEIGHT
, TARGET_CONTAINER_TARE TARGET_CONTAINER_TARE
, SOURCE_CONTAINER_ITEM_ID SOURCE_CONTAINER_ITEM_ID
, TARGET_CONTAINER_ITEM_ID TARGET_CONTAINER_ITEM_ID
, RESERVATION_ID RESERVATION_ID
, MATERIAL_STATUS MATERIAL_STATUS
, LOT_NUMBER LOT_NUMBER
, ERECORD_ID ERECORD_ID
, MATERIAL_LOSS MATERIAL_LOSS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INCLUDE_TARE_FLAG INCLUDE_TARE_FLAG
, DISPENSE_AREA_ID DISPENSE_AREA_ID
, DISPENSE_BOOTH_ID DISPENSE_BOOTH_ID
FROM "GMO"."GMO_MATERIAL_UNDISPENSES"