1. Tables and Views for Financials
  2. XCC_SEG_VAL_HIER_RF

XCC_SEG_VAL_HIER_RF

This table contains the relationship between various nodes in a given tree version in row-flattened manner for the budgetary control related tree structures. It uses the structure of the FND_TREE_NODE_RF table as a template.

Details

  • Schema: FUSION

  • Object owner: XCC

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

XCC_SEG_VAL_HIER_RF_PK

ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, TREE_NODE_ID, RF_TREE_NODE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes Enterprise identifier. Used in partitioning for multiple tenancy.
TREE_STRUCTURE_CODE VARCHAR2 30 Yes Tree structure identifier. Foreign key to FND_TREE_STRUCTURE.
TREE_CODE VARCHAR2 30 Yes Tree code identifier. Foreign key to FND_TREE.
TREE_VERSION_ID VARCHAR2 32 Yes Tree version identifier. Foreign key to FND_TREE_VERSION.
TREE_NODE_ID VARCHAR2 32 Yes Tree node identifier. Foreign key to FND_TREE_NODE.
RF_TREE_NODE_ID VARCHAR2 32 Yes Tree node identifier. Foreign key to FND_TREE_NODE.
DATA_SOURCE_ID VARCHAR2 32 Yes Tree node data source identifier.
PK1_VALUE VARCHAR2 100 Tree node primary key identifier.
PK2_VALUE VARCHAR2 100 Tree node primary key identifier.
PK3_VALUE VARCHAR2 100 Tree node primary key identifier.
PK4_VALUE VARCHAR2 100 Tree node primary key identifier.
PK5_VALUE VARCHAR2 100 Tree node primary key identifier.
TREE_LABEL_ID VARCHAR2 32 Tree label identifier. Foreign key to FND_TREE_LABEL.
ANCESTOR_TREE_NODE_ID VARCHAR2 32 Ancestor tree node identifier.
ANCESTOR_DATA_SOURCE_ID VARCHAR2 32 Ancestor tree node data source identifier.
ANCESTOR_PK1_VALUE VARCHAR2 100 Primary key of the ancestor tree node.
ANCESTOR_PK2_VALUE VARCHAR2 100 Primary key of the ancestor tree node.
ANCESTOR_PK3_VALUE VARCHAR2 100 Primary key of the ancestor tree node.
ANCESTOR_PK4_VALUE VARCHAR2 100 Primary key of the ancestor tree node.
ANCESTOR_PK5_VALUE VARCHAR2 100 Primary key of the ancestor tree node.
ANCESTOR_TREE_LABEL_ID VARCHAR2 32 Ancestor tree label identifier.
DISTANCE NUMBER 18 Yes Distance between the tree node and the ancestor tree node.
IS_LEAF VARCHAR2 1 Yes Identifies if the tree node is a child or parent.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
XCC_SEG_VAL_HIER_RF_N1 Non Unique Default TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, ANCESTOR_PK1_VALUE
XCC_SEG_VAL_HIER_RF_N2 Non Unique Default TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, PK1_VALUE
XCC_SEG_VAL_HIER_RF_U1 Unique Default ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, TREE_NODE_ID, RF_TREE_NODE_ID