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: FEM.FEM_HIERVAL_VSR_T

Object Details

Object Name:	FEM_HIERVAL_VSR_T
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_HIERVAL_VSR_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	REQUEST_ID PARENT_ID PARENT_VALUE_SET_ID CHILD_ID CHILD_VALUE_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_HIER_T_ROWID	ROWID	(10)	Yes	ROWID of the relationship record from the source HIER_T table
REQUEST_ID	NUMBER		Yes	Request ID of the master process under which the loader is running
PARENT_DEPTH_NUM	NUMBER		Yes	Depth of the parent node to the root node
PARENT_ID	NUMBER		Yes	Identifier of the parent member
PARENT_VALUE_SET_ID	NUMBER		Yes	Identifier of the value set of the parent member
CHILD_DEPTH_NUM	NUMBER		Yes	Depth of the child node to the root node
CHILD_ID	NUMBER		Yes	Identifier of the child member
CHILD_VALUE_SET_ID	NUMBER		Yes	Identifier of the value set of the child member
DISPLAY_ORDER_NUM	NUMBER		Yes	The relative order that the child is displayed on the user-interface
CHILD_DIMENSION_GRP_ID	NUMBER			Dimension Group of the child member
WEIGHTING_PCT	NUMBER	(3)		The percentage for weighting of values received from the immediate parent
PARENT_DIMENSION_GRP_ID	NUMBER			Designates the Level of the Parent member

Query Text

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


SELECT SOURCE_HIER_T_ROWID
,      REQUEST_ID
,      PARENT_DEPTH_NUM
,      PARENT_ID
,      PARENT_VALUE_SET_ID
,      CHILD_DEPTH_NUM
,      CHILD_ID
,      CHILD_VALUE_SET_ID
,      DISPLAY_ORDER_NUM
,      CHILD_DIMENSION_GRP_ID
,      WEIGHTING_PCT
,      PARENT_DIMENSION_GRP_ID
FROM FEM.FEM_HIERVAL_VSR_T;

Dependencies

[top of page]

FEM.FEM_HIERVAL_VSR_T does not reference any database object

FEM.FEM_HIERVAL_VSR_T is referenced by following:

APPS: FEM_HIERVAL_VSR_T