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


TABLE: APPS.ENI_DBI_INV_BASE_MV

Object Details
Object Name: ENI_DBI_INV_BASE_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableENI.ENI_DBI_INV_BASE_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_DBI_INV_BASE_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnITEM_MASTER_ORG_ID
ColumnITEM_ORG_ID
ColumnITEM_CATEGORY_ID
I_SNAP$_ENI_DBI_INV_BASE_M FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("INVENTORY_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_MASTER_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("QTR_ID")
ColumnSYS_OP_MAP_NONNULL("MONTH_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_MASTER_ORG_ID VARCHAR2 (81)
Item Master Organization Identifier
ITEM_CATEGORY_ID NUMBER

Item Category Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
YEAR_ID NUMBER

FII Year Identifier
QTR_ID NUMBER

FII Quarter Identifier
MONTH_ID NUMBER

FII Month Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
ONHAND_VALUE_G NUMBER

Value of onhand inventory in Primary Global Currency
COUNT_OVG NUMBER

Count Column
ONHAND_VALUE_B NUMBER

Value of onhand inventory in Functional Currency
COUNT_OVB NUMBER

Count Column
INTRANSIT_VALUE_G NUMBER

Value of in-transit inventory in Primary Global Currency
COUNT_IVG NUMBER

Count Column
INTRANSIT_VALUE_B NUMBER

Value of in-transit inventory in Functional Currency
COUNT_IVB NUMBER

Count Column
WIP_VALUE_G NUMBER

Value of WIP inventory in Primary Global Currency
COUNT_WVG NUMBER

Count Column
WIP_VALUE_B NUMBER

Value of WIP inventory in Functional Currency
COUNT_WVB NUMBER

Count Column
INV_TOTAL_VALUE_G NUMBER

Value of total inventory in Primary Global Currency
COUNT_I_T_V_G NUMBER

Count Column
INV_TOTAL_VALUE_B NUMBER

Value of total inventory in Functional Currency
COUNT_I_T_V_B NUMBER

Count Column
ONHAND_VALUE_SG NUMBER

Value of onhand inventory in Secondary Global Currency
CNT_ONHAND_VALUE_SG NUMBER

Count Column
INTRANSIT_VALUE_SG NUMBER

Value of in-transit inventory in Secondary Global Currency
CNT_INTRANSIT_VALUE_SG NUMBER

Count Column
WIP_VALUE_SG NUMBER

Value of WIP inventory in Secondary Global Currency
CNT_WIP_VALUE_SG NUMBER

Count Column
INV_TOTAL_VALUE_SG NUMBER

Value of total inventory in Secondary Global Currency
CNT_INV_TOTAL_VALUE_SG NUMBER

Count Column
COUNT_TOTAL NUMBER

Count Column
GRP_ID NUMBER

Grouping ID Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_ORG_ID
,      ITEM_MASTER_ORG_ID
,      ITEM_CATEGORY_ID
,      TIME_ID
,      YEAR_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      ONHAND_VALUE_G
,      COUNT_OVG
,      ONHAND_VALUE_B
,      COUNT_OVB
,      INTRANSIT_VALUE_G
,      COUNT_IVG
,      INTRANSIT_VALUE_B
,      COUNT_IVB
,      WIP_VALUE_G
,      COUNT_WVG
,      WIP_VALUE_B
,      COUNT_WVB
,      INV_TOTAL_VALUE_G
,      COUNT_I_T_V_G
,      INV_TOTAL_VALUE_B
,      COUNT_I_T_V_B
,      ONHAND_VALUE_SG
,      CNT_ONHAND_VALUE_SG
,      INTRANSIT_VALUE_SG
,      CNT_INTRANSIT_VALUE_SG
,      WIP_VALUE_SG
,      CNT_WIP_VALUE_SG
,      INV_TOTAL_VALUE_SG
,      CNT_INV_TOTAL_VALUE_SG
,      COUNT_TOTAL
,      GRP_ID
FROM APPS.ENI_DBI_INV_BASE_MV;

Dependencies

[top of page]

APPS.ENI_DBI_INV_BASE_MV does not reference any database object

APPS.ENI_DBI_INV_BASE_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_DBI_INV_BASE_MV
Materialized ViewENI_DBI_INV_SUM_MV