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

MATERIALIZED VIEW: APPS.MTH_RES_REQ_IT_MV

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

MTH_GREGORIAN_CALENDAR
MTH_GREGORIAN_CALENDAR
MTH_ITEM_DENORM_D
MTH_ITEM_DENORM_D
MTH_RESOURCE_REQUIREMENTS_F
MTH_RESOURCE_REQUIREMENTS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_FK_KEY NUMBER

LEVEL9_FK_KEY NUMBER

DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

PLANNED_USAGE_QTY NUMBER

PLANNED_USAGE_QTY_COUNT NUMBER

PLANNED_USAGE_VAL NUMBER

PLANNED_USAGE_VAL_COUNT NUMBER

TOTAL_COUNT NUMBER

Query Text

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


SELECT PRODUCT_FK_KEY
,      LEVEL9_FK_KEY
,      DAY_ID
,      CALENDAR_MONTH_ID
,      PLANNED_USAGE_QTY
,      PLANNED_USAGE_QTY_COUNT
,      PLANNED_USAGE_VAL
,      PLANNED_USAGE_VAL_COUNT
,      TOTAL_COUNT
FROM APPS.MTH_RES_REQ_IT_MV;

Dependencies

[top of page]

APPS.MTH_RES_REQ_IT_MV references the following:

SchemaAPPS
SynonymMTH_GREGORIAN_CALENDAR
SynonymMTH_ITEM_DENORM_D
SynonymMTH_RESOURCE_REQUIREMENTS_F
TableMTH_RES_REQ_IT_MV
SchemaMTH
TableMTH_GREGORIAN_CALENDAR
TableMTH_ITEM_DENORM_D
TableMTH_RESOURCE_REQUIREMENTS_F
APPS.MTH_RES_REQ_IT_MV is referenced by following:

SchemaAPPS
Materialized ViewMTH_RES_REQ_LT_MV