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

MATERIALIZED VIEW: APPS.MTH_RESOURCE_COST_MV

Object Details
Object Name: MTH_RESOURCE_COST_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MTH_RESOURCE_COST_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_RESOURCE_COST
MTH_RESOURCE_COST

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_FK_KEY NUMBER
Yes
COST NUMBER

TOTAL_ENTRIES NUMBER

NUM_ENTRIES NUMBER

Query Text

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


SELECT RESOURCE_FK_KEY
,      COST
,      TOTAL_ENTRIES
,      NUM_ENTRIES
FROM APPS.MTH_RESOURCE_COST_MV;

Dependencies

[top of page]

APPS.MTH_RESOURCE_COST_MV references the following:

SchemaAPPS
SynonymMTH_RESOURCE_COST
TableMTH_RESOURCE_COST_MV
SchemaMTH
TableMTH_RESOURCE_COST

APPS.MTH_RESOURCE_COST_MV is not referenced by any database object