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

Source

View Text - Preformatted


select DISPENSE_ID DISPENSE_ID, DISPENSE_SOURCE DISPENSE_SOURCE, DISPENSE_NUMBER DISPENSE_NUMBER, DISPENSE_SOURCE_TRANSACTION_ID DISPENSE_SOURCE_TRANSACTION_ID, DISPENSE_TYPE DISPENSE_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, DISPENSED_DATE DISPENSED_DATE, DISPENSING_MODE DISPENSING_MODE, REQUIRED_QTY REQUIRED_QTY, DISPENSED_QTY DISPENSED_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, 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_DISPENSES"

View Text - HTML Formatted

SELECT DISPENSE_ID DISPENSE_ID
, DISPENSE_SOURCE DISPENSE_SOURCE
, DISPENSE_NUMBER DISPENSE_NUMBER
, DISPENSE_SOURCE_TRANSACTION_ID DISPENSE_SOURCE_TRANSACTION_ID
, DISPENSE_TYPE DISPENSE_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
, DISPENSED_DATE DISPENSED_DATE
, DISPENSING_MODE DISPENSING_MODE
, REQUIRED_QTY REQUIRED_QTY
, DISPENSED_QTY DISPENSED_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
, 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_DISPENSES"