FND Design Data [Home] [Help]

View: CZ_UIDEF_CONTENTS_V

Product: CZ - Configurator
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
MASTER_ID
MASTER_NAME
RECTYPE_CODE
RECTYPE_NAME
IDENT
PARENT_IDENT
TREE_SEQ
SOURCE_TABLE
INFO
ROW_ID
INFO_LEVEL
INDENT_INFO