[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_WMS_STOR_ITEM_CONV_F |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Fact table that stores the item weight/volume conversions to the corresponding reporting UOMS.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OPI_DBI_WMS_STOR_ITEM_CONV_FU1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization ID. | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item ID. | ||
UNIT_WEIGHT_UOM_CODE | VARCHAR2 | (3) | UOM code of the item's weight. | |
WEIGHT_CONV_RATE | NUMBER | Conversion rate from the item's weight UOM to the DBI weight reporting UOM. | ||
WEIGHT_CONV_RATE_TYPE | NUMBER | Conversion rate type for the weight conversion rate. 1 - Intra-class, 2 - Inter-class, NULL - rate undefined. | ||
UNIT_VOLUME_UOM_CODE | VARCHAR2 | (3) | UOM code of the item's volume. | |
VOLUME_CONV_RATE | NUMBER | Conversion rate from the item's volume UOM to the DBI volume reporting UOM. | ||
VOLUME_CONV_RATE_TYPE | NUMBER | Conversion rate type for the volume conversion rate. 1 - Intra-class, 2 - Inter-class, NULL - rate undefined. | ||
UNIT_DISTANCE_UOM_CODE | VARCHAR2 | (3) | UOM code of the item's distance. | |
DISTANCE_CONV_RATE | NUMBER | Conversion rate from the item's distance UOM to the DBI distance reporting UOM. | ||
DISTANCE_CONV_RATE_TYPE | NUMBER | Conversion rate type for the distance conversion rate. 1 - Intra-class, 2 - Inter-class, NULL - rate undefined. | ||
UNIT_QUANTITY_UOM_CODE | VARCHAR2 | (3) | UOM code of the item's quantity. | |
QUANTITY_CONV_RATE | NUMBER | Conversion rate from the item's quantity UOM to the DBI quantity reporting UOM. | ||
QUANTITY_CONV_RATE_TYPE | NUMBER | Conversion rate type for the quantity conversion rate. 1 - Intra-class, 2 - Inter-class, NULL - rate undefined. | ||
CREATION_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
CREATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard WHO column. | |
PROGRAM_ID | NUMBER | Yes | Standard WHO column. | |
PROGRAM_LOGIN_ID | NUMBER | Yes | Standard WHO column. | |
PROGRAM_APPLICATION_ID | NUMBER | Yes | Standard WHO column. | |
REQUEST_ID | NUMBER | Yes | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, UNIT_WEIGHT_UOM_CODE
, WEIGHT_CONV_RATE
, WEIGHT_CONV_RATE_TYPE
, UNIT_VOLUME_UOM_CODE
, VOLUME_CONV_RATE
, VOLUME_CONV_RATE_TYPE
, UNIT_DISTANCE_UOM_CODE
, DISTANCE_CONV_RATE
, DISTANCE_CONV_RATE_TYPE
, UNIT_QUANTITY_UOM_CODE
, QUANTITY_CONV_RATE
, QUANTITY_CONV_RATE_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM OPI.OPI_DBI_WMS_STOR_ITEM_CONV_F;
OPI.OPI_DBI_WMS_STOR_ITEM_CONV_F does not reference any database object
OPI.OPI_DBI_WMS_STOR_ITEM_CONV_F is referenced by following:
|
|
|