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_LEDGERS_HIER

Object Details

Object Name:	FEM_LEDGERS_HIER
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_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_LEDGERS_HIER_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	HIERARCHY_OBJ_DEF_ID PARENT_ID CHILD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJ_DEF_ID	NUMBER	(9)	Yes	Hierarchy Definition - identifies the version of the hierarchy Parent depth
PARENT_DEPTH_NUM	NUMBER		Yes	Parent Depth
PARENT_ID	NUMBER		Yes	Uniquely identifies the parent member
CHILD_DEPTH_NUM	NUMBER		Yes	Depth of the child in the hierarchy
CHILD_ID	NUMBER		Yes	Uniquely identifies the child member
SINGLE_DEPTH_FLAG	VARCHAR2	(1)	Yes	Indicates if parent_id is an immediate parent of the child_id. A 'Y' indicates an immediate parent. An 'N' indicates that the child is more than one level removed in depth from the parent. For termination records where the parent_id=child_id, this flag is set to 'N'
DISPLAY_ORDER_NUM	NUMBER		Yes	Designates the relative order that the child is displayed on the user-interface. The order is from the perspective of the immediate parent of the child. This means that all children of the same parent are displayed in the order indicated by DISPLAY_ORDER_NUM
WEIGHTING_PCT	NUMBER	(3)		Designates the weighting percentage of values received from the immediate parent
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Framework required column for stale data detection
READ_ONLY_FLAG	VARCHAR2	(1)		A Y Designates that the parent child relationship is protected from update

Query Text

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


SELECT HIERARCHY_OBJ_DEF_ID
,      PARENT_DEPTH_NUM
,      PARENT_ID
,      CHILD_DEPTH_NUM
,      CHILD_ID
,      SINGLE_DEPTH_FLAG
,      DISPLAY_ORDER_NUM
,      WEIGHTING_PCT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      READ_ONLY_FLAG
FROM FEM.FEM_LEDGERS_HIER;

Dependencies

[top of page]

FEM.FEM_LEDGERS_HIER does not reference any database object

FEM.FEM_LEDGERS_HIER is referenced by following:

APPS: FEM_LEDGERS_HIER