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: QPR.QPR_UOM_CONVERSIONS

Object Details

Object Name:	QPR_UOM_CONVERSIONS
Object Type:	TABLE
Owner:	QPR
Subobject Name:
Status:	VALID

This table contains the unit of measure conversion values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_UOM_CONVERSIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	UOM_CONV_ID
QPR_UOM_CONVERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INSTANCE_ID FROM_UOM_CLASS TO_UOM_CLASS FROM_UOM_CODE TO_UOM_CODE ITEM_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
UOM_CONV_ID	NUMBER		Yes	Unique Identifier for units of measure conversion values.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data was sourced.
FROM_UOM_CLASS	VARCHAR2	(40)	Yes	Identifies the unit of measure class from which the conversion takes place.
TO_UOM_CLASS	VARCHAR2	(40)	Yes	Identifies the unit of measure class to which the conversion takes place.
FROM_UOM_CODE	VARCHAR2	(40)	Yes	Identifies the unit of measure code from which the conversion takes place.
TO_UOM_CODE	VARCHAR2	(40)	Yes	Identifies the unit of measure code to which the conversion takes place.
BASE_UOM_FLAG	VARCHAR2	(1)	Yes	Indicates if the from unit of measure code is the base unit of the class mentioned. Takes values 'Y'/'N'.
CONVERSION_RATE	NUMBER		Yes	Value of conversion for the given unit of measure class-code combination.
ITEM_KEY	VARCHAR2	(240)		Identifies the Item for which the conversion applies. If null, then conversion applies to all items.
FROM_UOM_DESC	VARCHAR2	(50)		Describes the unit of measure code from which the conversion takes place.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applicaitons Consurrent Program Login ID
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned the consurrent program
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned the concurrent program

Query Text

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


SELECT UOM_CONV_ID
,      INSTANCE_ID
,      FROM_UOM_CLASS
,      TO_UOM_CLASS
,      FROM_UOM_CODE
,      TO_UOM_CODE
,      BASE_UOM_FLAG
,      CONVERSION_RATE
,      ITEM_KEY
,      FROM_UOM_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM QPR.QPR_UOM_CONVERSIONS;

Dependencies

[top of page]

QPR.QPR_UOM_CONVERSIONS does not reference any database object

QPR.QPR_UOM_CONVERSIONS is referenced by following:

APPS: QPR_UOM_CONVERSIONS