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

MATERIALIZED VIEW: APPS.ENI_DBI_INV_SUM_MV

Object Details
Object Name: ENI_DBI_INV_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_DBI_INV_SUM_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

ENI_DBI_INV_BASE_MV
     ENI_DBI_ORG_MV
          MTL_PARAMETERS
     ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
     OPI_DBI_INV_VALUE_F
ENI_DBI_ORG_MV
     MTL_PARAMETERS
ENI_DENORM_HIERARCHIES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Nested Grouping ID Column for Time
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
PRODUCT_CATEGORY_ID NUMBER

Product Category Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
ONHAND_VALUE_G NUMBER

Value of onhand inventory in Primary Global Currency
CNT_ONHAND_VALUE_G NUMBER

Count Column
INTRANSIT_VALUE_G NUMBER

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

Count Column
WIP_VALUE_G NUMBER

Value of WIP inventory in Primary Global Currency
CNT_WIP_VALUE_G NUMBER

Count Column
INV_TOTAL_VALUE_G NUMBER

Value of total inventory in Primary Global Currency
CNT_INV_TOTAL_VALUE_G 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
GID NUMBER

Grouping ID Column
MARKER NUMBER

Marker Column
Query Text

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


SELECT TIME_ID
,      INVENTORY_ITEM_ID
,      PRODUCT_CATEGORY_ID
,      ORGANIZATION_ID
,      ITEM_ORG_ID
,      ONHAND_VALUE_G
,      CNT_ONHAND_VALUE_G
,      INTRANSIT_VALUE_G
,      CNT_INTRANSIT_VALUE_G
,      WIP_VALUE_G
,      CNT_WIP_VALUE_G
,      INV_TOTAL_VALUE_G
,      CNT_INV_TOTAL_VALUE_G
,      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
,      GID
,      MARKER
FROM APPS.ENI_DBI_INV_SUM_MV;

Dependencies

[top of page]

APPS.ENI_DBI_INV_SUM_MV references the following:

SchemaAPPS
TableENI_DBI_INV_BASE_MV
Materialized ViewENI_DBI_INV_BASE_MV
TableENI_DBI_INV_SUM_MV
Materialized ViewENI_DBI_ORG_MV
TableENI_DBI_ORG_MV
SchemaENI
TableENI_DENORM_HIERARCHIES

APPS.ENI_DBI_INV_SUM_MV is not referenced by any database object