DBA Data[Home] [Help] [Dependency Information]

TABLE: FEM.FEM_INTG_DIM_HIER_GT

Object Details
Object Name: FEM_INTG_DIM_HIER_GT
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID

Temporary Table Details

FEM.FEM_INTG_DIM_HIER_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_OBJ_DEF_ID NUMBER
Yes Hierarchy version identifier
PARENT_DEPTH_NUM NUMBER
Yes Parent depth
PARENT_DISPLAY_CODE VARCHAR2 (150) Yes Parent dimension member display code
PARENT_ID NUMBER
Yes Parent dimension member identifier
CHILD_DEPTH_NUM NUMBER
Yes Child depth
CHILD_DISPLAY_CODE VARCHAR2 (150) Yes Child dimension member display code
CHILD_ID NUMBER
Yes Child dimension member identifier
SINGLE_DEPTH_FLAG VARCHAR2 (1) Yes Indicates if the parent dimension member is the immediate parent of the child dimension member
DISPLAY_ORDER_NUM NUMBER
Yes Designates the relative order that the child member is displayed on the user interface relative to its immediate parent
DIMENSION_GROUP_ID NUMBER

Child dimension member group identifier
CHILD_LEAF_FLAG VARCHAR2 (1)
Query Text

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


SELECT HIERARCHY_OBJ_DEF_ID
,      PARENT_DEPTH_NUM
,      PARENT_DISPLAY_CODE
,      PARENT_ID
,      CHILD_DEPTH_NUM
,      CHILD_DISPLAY_CODE
,      CHILD_ID
,      SINGLE_DEPTH_FLAG
,      DISPLAY_ORDER_NUM
,      DIMENSION_GROUP_ID
,      CHILD_LEAF_FLAG
FROM FEM.FEM_INTG_DIM_HIER_GT;

Dependencies

[top of page]

FEM.FEM_INTG_DIM_HIER_GT does not reference any database object

FEM.FEM_INTG_DIM_HIER_GT is referenced by following:

SchemaAPPS
SynonymFEM_INTG_DIM_HIER_GT