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: FII.FII_DIM_NORM_HIERARCHY

Object Details

Object Name:	FII_DIM_NORM_HIERARCHY
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_DIM_NORM_HIERARCHY
Subobject Name:
Status:	VALID

Table used to store the multi-level value hierarchies for Financial dimension value sets

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_DIM_NORM_HIERARCHY_U1	NORMAL	UNIQUE	APPS_TS_SEED	PARENT_FLEX_VALUE_SET_ID PARENT_FLEX_VALUE CHILD_FLEX_VALUE_SET_ID CHILD_FLEX_VALUE_LOW CHILD_FLEX_VALUE_HIGH RANGE_ATTRIBUTE

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_FLEX_VALUE_SET_ID	NUMBER	(15)	Yes	Parent flex value set identifier
PARENT_FLEX_VALUE	VARCHAR2	(60)	Yes	The parent value to which the range belongs
RANGE_ATTRIBUTE	VARCHAR2	(1)	Yes	Flag to distinguish a child value from a parent value
CHILD_FLEX_VALUE_SET_ID	NUMBER	(15)	Yes	Child flexfield value set identifier
CHILD_FLEX_VALUE_LOW	VARCHAR2	(60)	Yes	The low value of the range of child values
CHILD_FLEX_VALUE_HIGH	VARCHAR2	(60)	Yes	The high value of the range of child values
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT PARENT_FLEX_VALUE_SET_ID
,      PARENT_FLEX_VALUE
,      RANGE_ATTRIBUTE
,      CHILD_FLEX_VALUE_SET_ID
,      CHILD_FLEX_VALUE_LOW
,      CHILD_FLEX_VALUE_HIGH
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FII.FII_DIM_NORM_HIERARCHY;

Dependencies

[top of page]

FII.FII_DIM_NORM_HIERARCHY does not reference any database object

FII.FII_DIM_NORM_HIERARCHY is referenced by following:

APPS: FII_DIM_NORM_HIERARCHY