[Home] [Help] [Dependency Information]
Object Name: | FII_FIN_ITEM_LEAF_HIERS |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_FIN_ITEM_LEAF_HIERS |
Subobject Name: | |
Status: | VALID |
This table stores the child-parent relationship between financial items.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_FIN_ITEM_LEAF_HIERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PARENT_FIN_CAT_ID
CHILD_FIN_CAT_ID |
FII_FIN_ITEM_LEAF_HIERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHILD_FIN_CAT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_LEVEL | NUMBER | Parent Level Number | ||
NEXT_LEVEL | NUMBER | Next Level Number | ||
CHILD_LEVEL | NUMBER | Child Level Number | ||
PARENT_FIN_CAT_ID | NUMBER | (15) | Parent Financial Category identifier | |
NEXT_LEVEL_FIN_CAT_ID | NUMBER | (15) | Next level Financial Category identifier | |
CHILD_FIN_CAT_ID | NUMBER | (15) | Child Financial Category identifier | |
IS_LEAF_FLAG | VARCHAR2 | (1) | Flag to indicate if a self node (A,A,A) is a leaf node or not | |
NEXT_LEVEL_IS_LEAF_FLAG | VARCHAR2 | (1) | Flag to indicate if the next level is a leaf node or not | |
PARENT_FLEX_VALUE_SET_ID | NUMBER | (15) | Parent Flex Value Set Identifier | |
CHILD_FLEX_VALUE_SET_ID | NUMBER | (15) | Child Flex Value Set Identifier | |
NEXT_LEVEL_FIN_CAT_SORT_ORDER | NUMBER | (15) | Next level sort order number | |
AGGREGATE_NEXT_LEVEL_FLAG | VARCHAR2 | (1) | Aggregation Flag | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
IS_TO_BE_ROLLED_UP_FLAG | VARCHAR2 | (1) | Flag to indicate if a record is to be used hile aggregating upto fii_gl_trend_sum_mv or not | |
TOP_NODE_FIN_CAT_TYPE | VARCHAR2 | (10) | Financial Category Type of Top Node | |
LEVEL2_FIN_CAT_ID | NUMBER | Level 2 Financial Category identifier | ||
LEVEL3_FIN_CAT_ID | NUMBER | Level 3 Financial Category identifier | ||
LEVEL4_FIN_CAT_ID | NUMBER | Level 4 Financial Category identifier | ||
LEVEL5_FIN_CAT_ID | NUMBER | Level 5 Financial Category identifier | ||
LEVEL6_FIN_CAT_ID | NUMBER | Level 6 Financial Category identifier | ||
LEVEL7_FIN_CAT_ID | NUMBER | Level 7 Financial Category identifier | ||
LEVEL8_FIN_CAT_ID | NUMBER | Level 8 Financial Category identifier | ||
LEVEL9_FIN_CAT_ID | NUMBER | Level 9 Financial Category identifier | ||
LEVEL10_FIN_CAT_ID | NUMBER | Level 10 Financial Category identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_LEVEL
, NEXT_LEVEL
, CHILD_LEVEL
, PARENT_FIN_CAT_ID
, NEXT_LEVEL_FIN_CAT_ID
, CHILD_FIN_CAT_ID
, IS_LEAF_FLAG
, NEXT_LEVEL_IS_LEAF_FLAG
, PARENT_FLEX_VALUE_SET_ID
, CHILD_FLEX_VALUE_SET_ID
, NEXT_LEVEL_FIN_CAT_SORT_ORDER
, AGGREGATE_NEXT_LEVEL_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IS_TO_BE_ROLLED_UP_FLAG
, TOP_NODE_FIN_CAT_TYPE
, 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_LEAF_HIERS;
FII.FII_FIN_ITEM_LEAF_HIERS does not reference any database object
FII.FII_FIN_ITEM_LEAF_HIERS is referenced by following:
|
|
|