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: OPI.OPI_DBI_UOM_CLASS_STD_CONV

Object Details

Object Name:	OPI_DBI_UOM_CLASS_STD_CONV
Object Type:	TABLE
Owner:	OPI
Subobject Name:
Status:	VALID

This table stored the UOM class conversion rates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FROM_BASE_UOM_CODE	VARCHAR2	(3)	Yes	UOM code of the From Base UOM.
TO_BASE_UOM_CODE	VARCHAR2	(3)	Yes	UOM code of the To Base UOM.
CONV_RATE	NUMBER		Yes	Conversion Rate between the From Base UOM and To Base UOM.
CREATED_BY	NUMBER		Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.
PROGRAM_ID	NUMBER			Standard Who column.
PROGRAM_LOGIN_ID	NUMBER			Standard Who column.
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column.
REQUEST_ID	NUMBER			Standard Who column.

Query Text

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


SELECT FROM_BASE_UOM_CODE
,      TO_BASE_UOM_CODE
,      CONV_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_UOM_CLASS_STD_CONV;

Dependencies

[top of page]

OPI.OPI_DBI_UOM_CLASS_STD_CONV does not reference any database object

OPI.OPI_DBI_UOM_CLASS_STD_CONV is referenced by following:

APPS: OPI_DBI_UOM_CLASS_STD_CONV