PER_POS_TREE_NODE_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID TREE_NODE_ID PARENT_TREE_NODE_ID DATA_SOURCE_ID POSITION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE REFERENCE_TREE_CODE REFERENCE_TREE_VERSION_ID TREE_LABEL_ID PARENT_DATA_SOURCE_ID PARENT_POSITION_ID PARENT_EFFECTIVE_START_DATE PARENT_EFFECTIVE_END_DATE PARENT_TREE_LABEL_ID SORT_ORDER DEPTH CHILD_COUNT 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, TREE_NODE_ID, PARENT_TREE_NODE_ID, DATA_SOURCE_ID, TO_NUMBER(PK1_START_VALUE) POSITION_ID, TO_DATE(PK2_START_VALUE,'YYYY-MM-DD') EFFECTIVE_START_DATE, TO_DATE(PK3_START_VALUE,'YYYY-MM-DD') EFFECTIVE_END_DATE, REFERENCE_TREE_CODE, REFERENCE_TREE_VERSION_ID, TREE_LABEL_ID, PARENT_DATA_SOURCE_ID, TO_NUMBER(PARENT_PK1_VALUE) PARENT_POSITION_ID, TO_DATE(PARENT_PK2_VALUE,'YYYY-MM-DD') PARENT_EFFECTIVE_START_DATE, TO_DATE(PARENT_PK3_VALUE,'YYYY-MM-DD') PARENT_EFFECTIVE_END_DATE, PARENT_TREE_LABEL_ID, SORT_ORDER, DEPTH, CHILD_COUNT, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM PER_POS_TREE_NODE )