PJF_RBS_DENORM_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
RBS_ELEMENT_ID RBS_ELEMENT_NAME_ID RBS_VERSION_ID OUTLINE_NUMBER ORDER_NUMBER RESOURCE_TYPE_ID RESOURCE_SOURCE_ID RULE_FLAG PARENT_ELEMENT_ID RBS_LEVEL LEAF_NODE_FLAG ELEMENT_IDENTIFIER USER_CREATED_FLAG MARKED_FOR ALIAS ENABLED_FLAG UNIT_OF_MEASURE

Query

SQL_Statement

SELECT RBS_ELEMENT_ID , RBS_ELEMENT_NAME_ID , RBS_VERSION_ID , OUTLINE_NUMBER , ORDER_NUMBER , RESOURCE_TYPE_ID , RESOURCE_SOURCE_ID , RULE_FLAG , PARENT_ELEMENT_ID , RBS_LEVEL , LEAF_NODE_FLAG , ELEMENT_IDENTIFIER , USER_CREATED_FLAG , MARKED_FOR , ALIAS, ENABLED_FLAG, UNIT_OF_MEASURE from pjf_rbs_elements_vl union all select RBS_ELEMENT_ID , RBS_ELEMENT_NAME_ID , RBS_VERSION_ID , OUTLINE_NUMBER , ORDER_NUMBER , RESOURCE_TYPE_ID , RESOURCE_SOURCE_ID , RULE_FLAG , RBS_ELEMENT_ID , RBS_LEVEL +1 , 'Y' , ELEMENT_IDENTIFIER , USER_CREATED_FLAG , MARKED_FOR , ALIAS, ENABLED_FLAG, UNIT_OF_MEASURE from pjf_rbs_elements_vl where LEAF_NODE_FLAG = 'N'