INV_UOM_CLASS_CONVERSIONS
This table contains the conversion rates between two base units of measure in two unit of measure classes, uniquely defined for an item. A base unit of measure is the primary unit for a class. This table information is accessed with the Manage UOM Interclass Conversions task.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
INV_UOM_CLASS_CONVERSIONS_PK |
CONVERSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONVERSION_ID | NUMBER | 18 | Yes | Unit of Measure (UOM) conversion identifier. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item identifier | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| FROM_UOM_CODE | VARCHAR2 | 3 | Yes | Base UOM code of the Class of the Primary UOM of the Item | |
| FROM_UOM_CLASS | VARCHAR2 | 10 | Yes | Class of the Primary UOM code of the Item | |
| TO_UOM_CODE | VARCHAR2 | 3 | Yes | Base UOM code to which the conversion is being defined | |
| TO_UOM_CLASS | VARCHAR2 | 10 | Yes | Class of the base UOM to which the conversion is being defined | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CONVERSION_RATE | NUMBER | Yes | Conversion factor by which the To Base UOM is equivalent to the From Base UOM | ||
| DISABLE_DATE | DATE | Date from when the Interclass conversion can no longer be used | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| INVERSE_FLAG | VARCHAR2 | 1 | Contains one of the following values: true or false. If true, then the conversion rate between the secondary unit of the class and the base UOM of the class is modeled as an inverse quantity. In this case, the conversion factor represents "conversion factor" x secondary unit = 1 of the base unit. If false, the conversion factor represents 1 x secondary unit = conversion factor of base unit. The default value is false. | ||
| INVERSE_CONVERSION_RATE | NUMBER | Value entered by the user which is multiplicatively inversed to generate the conversion rate for the pair of units. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| INV_UOM_CLASS_CONVERSIONS | inv_uom_classes_b | FROM_UOM_CLASS |
| INV_UOM_CLASS_CONVERSIONS | inv_uom_classes_b | TO_UOM_CLASS |
| INV_UOM_CLASS_CONVERSIONS | inv_units_of_measure_b | FROM_UOM_CODE |
| INV_UOM_CLASS_CONVERSIONS | inv_units_of_measure_b | TO_UOM_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_UOM_CLASS_CONVERSIONS_N1 | Non Unique | Default | LAST_UPDATE_DATE |
| INV_UOM_CLASS_CONVERSIONS_PK | Unique | Default | CONVERSION_ID |
| INV_UOM_CLASS_CONVERSIONS_U1 | Unique | Default | INVENTORY_ITEM_ID, TO_UOM_CODE |
| INV_UOM_CLASS_CONVERSIONS_U2 | Unique | Default | INVENTORY_ITEM_ID, TO_UOM_CLASS |
| INV_UOM_CLASS_CONVERSIONS_U3 | Unique | Default | INVENTORY_ITEM_ID, FROM_UOM_CODE, TO_UOM_CODE |