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

MATERIALIZED VIEW: MSC.MSC_RESOURCE_HIERARCHY_MV

Object Details
Object Name: MSC_RESOURCE_HIERARCHY_MV
Object Type: MATERIALIZED VIEW
Owner: MSC
Subobject Name:
Status: VALID
M-View Details
Container: MSC_RESOURCE_HIERARCHY_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

MSC_ALLOCATION_ASSIGNMENTS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

DEPARTMENT_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

DEMAND_CLASS VARCHAR2 (30)
ALLOCATION_RULE_NAME VARCHAR2 (30)
ASSIGNMENT_TYPE NUMBER

ALLOCATION_PERCENT NUMBER

EFFECTIVE_DATE DATE

DISABLE_DATE DATE

PRIORITY NUMBER

SERVICE_LEVEL NUMBER

TIME_PHASE_ID NUMBER

CLASS VARCHAR2 (30)
PARTNER_ID NUMBER

PARTNER_SITE_ID NUMBER

LEVEL_ID NUMBER

LEVEL_ALLOC_PERCENT NUMBER

LEVEL_PRIORITY NUMBER

MIN_LEVEL_ALLOC_PERCENT NUMBER

MIN_ALLOCATION_PERCENT NUMBER

Query Text

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


SELECT RESOURCE_ID
,      DEPARTMENT_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      DEMAND_CLASS
,      ALLOCATION_RULE_NAME
,      ASSIGNMENT_TYPE
,      ALLOCATION_PERCENT
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      PRIORITY
,      SERVICE_LEVEL
,      TIME_PHASE_ID
,      CLASS
,      PARTNER_ID
,      PARTNER_SITE_ID
,      LEVEL_ID
,      LEVEL_ALLOC_PERCENT
,      LEVEL_PRIORITY
,      MIN_LEVEL_ALLOC_PERCENT
,      MIN_ALLOCATION_PERCENT
FROM MSC.MSC_RESOURCE_HIERARCHY_MV;

Dependencies

[top of page]

MSC.MSC_RESOURCE_HIERARCHY_MV references the following:

SchemaMSC
TableMSC_ALLOCATIONS
TableMSC_ALLOCATION_ASSIGNMENTS
TableMSC_ALLOC_RULE_TIME_PHASES
TableMSC_DEPARTMENT_RESOURCES
TableMSC_RESOURCE_HIERARCHY_MV

MSC.MSC_RESOURCE_HIERARCHY_MV is not referenced by any database object