SELECT UI_INFO.MASTER_ID , UI_INFO.MASTER_NAME , UI_INFO.RECTYPE_CODE , UI_INFO.RECTYPE_NAME , UI_INFO.IDENT , UI_INFO.PARENT_IDENT , UI_INFO.TREE_SEQ , UI_INFO.SOURCE_TABLE , UI_INFO.INFO , UI_INFO.ROW_ID , LEVEL AS INFO_LEVEL , LPAD (' ' , (LEVEL - 1) * 3) || INFO AS INDENT_INFO FROM ( SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , MASTER_TEMPLATE_FLAG AS RECTYPE_CODE , DECODE (MASTER_TEMPLATE_FLAG , '0' , 'UI' , '1' , 'MASTER TEMPLATE' , 'B' , 'FRAGMENT - BOM' , 'N' , 'FRAGMENT - NON-BOM' , 'P' , 'PAGINATION' ) AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) AS IDENT , TO_CHAR (NULL) AS PARENT_IDENT , 1 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , NAME || '(' || DECODE (MASTER_TEMPLATE_FLAG , '0' , 'UI' , '1' , 'MASTER TEMPLATE' , 'B' , 'FRAGMENT - BOM' , 'N' , 'FRAGMENT - NON-BOM' , 'P' , 'PAGINATION' ) || ' - UI STYLE ' || TO_CHAR (UI_STYLE) || ') ' || DESC_TEXT AS INFO FROM CZ_UI_DEFS UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , 'UTT_HDR' AS RECTYPE_CODE , 'UI CONTENT TYPES' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$CT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) AS PARENT_IDENT , 2 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'UI CONTENT TYPES' AS INFO FROM CZ_UI_DEFS UNION ALL SELECT UI_DEF_ID AS MASTER_ID , UTTVV.UI_DEF_NAME AS MASTER_NAME , TO_CHAR (CONTENT_TYPE) AS RECTYPE_CODE , CONTENT_TYPE_NAME AS RECTYPE_NAME , 'UDF-$CT-' || CONTENT_TYPE AS IDENT , 'UDF-' || UI_DEF_ID || '$CT' AS PARENT_IDENT , CONTENT_TYPE AS TREE_SEQ , 'CZ_UI_CONT_TYPE_TEMPLS' AS SOURCE_TABLE , UTTVV.ROW_ID , CONTENT_TYPE_NAME || ': TEMPLATE ' || TO_CHAR (UTTVV.TEMPLATE_ID) || ' , "' || UTTVV.TEMPLATE_NAME || '"' AS INFO FROM CZ_UI_CONT_TYPE_TEMPLS_VV UTTVV UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , 'UDF_ATTR' AS RECTYPE_CODE , 'UI ATTRIBUTES' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) AS PARENT_IDENT , 1 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'UI ATTRIBUTES' AS INFO FROM CZ_UI_DEFS UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '48' AS RECTYPE_CODE , 'BOMQTYINPUTCTRLS' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-BOMQTYINPUTCTRLS' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 1 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'BOMQTYINPUTCTRLS: ' || TO_CHAR (BOMQTYINPUTCTRLS) AS VALUE FROM CZ_UI_DEFS WHERE BOMQTYINPUTCTRLS IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '47' AS RECTYPE_CODE , 'BOMUI_LAYOUT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-BOMUI_LAYOUT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 2 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'BOMUI_LAYOUT: ' || TO_CHAR (BOMUI_LAYOUT) AS VALUE FROM CZ_UI_DEFS WHERE BOMUI_LAYOUT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '17' AS RECTYPE_CODE , 'CHECKOUT_USER' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CHECKOUT_USER' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 4 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CHECKOUT_USER: ' || CHECKOUT_USER AS VALUE FROM CZ_UI_DEFS WHERE CHECKOUT_USER IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '6' AS RECTYPE_CODE , 'COMPONENT_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-COMPONENT_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 5 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'COMPONENT_ID: ' || TO_CHAR (COMPONENT_ID) AS VALUE FROM CZ_UI_DEFS WHERE COMPONENT_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '22' AS RECTYPE_CODE , 'CONTROLS_PER_SCREEN' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CONTROLS_PER_SCREEN' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 6 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CONTROLS_PER_SCREEN: ' || TO_CHAR (CONTROLS_PER_SCREEN) AS VALUE FROM CZ_UI_DEFS WHERE CONTROLS_PER_SCREEN IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '41' AS RECTYPE_CODE , 'CONTROL_LAYOUT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CONTROL_LAYOUT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 7 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CONTROL_LAYOUT: ' || TO_CHAR (CONTROL_LAYOUT) AS VALUE FROM CZ_UI_DEFS WHERE CONTROL_LAYOUT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '64' AS RECTYPE_CODE , 'CTRLTEMPLATEUSE_BUTTONBAR' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLATEUSE_BUTTONBAR' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 8 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLATEUSE_BUTTONBAR: ' || CTRLTEMPLATEUSE_BUTTONBAR AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLATEUSE_BUTTONBAR IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '65' AS RECTYPE_CODE , 'CTRLTEMPLATEUSE_UTILITYPAGE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLATEUSE_UTILITYPAGE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 9 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLATEUSE_UTILITYPAGE: ' || CTRLTEMPLATEUSE_UTILITYPAGE AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLATEUSE_UTILITYPAGE IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '49' AS RECTYPE_CODE , 'CTRLTEMPLUSE_BOM' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLUSE_BOM' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 9.5 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLUSE_BOM: ' || TO_CHAR (CTRLTEMPLUSE_BOM) AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLUSE_BOM IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '52' AS RECTYPE_CODE , 'CTRLTEMPLUSE_COMMON' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLUSE_COMMON' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 10 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLUSE_COMMON: ' || TO_CHAR (CTRLTEMPLUSE_COMMON) AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLUSE_COMMON IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '50' AS RECTYPE_CODE , 'CTRLTEMPLUSE_NONBOM' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLUSE_NONBOM' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 11 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLUSE_NONBOM: ' || TO_CHAR (CTRLTEMPLUSE_NONBOM) AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLUSE_NONBOM IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '54' AS RECTYPE_CODE , 'CTRLTEMPLUSE_OPTMSG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLUSE_OPTMSG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 12 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLUSE_OPTMSG: ' || TO_CHAR (CTRLTEMPLUSE_OPTMSG) AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLUSE_OPTMSG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '53' AS RECTYPE_CODE , 'CTRLTEMPLUSE_REQDMSG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-CTRLTEMPLUSE_REQDMSG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 13 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'CTRLTEMPLUSE_REQDMSG: ' || TO_CHAR (CTRLTEMPLUSE_REQDMSG) AS VALUE FROM CZ_UI_DEFS WHERE CTRLTEMPLUSE_REQDMSG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '10' AS RECTYPE_CODE , 'DELETED_FLAG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-DELETED_FLAG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 14 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'DELETED_FLAG: ' || DELETED_FLAG AS VALUE FROM CZ_UI_DEFS WHERE DELETED_FLAG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '3' AS RECTYPE_CODE , 'DESC_TEXT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-DESC_TEXT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 15 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'DESC_TEXT: ' || DESC_TEXT AS VALUE FROM CZ_UI_DEFS WHERE DESC_TEXT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '5' AS RECTYPE_CODE , 'DEVL_PROJECT_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-DEVL_PROJECT_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 16 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'DEVL_PROJECT_ID: ' || TO_CHAR (DEVL_PROJECT_ID) AS VALUE FROM CZ_UI_DEFS WHERE DEVL_PROJECT_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '61' AS RECTYPE_CODE , 'DRILLDOWN_CONTROL_TEXT_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-DRILLDOWN_CONTROL_TEXT_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 17 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'DRILLDOWN_CONTROL_TEXT_ID: ' || TO_CHAR (DRILLDOWN_CONTROL_TEXT_ID) AS VALUE FROM CZ_UI_DEFS WHERE DRILLDOWN_CONTROL_TEXT_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '62' AS RECTYPE_CODE , 'DRILLDOWN_IMAGE_URL' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-DRILLDOWN_IMAGE_URL' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 18 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'DRILLDOWN_IMAGE_URL: ' || DRILLDOWN_IMAGE_URL AS VALUE FROM CZ_UI_DEFS WHERE DRILLDOWN_IMAGE_URL IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '58' AS RECTYPE_CODE , 'EMPTY_UI_FLAG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-EMPTY_UI_FLAG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 19 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'EMPTY_UI_FLAG: ' || EMPTY_UI_FLAG AS VALUE FROM CZ_UI_DEFS WHERE EMPTY_UI_FLAG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '30' AS RECTYPE_CODE , 'ERR_RUN_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-ERR_RUN_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 20 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'ERR_RUN_ID: ' || TO_CHAR (ERR_RUN_ID) AS VALUE FROM CZ_UI_DEFS WHERE ERR_RUN_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '37' AS RECTYPE_CODE , 'FROM_MASTER_TEMPLATE_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-FROM_MASTER_TEMPLATE_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 21 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'FROM_MASTER_TEMPLATE_ID: ' || TO_CHAR (FROM_MASTER_TEMPLATE_ID) AS VALUE FROM CZ_UI_DEFS WHERE FROM_MASTER_TEMPLATE_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '21' AS RECTYPE_CODE , 'GEN_HEADER' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-GEN_HEADER' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 22 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'GEN_HEADER: ' || GEN_HEADER AS VALUE FROM CZ_UI_DEFS WHERE GEN_HEADER IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '19' AS RECTYPE_CODE , 'GEN_VERSION' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-GEN_VERSION' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 23 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'GEN_VERSION: ' || GEN_VERSION AS VALUE FROM CZ_UI_DEFS WHERE GEN_VERSION IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '23' AS RECTYPE_CODE , 'LOOK_AND_FEEL' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-LOOK_AND_FEEL' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 24 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'LOOK_AND_FEEL: ' || LOOK_AND_FEEL AS VALUE FROM CZ_UI_DEFS WHERE LOOK_AND_FEEL IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '35' AS RECTYPE_CODE , 'MASTER_TEMPLATE_FLAG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-MASTER_TEMPLATE_FLAG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 25 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'MASTER_TEMPLATE_FLAG: ' || MASTER_TEMPLATE_FLAG AS VALUE FROM CZ_UI_DEFS WHERE MASTER_TEMPLATE_FLAG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '55' AS RECTYPE_CODE , 'MENU_CAPTION_RULE_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-MENU_CAPTION_RULE_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 26 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'MENU_CAPTION_RULE_ID: ' || TO_CHAR (MENU_CAPTION_RULE_ID) AS VALUE FROM CZ_UI_DEFS WHERE MENU_CAPTION_RULE_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '26' AS RECTYPE_CODE , 'MODEL_TIMESTAMP' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-MODEL_TIMESTAMP' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 27 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'MODEL_TIMESTAMP: ' || TO_CHAR (MODEL_TIMESTAMP) AS VALUE FROM CZ_UI_DEFS WHERE MODEL_TIMESTAMP IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '4' AS RECTYPE_CODE , 'NAME' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-NAME' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 28 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'NAME: ' || NAME AS VALUE FROM CZ_UI_DEFS WHERE NAME IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '51' AS RECTYPE_CODE , 'NONBOM_UILAYOUT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-NONBOM_UILAYOUT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 29 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'NONBOM_UILAYOUT: ' || TO_CHAR (NONBOM_UILAYOUT) AS VALUE FROM CZ_UI_DEFS WHERE NONBOM_UILAYOUT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '69' AS RECTYPE_CODE , 'OPTION_SORT_METHOD' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-OPTION_SORT_METHOD' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 30 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'OPTION_SORT_METHOD: ' || TO_CHAR (OPTION_SORT_METHOD) AS VALUE FROM CZ_UI_DEFS WHERE OPTION_SORT_METHOD IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '67' AS RECTYPE_CODE , 'OPTION_SORT_ORDER' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-OPTION_SORT_ORDER' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 31 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'OPTION_SORT_ORDER: ' || TO_CHAR (OPTION_SORT_ORDER) AS VALUE FROM CZ_UI_DEFS WHERE OPTION_SORT_ORDER IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '68' AS RECTYPE_CODE , 'OPTION_SORT_PROPERTY_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-OPTION_SORT_PROPERTY_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 32 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'OPTION_SORT_PROPERTY_ID: ' || TO_CHAR (OPTION_SORT_PROPERTY_ID) AS VALUE FROM CZ_UI_DEFS WHERE OPTION_SORT_PROPERTY_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '66' AS RECTYPE_CODE , 'OPTION_SORT_SELECT_FIRST' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-OPTION_SORT_SELECT_FIRST' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 33 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'OPTION_SORT_SELECT_FIRST: ' || TO_CHAR (OPTION_SORT_SELECT_FIRST) AS VALUE FROM CZ_UI_DEFS WHERE OPTION_SORT_SELECT_FIRST IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '44' AS RECTYPE_CODE , 'OUTER_TEMPLATE_USAGE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-OUTER_TEMPLATE_USAGE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 34 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'OUTER_TEMPLATE_USAGE: ' || OUTER_TEMPLATE_USAGE AS VALUE FROM CZ_UI_DEFS WHERE OUTER_TEMPLATE_USAGE IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '56' AS RECTYPE_CODE , 'PAGE_CAPTION_RULE_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGE_CAPTION_RULE_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 35 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGE_CAPTION_RULE_ID: ' || TO_CHAR (PAGE_CAPTION_RULE_ID) AS VALUE FROM CZ_UI_DEFS WHERE PAGE_CAPTION_RULE_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '32' AS RECTYPE_CODE , 'PAGE_LAYOUT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGE_LAYOUT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 36 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGE_LAYOUT: ' || PAGE_LAYOUT AS VALUE FROM CZ_UI_DEFS WHERE PAGE_LAYOUT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '28' AS RECTYPE_CODE , 'PAGE_SET_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGE_SET_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 37 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGE_SET_ID: ' || TO_CHAR (PAGE_SET_ID) AS VALUE FROM CZ_UI_DEFS WHERE PAGE_SET_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '60' AS RECTYPE_CODE , 'PAGINATION_SLOT' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGINATION_SLOT' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 38 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGINATION_SLOT: ' || TO_CHAR (PAGINATION_SLOT) AS VALUE FROM CZ_UI_DEFS WHERE PAGINATION_SLOT IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '46' AS RECTYPE_CODE , 'PAGIN_BOMOC' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGIN_BOMOC' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 39 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGIN_BOMOC: ' || TO_CHAR (PAGIN_BOMOC) AS VALUE FROM CZ_UI_DEFS WHERE PAGIN_BOMOC IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '42' AS RECTYPE_CODE , 'PAGIN_DRILLDOWNCTRL' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGIN_DRILLDOWNCTRL' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 40 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGIN_DRILLDOWNCTRL: ' || TO_CHAR (PAGIN_DRILLDOWNCTRL) AS VALUE FROM CZ_UI_DEFS WHERE PAGIN_DRILLDOWNCTRL IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '38' AS RECTYPE_CODE , 'PAGIN_MAXCONTROLS' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGIN_MAXCONTROLS' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 43 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGIN_MAXCONTROLS: ' || TO_CHAR (PAGIN_MAXCONTROLS) AS VALUE FROM CZ_UI_DEFS WHERE PAGIN_MAXCONTROLS IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '39' AS RECTYPE_CODE , 'PAGIN_NONINST' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGIN_NONINST' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 44 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGIN_NONINST: ' || TO_CHAR (PAGIN_NONINST) AS VALUE FROM CZ_UI_DEFS WHERE PAGIN_NONINST IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '40' AS RECTYPE_CODE , 'PAGIN_NONINST_REFCOMP' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PAGIN_NONINST_REFCOMP' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 45 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PAGIN_NONINST_REFCOMP: ' || TO_CHAR (PAGIN_NONINST_REFCOMP) AS VALUE FROM CZ_UI_DEFS WHERE PAGIN_NONINST_REFCOMP IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '25' AS RECTYPE_CODE , 'PERSISTENT_UI_DEF_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PERSISTENT_UI_DEF_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 46 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PERSISTENT_UI_DEF_ID: ' || TO_CHAR (PERSISTENT_UI_DEF_ID) AS VALUE FROM CZ_UI_DEFS WHERE PERSISTENT_UI_DEF_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '57' AS RECTYPE_CODE , 'PRESERVE_MODEL_HIERARCHY' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PRESERVE_MODEL_HIERARCHY' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 47 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PRESERVE_MODEL_HIERARCHY: ' || PRESERVE_MODEL_HIERARCHY AS VALUE FROM CZ_UI_DEFS WHERE PRESERVE_MODEL_HIERARCHY IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '36' AS RECTYPE_CODE , 'PRICE_DISPLAY' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PRICE_DISPLAY' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 48 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PRICE_DISPLAY: ' || TO_CHAR (PRICE_DISPLAY) AS VALUE FROM CZ_UI_DEFS WHERE PRICE_DISPLAY IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '33' AS RECTYPE_CODE , 'PRICE_UPDATE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PRICE_UPDATE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 49 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PRICE_UPDATE: ' || TO_CHAR (PRICE_UPDATE) AS VALUE FROM CZ_UI_DEFS WHERE PRICE_UPDATE IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '24' AS RECTYPE_CODE , 'PRIMARY_NAVIGATION' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-PRIMARY_NAVIGATION' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 50 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'PRIMARY_NAVIGATION: ' || TO_CHAR (PRIMARY_NAVIGATION) AS VALUE FROM CZ_UI_DEFS WHERE PRIMARY_NAVIGATION IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '63' AS RECTYPE_CODE , 'ROWS_PER_TABLE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-ROWS_PER_TABLE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 51 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'ROWS_PER_TABLE: ' || TO_CHAR (ROWS_PER_TABLE) AS VALUE FROM CZ_UI_DEFS WHERE ROWS_PER_TABLE IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '34' AS RECTYPE_CODE , 'SEEDED_FLAG' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-SEEDED_FLAG' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 52 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'SEEDED_FLAG: ' || SEEDED_FLAG AS VALUE FROM CZ_UI_DEFS WHERE SEEDED_FLAG IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '59' AS RECTYPE_CODE , 'SHOW_TRAIN' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-SHOW_TRAIN' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 53 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'SHOW_TRAIN: ' || SHOW_TRAIN AS VALUE FROM CZ_UI_DEFS WHERE SHOW_TRAIN IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '29' AS RECTYPE_CODE , 'START_PAGE_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-START_PAGE_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 54 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'START_PAGE_ID: ' || TO_CHAR (START_PAGE_ID) AS VALUE FROM CZ_UI_DEFS WHERE START_PAGE_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '31' AS RECTYPE_CODE , 'START_URL' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-START_URL' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 55 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'START_URL: ' || START_URL AS VALUE FROM CZ_UI_DEFS WHERE START_URL IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '20' AS RECTYPE_CODE , 'TREENODE_DISPLAY_SOURCE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-TREENODE_DISPLAY_SOURCE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 56 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'TREENODE_DISPLAY_SOURCE: ' || TREENODE_DISPLAY_SOURCE AS VALUE FROM CZ_UI_DEFS WHERE TREENODE_DISPLAY_SOURCE IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '7' AS RECTYPE_CODE , 'TREE_SEQ' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-TREE_SEQ' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 57 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'TREE_SEQ: ' || TO_CHAR (TREE_SEQ) AS VALUE FROM CZ_UI_DEFS WHERE TREE_SEQ IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '2' AS RECTYPE_CODE , 'UI_DEF_ID' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-UI_DEF_ID' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 58 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'UI_DEF_ID: ' || TO_CHAR (UI_DEF_ID) AS VALUE FROM CZ_UI_DEFS WHERE UI_DEF_ID IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '27' AS RECTYPE_CODE , 'UI_STATUS' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-UI_STATUS' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 59 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'UI_STATUS: ' || UI_STATUS AS VALUE FROM CZ_UI_DEFS WHERE UI_STATUS IS NOT NULL UNION ALL SELECT UI_DEF_ID AS MASTER_ID , NAME AS MASTER_NAME , '18' AS RECTYPE_CODE , 'UI_STYLE' AS RECTYPE_NAME , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT-UI_STYLE' AS IDENT , 'UDF-' || TO_CHAR (UI_DEF_ID) || '$ATT' AS PARENT_IDENT , 60 AS TREE_SEQ , 'CZ_UI_DEFS' AS SOURCE_TABLE , ROWID AS ROW_ID , 'UI_STYLE: ' || UI_STYLE AS VALUE FROM CZ_UI_DEFS WHERE UI_STYLE IS NOT NULL ) UI_INFO START WITH PARENT_IDENT IS NULL CONNECT BY PARENT_IDENT = PRIOR IDENT ORDER SIBLINGS BY TREE_SEQ