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


TABLE: APPS.MTH_ITEM_COST_MV

Object Details
Object Name: MTH_ITEM_COST_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.MTH_ITEM_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_ITEM_COST_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ITEM_FK_KEY")
Columns
Name Datatype Length Mandatory Comments
ITEM_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 ITEM_FK_KEY
,      COST
,      TOTAL_ENTRIES
,      NUM_ENTRIES
FROM APPS.MTH_ITEM_COST_MV;

Dependencies

[top of page]

APPS.MTH_ITEM_COST_MV does not reference any database object

APPS.MTH_ITEM_COST_MV is referenced by following:

SchemaAPPS
Materialized ViewMTH_ITEM_COST_MV
Package BodyMTH_PROCESS_OUTPUT_PKG - show dependent code