[Home] [Help] [Dependency Information]
Object Name: | ENI_OLTP_ITEM_STAR |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This table stores the item definition and its category information
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_OLTP_ITEM_STAR_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | ID |
ENI_OLTP_ITEM_STAR_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
ENI_OLTP_ITEM_STAR_U3 | NORMAL | UNIQUE | APPS_TS_SUMMARY | VALUE |
ENI_OLTP_ITEM_STAR_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | INV_CATEGORY_ID |
ENI_OLTP_ITEM_STAR_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | VBH_CATEGORY_ID |
ENI_OLTP_ITEM_STAR_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ITEM_CATALOG_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | VARCHAR2 | (25) | The Concatenated Item-Organization ID | |
VALUE | VARCHAR2 | (240) | The Item Name | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
PO_CATEGORY_ID | NUMBER | Column no longer used | ||
PO_CATEGORY_SET_ID | NUMBER | Column no longer used | ||
PO_CONCAT_SEG | VARCHAR2 | (200) | Column no longer used | |
INV_CATEGORY_ID | NUMBER | The Inventory Category Identifier | ||
INV_CATEGORY_SET_ID | NUMBER | Inventory Category Set Identifier | ||
INV_CONCAT_SEG | VARCHAR2 | (200) | The Concatenated Value for the Catalog Category | |
VBH_CATEGORY_ID | NUMBER | The Value Based Hierarchy Category Identifier | ||
VBH_CATEGORY_SET_ID | NUMBER | The Value Based Hierarchy Category Set Identifier | ||
VBH_CONCAT_SEG | VARCHAR2 | (200) | The concatenated value for the Value Base Hierarchy Catalog Category | |
MASTER_ID | VARCHAR2 | (25) | For all Items in the Child Org this contains the concatenated Inventory Item ID and the Organization ID of the Master Org | |
CREATION_DATE | DATE | Yes | The Creation Date for the row | |
LAST_UPDATE_DATE | DATE | Yes | The Last Update Date for the row | |
ITEM_CATALOG_GROUP_ID | NUMBER | Item Catalog Group Identifier | ||
PRIMARY_UOM_CODE | VARCHAR2 | (5) | Primary unit of measure | |
UNIT_WEIGHT | NUMBER | Conversion between weight unit of measure and base unit of measure | ||
UNIT_VOLUME | NUMBER | Conversion between volume unit of measure and base unit of measure | ||
WEIGHT_UOM_CODE | VARCHAR2 | (3) | Weight unit of measure code | |
VOLUME_UOM_CODE | VARCHAR2 | (3) | Volume unit of measure code | |
EAM_ITEM_TYPE | NUMBER | Asset Item Type |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, ORGANIZATION_CODE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PO_CATEGORY_ID
, PO_CATEGORY_SET_ID
, PO_CONCAT_SEG
, INV_CATEGORY_ID
, INV_CATEGORY_SET_ID
, INV_CONCAT_SEG
, VBH_CATEGORY_ID
, VBH_CATEGORY_SET_ID
, VBH_CONCAT_SEG
, MASTER_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, ITEM_CATALOG_GROUP_ID
, PRIMARY_UOM_CODE
, UNIT_WEIGHT
, UNIT_VOLUME
, WEIGHT_UOM_CODE
, VOLUME_UOM_CODE
, EAM_ITEM_TYPE
FROM ENI.ENI_OLTP_ITEM_STAR;
ENI.ENI_OLTP_ITEM_STAR does not reference any database object
ENI.ENI_OLTP_ITEM_STAR is referenced by following:
|
|
|