[Home] [Help] [Dependency Information]
Object Name: | MTH_ALL_ENTITIES_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | MTH_ALL_ENTITIES_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FORCE |
Build Mode: | IMMEDIATE |
Fast Refreshable: | DIRLOAD_DML |
MTH_EQUIPMENTS_D
MTH_EQUIP_ENTITIES_MST
MTH_PLANTS_D
MTH_RESOURCES_D
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RRID | ROWID | (10) | ||
SITE_ID | NUMBER | |||
ENTITY_PK_KEY | NUMBER | |||
ENTITY_NAME | VARCHAR2 | (100) | ||
ENTITY_TYPE | VARCHAR2 | (30) | ||
PRODUCTION_ENTITY | VARCHAR2 | (1) | ||
ENTITY_PK | VARCHAR2 | (120) | ||
UMARKER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RRID
, SITE_ID
, ENTITY_PK_KEY
, ENTITY_NAME
, ENTITY_TYPE
, PRODUCTION_ENTITY
, ENTITY_PK
, UMARKER
FROM APPS.MTH_ALL_ENTITIES_MV;
|
|
|