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

MATERIALIZED VIEW: APPS.OPI_INV_TYP_ORG_MV

Object Details
Object Name: OPI_INV_TYP_ORG_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_INV_TYP_ORG_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:

OPI_DBI_INV_TYPE_CODES
OPI_INV_VAL_SUM_MV
     ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
     OPI_DBI_INV_VALUE_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID column
INVENTORY_TYPE VARCHAR2 (3)
Inventory Type: ONH = Onhand, INT = In-transit, WIP = Work in Process
TIME_ID NUMBER

Nested Grouping ID Column for Time
ORGANIZATION_ID NUMBER
Yes Inventory Organization Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
INV_CATEGORY_ID NUMBER

Inventory Category Identifier
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
COUNT_TOTAL NUMBER

Row Count
INV_VALUE_G NUMBER

in Global Currency
COUNT_I_V_G NUMBER

Count Column
INV_VALUE_B NUMBER

in Functional Currency
COUNT_I_V_B NUMBER

Count Column
SOURCE NUMBER

Data source. 1 = OPI, 2 = OPM
Query Text

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


SELECT GRP_ID
,      INVENTORY_TYPE
,      TIME_ID
,      ORGANIZATION_ID
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      YEAR_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      COUNT_TOTAL
,      INV_VALUE_G
,      COUNT_I_V_G
,      INV_VALUE_B
,      COUNT_I_V_B
,      SOURCE
FROM APPS.OPI_INV_TYP_ORG_MV;

Dependencies

[top of page]

APPS.OPI_INV_TYP_ORG_MV references the following:

SchemaAPPS
TableOPI_INV_TYP_ORG_MV
TableOPI_INV_VAL_SUM_MV
Materialized ViewOPI_INV_VAL_SUM_MV
SchemaOPI
TableOPI_DBI_INV_TYPE_CODES

APPS.OPI_INV_TYP_ORG_MV is not referenced by any database object