[Home] [Help]
[Dependency Information]
[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:
APPS
FII_FIN_ITEM_LEAF_HIERS
FII_GL_AGRT_SUM2_MV
FII_GL_AGRT_SUM_MV
FII_GL_TREND_SUM_MV
|
|
|
|