VIEW: CZ.CZ_UI_DEFS#

Source

View Text - Preformatted

select LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, UI_DEF_ID UI_DEF_ID, DESC_TEXT DESC_TEXT, NAME NAME, DEVL_PROJECT_ID DEVL_PROJECT_ID, COMPONENT_ID COMPONENT_ID, TREE_SEQ TREE_SEQ, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, UI_STYLE UI_STYLE, GEN_VERSION GEN_VERSION, TREENODE_DISPLAY_SOURCE TREENODE_DISPLAY_SOURCE, GEN_HEADER GEN_HEADER, CONTROLS_PER_SCREEN CONTROLS_PER_SCREEN, LOOK_AND_FEEL LOOK_AND_FEEL, PERSISTENT_UI_DEF_ID PERSISTENT_UI_DEF_ID, MASTER_TEMPLATE_FLAG MASTER_TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, BOMQTYINPUTCTRLS BOMQTYINPUTCTRLS, BOMUI_LAYOUT BOMUI_LAYOUT, CONTROL_LAYOUT CONTROL_LAYOUT, CTRLTEMPLATEUSE_BUTTONBAR CTRLTEMPLATEUSE_BUTTONBAR, CTRLTEMPLATEUSE_UTILITYPAGE CTRLTEMPLATEUSE_UTILITYPAGE, CTRLTEMPLUSE_BOM CTRLTEMPLUSE_BOM, CTRLTEMPLUSE_COMMON CTRLTEMPLUSE_COMMON, CTRLTEMPLUSE_NONBOM CTRLTEMPLUSE_NONBOM, CTRLTEMPLUSE_OPTMSG CTRLTEMPLUSE_OPTMSG, CTRLTEMPLUSE_REQDMSG CTRLTEMPLUSE_REQDMSG, DRILLDOWN_CONTROL_TEXT_ID DRILLDOWN_CONTROL_TEXT_ID, DRILLDOWN_IMAGE_URL DRILLDOWN_IMAGE_URL, EMPTY_UI_FLAG EMPTY_UI_FLAG, ERR_RUN_ID ERR_RUN_ID, FROM_MASTER_TEMPLATE_ID FROM_MASTER_TEMPLATE_ID, MENU_CAPTION_RULE_ID MENU_CAPTION_RULE_ID, MODEL_TIMESTAMP MODEL_TIMESTAMP, NONBOM_UILAYOUT NONBOM_UILAYOUT, OPTION_SORT_METHOD OPTION_SORT_METHOD, OPTION_SORT_ORDER OPTION_SORT_ORDER, OPTION_SORT_PROPERTY_ID OPTION_SORT_PROPERTY_ID, OPTION_SORT_SELECT_FIRST OPTION_SORT_SELECT_FIRST, OUTER_TEMPLATE_USAGE OUTER_TEMPLATE_USAGE, PAGE_CAPTION_RULE_ID PAGE_CAPTION_RULE_ID, PAGE_LAYOUT PAGE_LAYOUT, PAGE_SET_ID PAGE_SET_ID, PAGINATION_SLOT PAGINATION_SLOT, PAGIN_BOMOC PAGIN_BOMOC, PAGIN_DRILLDOWNCTRL PAGIN_DRILLDOWNCTRL, PAGIN_MAXCONTROLS PAGIN_MAXCONTROLS, PAGIN_NONINST PAGIN_NONINST, PAGIN_NONINST_REFCOMP PAGIN_NONINST_REFCOMP, PRESERVE_MODEL_HIERARCHY PRESERVE_MODEL_HIERARCHY, PRICE_DISPLAY PRICE_DISPLAY, PRICE_UPDATE PRICE_UPDATE, PRIMARY_NAVIGATION PRIMARY_NAVIGATION, ROWS_PER_TABLE ROWS_PER_TABLE, SHOW_TRAIN SHOW_TRAIN, START_PAGE_ID START_PAGE_ID, START_URL START_URL, UI_STATUS UI_STATUS, SHOW_ALL_NODES_FLAG SHOW_ALL_NODES_FLAG, PAGE_STATUS_TEMPLATE_USAGE PAGE_STATUS_TEMPLATE_USAGE, SUPPRESS_REFRESH_FLAG SUPPRESS_REFRESH_FLAG, UI_TIMESTAMP_REFRESH UI_TIMESTAMP_REFRESH, DRILLDOWN_TX_TYPE DRILLDOWN_TX_TYPE, CONTENT_LAST_UPDATE_DATE CONTENT_LAST_UPDATE_DATE, DISABLE_AUTOOVERRIDE_FLAG DISABLE_AUTOOVERRIDE_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "CZ"."CZ_UI_DEFS"

View Text - HTML Formatted

SELECT LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UI_DEF_ID UI_DEF_ID
, DESC_TEXT DESC_TEXT
, NAME NAME
, DEVL_PROJECT_ID DEVL_PROJECT_ID
, COMPONENT_ID COMPONENT_ID
, TREE_SEQ TREE_SEQ
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, UI_STYLE UI_STYLE
, GEN_VERSION GEN_VERSION
, TREENODE_DISPLAY_SOURCE TREENODE_DISPLAY_SOURCE
, GEN_HEADER GEN_HEADER
, CONTROLS_PER_SCREEN CONTROLS_PER_SCREEN
, LOOK_AND_FEEL LOOK_AND_FEEL
, PERSISTENT_UI_DEF_ID PERSISTENT_UI_DEF_ID
, MASTER_TEMPLATE_FLAG MASTER_TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, BOMQTYINPUTCTRLS BOMQTYINPUTCTRLS
, BOMUI_LAYOUT BOMUI_LAYOUT
, CONTROL_LAYOUT CONTROL_LAYOUT
, CTRLTEMPLATEUSE_BUTTONBAR CTRLTEMPLATEUSE_BUTTONBAR
, CTRLTEMPLATEUSE_UTILITYPAGE CTRLTEMPLATEUSE_UTILITYPAGE
, CTRLTEMPLUSE_BOM CTRLTEMPLUSE_BOM
, CTRLTEMPLUSE_COMMON CTRLTEMPLUSE_COMMON
, CTRLTEMPLUSE_NONBOM CTRLTEMPLUSE_NONBOM
, CTRLTEMPLUSE_OPTMSG CTRLTEMPLUSE_OPTMSG
, CTRLTEMPLUSE_REQDMSG CTRLTEMPLUSE_REQDMSG
, DRILLDOWN_CONTROL_TEXT_ID DRILLDOWN_CONTROL_TEXT_ID
, DRILLDOWN_IMAGE_URL DRILLDOWN_IMAGE_URL
, EMPTY_UI_FLAG EMPTY_UI_FLAG
, ERR_RUN_ID ERR_RUN_ID
, FROM_MASTER_TEMPLATE_ID FROM_MASTER_TEMPLATE_ID
, MENU_CAPTION_RULE_ID MENU_CAPTION_RULE_ID
, MODEL_TIMESTAMP MODEL_TIMESTAMP
, NONBOM_UILAYOUT NONBOM_UILAYOUT
, OPTION_SORT_METHOD OPTION_SORT_METHOD
, OPTION_SORT_ORDER OPTION_SORT_ORDER
, OPTION_SORT_PROPERTY_ID OPTION_SORT_PROPERTY_ID
, OPTION_SORT_SELECT_FIRST OPTION_SORT_SELECT_FIRST
, OUTER_TEMPLATE_USAGE OUTER_TEMPLATE_USAGE
, PAGE_CAPTION_RULE_ID PAGE_CAPTION_RULE_ID
, PAGE_LAYOUT PAGE_LAYOUT
, PAGE_SET_ID PAGE_SET_ID
, PAGINATION_SLOT PAGINATION_SLOT
, PAGIN_BOMOC PAGIN_BOMOC
, PAGIN_DRILLDOWNCTRL PAGIN_DRILLDOWNCTRL
, PAGIN_MAXCONTROLS PAGIN_MAXCONTROLS
, PAGIN_NONINST PAGIN_NONINST
, PAGIN_NONINST_REFCOMP PAGIN_NONINST_REFCOMP
, PRESERVE_MODEL_HIERARCHY PRESERVE_MODEL_HIERARCHY
, PRICE_DISPLAY PRICE_DISPLAY
, PRICE_UPDATE PRICE_UPDATE
, PRIMARY_NAVIGATION PRIMARY_NAVIGATION
, ROWS_PER_TABLE ROWS_PER_TABLE
, SHOW_TRAIN SHOW_TRAIN
, START_PAGE_ID START_PAGE_ID
, START_URL START_URL
, UI_STATUS UI_STATUS
, SHOW_ALL_NODES_FLAG SHOW_ALL_NODES_FLAG
, PAGE_STATUS_TEMPLATE_USAGE PAGE_STATUS_TEMPLATE_USAGE
, SUPPRESS_REFRESH_FLAG SUPPRESS_REFRESH_FLAG
, UI_TIMESTAMP_REFRESH UI_TIMESTAMP_REFRESH
, DRILLDOWN_TX_TYPE DRILLDOWN_TX_TYPE
, CONTENT_LAST_UPDATE_DATE CONTENT_LAST_UPDATE_DATE
, DISABLE_AUTOOVERRIDE_FLAG DISABLE_AUTOOVERRIDE_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CZ"."CZ_UI_DEFS"