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_ROW_DTLS

Object Details

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

Horizontal plan row header details. This is column flattened table with non-time dimension keys and names.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_HP_ROW_DTLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUERY_ID ROW_INDEX
MSC_HP_ROW_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUERY_ID PLAN_ID SR_INSTANCE_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUERY_ID	NUMBER		Yes	Query identifier.
ROW_INDEX	NUMBER		Yes	Row index.
PLAN_ID	NUMBER		Yes	Plan identifier.
SR_INSTANCE_ID	NUMBER			Source instance identifier.
ORGANIZATION_ID	NUMBER			Organization identifier.
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier.
BASE_ITEM_ID	NUMBER			Base item identifier for configuration.
CATEGORY_SET_ID	NUMBER			Category set identifier.
SR_CATEGORY_ID	NUMBER			Source category identifier.
DEPARTMENT_ID	NUMBER			Department identifier.
RESOURCE_ID	NUMBER			Resource identifier.
ORGANIZATION_CODE	VARCHAR2	(10)		Organization code.
CATEGORY_NAME	VARCHAR2	(250)		Category name.
ITEM_NAME	VARCHAR2	(250)		Item name.
DEPARTMENT_CODE	VARCHAR2	(10)		Department code.
RESOURCE_CODE	VARCHAR2	(16)		Resource code.
DATA_FLAG	NUMBER			Data cache status flag, 1:not fetched, 2:fetched, 3:need refresh.
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 QUERY_ID
,      ROW_INDEX
,      PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      BASE_ITEM_ID
,      CATEGORY_SET_ID
,      SR_CATEGORY_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      ORGANIZATION_CODE
,      CATEGORY_NAME
,      ITEM_NAME
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      DATA_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_HP_ROW_DTLS;

Dependencies

[top of page]

MSC.MSC_HP_ROW_DTLS does not reference any database object

MSC.MSC_HP_ROW_DTLS is referenced by following:

MSC: MSC_HP_ROW_DTLS#