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: TableGMO.GMO_MATERIAL_UNDISPENSES
Subobject Name:
Status: VALID


GMO Material Reverse Dispenses


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMO_MATERIAL_UNDISPENSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNDISPENSE_ID
ColumnDISPENSE_ID
GMO_MATERIAL_UNDISPENSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISPENSE_ID
ColumnINVENTORY_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:

SchemaGMO
ViewGMO_MATERIAL_UNDISPENSES#