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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMO.GMO_MATERIAL_DISPENSES

Object Details

Object Name:	GMO_MATERIAL_DISPENSES
Object Type:	TABLE
Owner:	GMO
FND Design Data:	GMO.GMO_MATERIAL_DISPENSES
Subobject Name:
Status:	VALID

GMO Material Dispenses

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMO_MATERIAL_DISPENSES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DISPENSE_ID
GMO_MATERIAL_DISPENSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID DISPENSE_ID BATCH_ID
GMO_MATERIAL_DISPENSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID INVENTORY_ITEM_ID
GMO_MATERIAL_DISPENSES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESERVATION_ID MATERIAL_STATUS
GMO_MATERIAL_DISPENSES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MATERIAL_DETAIL_ID MATERIAL_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
DISPENSE_ID	NUMBER	(15)	Yes	Dispense ID
DISPENSE_SOURCE	VARCHAR2	(30)	Yes	Dispense Source e.g. BATCH
DISPENSE_NUMBER	VARCHAR2	(30)	Yes	Dispense Number
DISPENSE_SOURCE_TRANSACTION_ID	NUMBER	(15)		ID of the source transaction e.g. Batch ID
DISPENSE_TYPE	VARCHAR2	(10)	Yes	Dispense Type : Production or Ad hoc
MATERIAL_DETAIL_ID	NUMBER	(10)		Material detail ID
BATCH_ID	NUMBER	(10)		Batch ID
BATCH_STEP_ID	NUMBER	(10)		Batch Step ID
INVENTORY_ITEM_ID	NUMBER	(10)	Yes	Inventory Item ID
ORGANIZATION_ID	NUMBER		Yes	Organization ID
SUBINVENTORY_CODE	VARCHAR2	(10)		Sub inventory or booth Code
SECURITY_CODE	VARCHAR2	(240)		Security code to be used in label printing
DISPENSE_UOM	VARCHAR2	(4)	Yes	Dispense UOM
SOURCE_CONTAINER_DEVICE_ID	NUMBER			Source Container Item ID
TARGET_CONTAINER_DEVICE_ID	NUMBER			Target Container Item ID
DISPENSED_DATE	DATE		Yes	Dispensed Date
DISPENSING_MODE	VARCHAR2	(20)	Yes	Dispensing Mode
REQUIRED_QTY	NUMBER	(15)	Yes	Pending Dispense Quantity
DISPENSED_QTY	NUMBER	(15)		Dispensed Quantity
GROSS_REQUIRED_WEIGHT	NUMBER	(15)		Required Weight of the dispensed container
SOURCE_CONTAINER_TARE	NUMBER	(15)		Source Container tare
SOURCE_CONTAINER_WEIGHT	NUMBER	(15)		Source Container weight
SOURCE_CONTAINER_REWEIGHT	NUMBER	(15)		Source Container Re-weight
ACTUAL_GROSS_WEIGHT	NUMBER	(15)		Target Container Weight
TARGET_CONTAINER_TARE	NUMBER	(15)		Target Container Tare
SOURCE_CONTAINER_ITEM_ID	NUMBER			Source Container Item ID
TARGET_CONTAINER_ITEM_ID	NUMBER			Target Container Item ID
RESERVATION_ID	NUMBER			Material Reservation ID
MATERIAL_STATUS	VARCHAR2	(8)		Material Status
LOT_NUMBER	VARCHAR2	(80)		Lot Number
ERECORD_ID	NUMBER			E-record ID
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
INCLUDE_TARE_FLAG	VARCHAR2	(1)		Tare is included or not
DISPENSE_AREA_ID	NUMBER		Yes	Dispese Area where dispense is performed
DISPENSE_BOOTH_ID	NUMBER		Yes	Dispense Booth where dispense is performed

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DISPENSE_ID
,      DISPENSE_SOURCE
,      DISPENSE_NUMBER
,      DISPENSE_SOURCE_TRANSACTION_ID
,      DISPENSE_TYPE
,      MATERIAL_DETAIL_ID
,      BATCH_ID
,      BATCH_STEP_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      SECURITY_CODE
,      DISPENSE_UOM
,      SOURCE_CONTAINER_DEVICE_ID
,      TARGET_CONTAINER_DEVICE_ID
,      DISPENSED_DATE
,      DISPENSING_MODE
,      REQUIRED_QTY
,      DISPENSED_QTY
,      GROSS_REQUIRED_WEIGHT
,      SOURCE_CONTAINER_TARE
,      SOURCE_CONTAINER_WEIGHT
,      SOURCE_CONTAINER_REWEIGHT
,      ACTUAL_GROSS_WEIGHT
,      TARGET_CONTAINER_TARE
,      SOURCE_CONTAINER_ITEM_ID
,      TARGET_CONTAINER_ITEM_ID
,      RESERVATION_ID
,      MATERIAL_STATUS
,      LOT_NUMBER
,      ERECORD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INCLUDE_TARE_FLAG
,      DISPENSE_AREA_ID
,      DISPENSE_BOOTH_ID
FROM GMO.GMO_MATERIAL_DISPENSES;

Dependencies

[top of page]

GMO.GMO_MATERIAL_DISPENSES does not reference any database object

GMO.GMO_MATERIAL_DISPENSES is referenced by following:

GMO: GMO_MATERIAL_DISPENSES#