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

MATERIALIZED VIEW: APPS.OPI_INV_ITD_ORG_MV

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

FII_TIME_ENT_YEAR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
TRANSACTION_DATE DATE

Transaction date
INV_BALANCE_G NUMBER

Value of inventory in Primary Global Currency
INV_BALANCE_B NUMBER

Value of inventory in Functional Currency
INV_BALANCE_SG NUMBER

Value of inventory in Secondary Global Currency
Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_DATE
,      INV_BALANCE_G
,      INV_BALANCE_B
,      INV_BALANCE_SG
FROM APPS.OPI_INV_ITD_ORG_MV;

Dependencies

[top of page]

APPS.OPI_INV_ITD_ORG_MV references the following:

SchemaAPPS
TableOPI_INV_ITD_ORG_MV
TableOPI_INV_VAL_SUM_MV
Materialized ViewOPI_INV_VAL_SUM_MV
SchemaFII
TableFII_TIME_DAY
TableFII_TIME_ENT_YEAR
TableFII_TIME_RPT_STRUCT

APPS.OPI_INV_ITD_ORG_MV is not referenced by any database object