eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_ITEM_HIERARCHY_MV

Object Details

Object Name:	MSC_ITEM_HIERARCHY_MV
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_ITEM_HIERARCHY_MV_N1	NORMAL	NONUNIQUE		INVENTORY_ITEM_ID ORGANIZATION_ID SR_INSTANCE_ID DEMAND_CLASS

Columns

Name	Datatype	Length
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 does not reference any database object

MSC.MSC_ITEM_HIERARCHY_MV is referenced by following:

APPS: MSC_ITEM_HIERARCHY_MV
MSC: MSC_ITEM_HIERARCHY_MV