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

MATERIALIZED VIEW: APPS.OPI_WMS_002_MV

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

ENI_OLTP_ITEM_STAR
FII_TIME_DAY
POA_DBI_RTX_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
AGG_LEVEL NUMBER

Aggregation level granularity flag.
GRP_ID NUMBER

Grouping Identifier column.
TIME_ID NUMBER

Nested Grouping Identifier column for Time.
PERIOD_TYPE_ID NUMBER

Period type identifier column for time.
ORGANIZATION_ID NUMBER

Inventory Organization Identifier.
INV_CATEGORY_ID NUMBER

Inventory Category Identifier.
ITEM_ORG_ID VARCHAR2 (81)
Inventory Item Organization Identifier.
UOM_CODE VARCHAR2 (3)
Primary UOM Code.
QTR_ID NUMBER

FII Quarter Identifier.
MONTH_ID NUMBER

FII Month Identifier.
WEEK_ID NUMBER

FII Week Identifier.
DAY_ID NUMBER

FII Day Identifier.
QUANTITY NUMBER

Primary quantity.
C_QUANTITY NUMBER

Count column.
TRANSACTIONS_CNT NUMBER

Count column.
COUNT(*) NUMBER

Row count.
Query Text

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


SELECT AGG_LEVEL
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      ORGANIZATION_ID
,      INV_CATEGORY_ID
,      ITEM_ORG_ID
,      UOM_CODE
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      QUANTITY
,      C_QUANTITY
,      TRANSACTIONS_CNT
,      COUNT(*)
FROM APPS.OPI_WMS_002_MV;

Dependencies

[top of page]

APPS.OPI_WMS_002_MV references the following:

SchemaAPPS
TableOPI_WMS_002_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaPOA
TablePOA_DBI_RTX_F

APPS.OPI_WMS_002_MV is not referenced by any database object