[Home] [Help] [Dependency Information]
Object Name: | QPR_UOM_CONVERSIONS |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table contains the unit of measure conversion values.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
QPR.QPR_UOM_CONVERSIONS does not reference any database object
QPR.QPR_UOM_CONVERSIONS is referenced by following:
|
|
|