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_HP_MEASURES

Object Details

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

Seeded horizontal plan measures metadata.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_HP_MEASURES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HP_TYPE_CODE MEASURE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
HP_TYPE_CODE	VARCHAR2	(30)	Yes	UI type, lookup type for measure names.
MEASURE_CODE	NUMBER		Yes	Measure identifier.
COLUMN_NAME	VARCHAR2	(30)		Column name.
SUPPLY_TYPES	VARCHAR2	(200)		Comma concatenated supply order_types.
DEMAND_TYPES	VARCHAR2	(200)		Comma concatenated demand origination_types.
EXPRESSION	VARCHAR2	(1000)		Expression.
EDITABLE	NUMBER			Editable flag, 1:can modify existing value, otherwise:read only.
CREATABLE	NUMBER			Creatable flag, 1:can create new record, otherwise:cannot.
DEPENDENT_MEASURES	VARCHAR2	(500)		Comma concatenated dependent measure codes.
AGGR_ORDER	NUMBER			Aggrgation order, 1/null: Calculate then Aggrgate, 2:Aggrgate then Calculate.
AGGR_METHOD_OTHER	VARCHAR2	(20)		Aggrgation method on other dimensions.
AGGR_METHOD_TIME	VARCHAR2	(20)		Aggrgation method on time dimension.
CREATED_BY	NUMBER		Yes	Standard WHO column.
CREATION_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column.

Query Text

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


SELECT HP_TYPE_CODE
,      MEASURE_CODE
,      COLUMN_NAME
,      SUPPLY_TYPES
,      DEMAND_TYPES
,      EXPRESSION
,      EDITABLE
,      CREATABLE
,      DEPENDENT_MEASURES
,      AGGR_ORDER
,      AGGR_METHOD_OTHER
,      AGGR_METHOD_TIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_HP_MEASURES;

Dependencies

[top of page]

MSC.MSC_HP_MEASURES does not reference any database object

MSC.MSC_HP_MEASURES is referenced by following:

MSC: MSC_HP_MEASURES#