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_UNDISPENSES

Object Details

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

GMO Material Reverse Dispenses

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMO_MATERIAL_UNDISPENSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNDISPENSE_ID DISPENSE_ID
GMO_MATERIAL_UNDISPENSES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISPENSE_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UNDISPENSE_ID	NUMBER	(15)	Yes	Reverse Dispense ID
DISPENSE_ID	NUMBER	(15)	Yes	Dispense ID
UNDISPENSE_NUMBER	VARCHAR2	(30)	Yes	Reverse Dispense Number
SOURCE_TRANSACTION_ID	NUMBER	(15)		ID of the source transaction e.g. Batch ID
UNDISPENSE_TYPE	VARCHAR2	(10)	Yes	Reverse 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
UNDISPENSED_DATE	DATE		Yes	Reverse Dispensed Date
UNDISPENSING_MODE	VARCHAR2	(20)	Yes	Reverse Dispensing Mode
DISPENSED_QTY	NUMBER	(15)	Yes	Pending Reverse Dispense Quantity
UNDISPENSED_QTY	NUMBER	(15)		Reverse Dispensed Quantity
GROSS_REQUIRED_WEIGHT	NUMBER	(15)		Required Weight of the reverse 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	(20)		Material Status
LOT_NUMBER	VARCHAR2	(80)		Lot Number
ERECORD_ID	NUMBER			E-record ID
MATERIAL_LOSS	NUMBER			Material Loss
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	Dispense Area
DISPENSE_BOOTH_ID	NUMBER		Yes	Dispense Booth Identifier

Query Text

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


SELECT UNDISPENSE_ID
,      DISPENSE_ID
,      UNDISPENSE_NUMBER
,      SOURCE_TRANSACTION_ID
,      UNDISPENSE_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
,      UNDISPENSED_DATE
,      UNDISPENSING_MODE
,      DISPENSED_QTY
,      UNDISPENSED_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
,      MATERIAL_LOSS
,      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_UNDISPENSES;

Dependencies

[top of page]

GMO.GMO_MATERIAL_UNDISPENSES does not reference any database object

GMO.GMO_MATERIAL_UNDISPENSES is referenced by following:

APPS: GMO_MATERIAL_UNDISPENSES