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

MATERIALIZED VIEW: MSC.MSC_ITEM_HIERARCHY_MV

Object Details
Object Name: MSC_ITEM_HIERARCHY_MV
Object Type: MATERIALIZED VIEW
Owner: MSC
Subobject Name:
Status: VALID
M-View Details
Container: MSC_ITEM_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
INVENTORY_ITEM_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 INVENTORY_ITEM_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_ITEM_HIERARCHY_MV;

Dependencies

[top of page]

MSC.MSC_ITEM_HIERARCHY_MV references the following:

SchemaMSC
TableMSC_ALLOCATIONS
TableMSC_ALLOCATION_ASSIGNMENTS
TableMSC_ALLOC_RULE_TIME_PHASES
TableMSC_ITEM_CATEGORIES
TableMSC_ITEM_HIERARCHY_MV
TableMSC_SYSTEM_ITEMS

MSC.MSC_ITEM_HIERARCHY_MV is not referenced by any database object