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


TABLE: APPS.MTH_RESOURCE_COST_MV

Object Details
Object Name: MTH_RESOURCE_COST_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.MTH_RESOURCE_COST_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_MTH_RESOURCE_COST_ FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("RESOURCE_FK_KEY")
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 does not reference any database object

APPS.MTH_RESOURCE_COST_MV is referenced by following:

SchemaAPPS
Package BodyMTH_MV_TO_FACT_PKG - show dependent code
Package BodyMTH_PROCESS_OUTPUT_PKG - show dependent code
Package BodyMTH_PROCESS_STATUS_PKG - show dependent code
Materialized ViewMTH_RESOURCE_COST_MV
Package BodyMTH_UTIL_PKG - show dependent code