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: GMD.GMD_UOM_CONVERSIONS

Object Details

Object Name:	GMD_UOM_CONVERSIONS
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_UOM_CONVERSIONS
Subobject Name:
Status:	VALID

UOM Conversions Based on Quality Results.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_UOM_CONVERSIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_SPEC_DISP_ID TEST_ID
GMD_UOM_CONVERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_SPEC_DISP_ID FROM_QTY_UOM_BASE TO_QTY_UOM_BASE

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_SPEC_DISP_ID	NUMBER		Yes	Sample Group Specficiation Disposition ID
TEST_ID	NUMBER		Yes	Test ID
RESULT_ID	NUMBER			Result ID
COMPOSITE_RESULT_ID	NUMBER			Composite Result ID
FROM_UOM	VARCHAR2	(4)		From UOM
TO_UOM	VARCHAR2	(4)		To UOM
CURRENT_CONVERSION	NUMBER			Corrent UOM Conversion Between From UOM and To UOM
PROPOSED_CONVERSION	NUMBER		Yes	Proposed UOM Conversion Between From UOM and To UOM as per the Test Result
RECOMMENDED_IND	VARCHAR2	(1)		Set to Y when the Proposed UOM Conversion Between From UOM and To UOM is reflected in OPM Inventory; NULL Otherwise.
FROM_UOM_BASE	VARCHAR2	(4)		The unit of measure from where the conversion begins
TO_UOM_BASE	VARCHAR2	(4)		The unit of measure the coversion is converting to
PROPOSED_CONVERSION_BASE	NUMBER		Yes	Proposed UOM Conversion Between the From Base UOM and To Base UOM
DELETE_MARK	NUMBER	(5)	Yes	Delete Mark; 0 = Active, 1 = Deleted
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	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
RESULT_CONV_ID	NUMBER			Surrogate Key
FROM_QTY_UOM	VARCHAR2	(3)		UOM before the update
FROM_QTY_UOM_BASE	VARCHAR2	(3)		Base UOM before the update
TO_QTY_UOM	VARCHAR2	(3)		UOM after the update
TO_QTY_UOM_BASE	VARCHAR2	(3)		Base UOM after the update

Query Text

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


SELECT EVENT_SPEC_DISP_ID
,      TEST_ID
,      RESULT_ID
,      COMPOSITE_RESULT_ID
,      FROM_UOM
,      TO_UOM
,      CURRENT_CONVERSION
,      PROPOSED_CONVERSION
,      RECOMMENDED_IND
,      FROM_UOM_BASE
,      TO_UOM_BASE
,      PROPOSED_CONVERSION_BASE
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESULT_CONV_ID
,      FROM_QTY_UOM
,      FROM_QTY_UOM_BASE
,      TO_QTY_UOM
,      TO_QTY_UOM_BASE
FROM GMD.GMD_UOM_CONVERSIONS;

Dependencies

[top of page]

GMD.GMD_UOM_CONVERSIONS does not reference any database object

GMD.GMD_UOM_CONVERSIONS is referenced by following:

APPS: GMD_UOM_CONVERSIONS