PER_ORG_TREE_NODE_RF_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID RF_TREE_NODE_ID TREE_NODE_ID DATA_SOURCE_ID ORGANIZATION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE TREE_LABEL_ID ANCESTOR_TREE_NODE_ID ANCESTOR_DATA_SOURCE_ID ANCESTOR_ORGANIZATION_ID ANCESTOR_EFFECTIVE_START_DATE ANCESTOR_EFFECTIVE_END_DATE ANCESTOR_TREE_LABEL_ID DISTANCE IS_LEAF CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

( SELECT TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, RF_TREE_NODE_ID, TREE_NODE_ID, DATA_SOURCE_ID, TO_NUMBER(PK1_VALUE) ORGANIZATION_ID, TO_DATE(PK2_VALUE,'YYYY-MM-DD') EFFECTIVE_START_DATE, TO_DATE(PK3_VALUE,'YYYY-MM-DD') EFFECTIVE_END_DATE, TREE_LABEL_ID, ANCESTOR_TREE_NODE_ID, ANCESTOR_DATA_SOURCE_ID, TO_NUMBER(ANCESTOR_PK1_VALUE ) ANCESTOR_ORGANIZATION_ID, TO_DATE(ANCESTOR_PK2_VALUE ,'YYYY-MM-DD') ANCESTOR_EFFECTIVE_START_DATE, TO_DATE(ANCESTOR_PK3_VALUE,'YYYY-MM-DD') ANCESTOR_EFFECTIVE_END_DATE, ANCESTOR_TREE_LABEL_ID, DISTANCE, IS_LEAF, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM PER_ORG_TREE_NODE_RF )