[Home] [Help] [Dependency Information]

TABLE: FII.FII_FIN_ITEM_HIER_GT

Object Details

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

Temporary Table Details

FII.FII_FIN_ITEM_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:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT PARENT_LEVEL
,      PARENT_FIN_CAT_ID
,      PARENT_FLEX_VALUE_SET_ID
,      NEXT_LEVEL
,      NEXT_LEVEL_FIN_CAT_ID
,      NEXT_LEVEL_IS_LEAF
,      IS_LEAF_FLAG
,      CHILD_LEVEL
,      CHILD_FIN_CAT_ID
,      CHILD_FLEX_VALUE_SET_ID
,      NEXT_LEVEL_FIN_CAT_SORT_ORDER
,      LEVEL2_FIN_CAT_ID
,      LEVEL3_FIN_CAT_ID
,      LEVEL4_FIN_CAT_ID
,      LEVEL5_FIN_CAT_ID
,      LEVEL6_FIN_CAT_ID
,      LEVEL7_FIN_CAT_ID
,      LEVEL8_FIN_CAT_ID
,      LEVEL9_FIN_CAT_ID
,      LEVEL10_FIN_CAT_ID
FROM FII.FII_FIN_ITEM_HIER_GT;

Dependencies

[top of page]

FII.FII_FIN_ITEM_HIER_GT does not reference any database object

FII.FII_FIN_ITEM_HIER_GT is referenced by following:

APPS

FII_FIN_ITEM_HIER_GT