DBA Data[Home] [Help] [Dependency Information]

TABLE: ENI.ENI_OLTP_ITEM_STAR

Object Details
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


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_OLTP_ITEM_STAR_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnID
ENI_OLTP_ITEM_STAR_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ENI_OLTP_ITEM_STAR_U3 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnVALUE
ENI_OLTP_ITEM_STAR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINV_CATEGORY_ID
ENI_OLTP_ITEM_STAR_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnVBH_CATEGORY_ID
ENI_OLTP_ITEM_STAR_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnITEM_CATALOG_GROUP_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

ENI.ENI_OLTP_ITEM_STAR does not reference any database object

ENI.ENI_OLTP_ITEM_STAR is referenced by following:

SchemaAPPS
Materialized ViewASO_BI_QLIN_L1_MV
Materialized ViewBIL_BI_OPDTL_MV
Materialized ViewBIL_BI_PIPEC_WG_MV
Materialized ViewBIL_BI_PIPE_MV
Materialized ViewBIM_I_LP_ITEM_MV
Materialized ViewBIM_I_ORD_COL_MV
Materialized ViewBIV_ACT_SUM_MV
Materialized ViewBIV_BAC_SUM_MV
Materialized ViewBIV_CLO_SUM_MV
Materialized ViewBIV_RES_SUM_MV
Materialized ViewENI_DBI_AR_BASE_MV
Materialized ViewENI_DBI_INV_BASE_MV
Materialized ViewENI_DBI_PRC_UNION_MV
Materialized ViewENI_DBI_TOB_MV
Materialized ViewENI_DBI_TOO_MV
SynonymENI_OLTP_ITEM_STAR
Materialized ViewIBE_BI_CAT_MV
Materialized ViewIBE_BI_ITEM_MV
Materialized ViewIBW_PRODUCT_MV
Materialized ViewISC_DBI_CFM_000_MV
Materialized ViewISC_DBI_CFM_002_MV
Materialized ViewISC_DBI_CFM_003_MV
Materialized ViewISC_DBI_CFM_004_MV
Materialized ViewISC_DBI_CFM_005_MV
Materialized ViewISC_DBI_CFM_010_MV
Materialized ViewISC_DBI_CFM_013_MV
Materialized ViewISC_DBI_CPM_000_MV
Materialized ViewISC_DBI_CPM_001_MV
Materialized ViewISC_DBI_CPM_002_MV
Materialized ViewISC_DBI_FM_0000_MV
Materialized ViewISC_DBI_FM_0001_MV
Materialized ViewISC_DBI_FM_0003_MV
Materialized ViewISC_DBI_FM_0007_MV
Materialized ViewISC_DBI_FM_0008_MV
Materialized ViewISC_DBI_PM_0000_MV
Materialized ViewISC_DBI_PM_0001_MV
Materialized ViewISC_DBI_SCR_000_MV
Materialized ViewISC_DBI_SCR_003_MV
Materialized ViewISC_DR_BKLG_01_MV
Materialized ViewISC_DR_CHARGES_01_MV
Materialized ViewISC_DR_COSTS_01_MV
Materialized ViewISC_DR_CURR_01_MV
Materialized ViewISC_DR_MTTR_01_MV
Materialized ViewISC_DR_SERVICE_CODE_MV
Materialized ViewISC_FS_003_MV
Materialized ViewISC_FS_005_MV
Materialized ViewISC_FS_007_MV
Materialized ViewISC_FS_009_MV
Materialized ViewISC_FS_011_MV
Materialized ViewISC_FS_015_MV
Materialized ViewISC_FS_016_MV
Materialized ViewISC_WMS_000_MV
Materialized ViewISC_WMS_001_MV
Materialized ViewOKI_SRM_001_MV
Materialized ViewOKI_SRM_004_MV
Materialized ViewOKI_SRM_005_MV
Materialized ViewOPI_COGS_001_MV
Materialized ViewOPI_CURR_PROD_DEL_001_MV
Materialized ViewOPI_INV_CCA_SUM_MV
Materialized ViewOPI_INV_VAL_SUM_MV
Materialized ViewOPI_JOBS_001_MV
Materialized ViewOPI_MFG_VAR_SUM_MV
Materialized ViewOPI_MTL_VAR_SUM_MV
Materialized ViewOPI_ONTIME_PROD_001_MV
Materialized ViewOPI_PGM_CBN_MV
Materialized ViewOPI_PTP_SUM_F_MV
Materialized ViewOPI_PTP_SUM_STG_MV
Materialized ViewOPI_SCRAP_REASON_001_MV
Materialized ViewOPI_SCRAP_SUM_MV
Materialized ViewOPI_WMS_001_MV
Materialized ViewOPI_WMS_002_MV
Materialized ViewOPI_WMS_004_MV
Materialized ViewOPI_WMS_006_MV
Materialized ViewOPI_WMS_007_MV
Materialized ViewOPI_WMS_008_MV
Materialized ViewOPI_WMS_009_MV