CZ_UI_HINTS_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name

UI_HINT_ID START_MODEL_VERSION OBJECT_VERSION_NUMBER MODEL_ID CAPTION NODE_PATH NODE_ID TRANS_ATTR_ID CREATE_PAGE_FLAG UI_TEMPL_ID_WHEN_REGION UI_TEMPL_ID_WHEN_PAGE UI_TEMPL_ID_WHEN_PAGE_ITEM UI_TEMPL_ID_RGN_LAYOUT1 UI_TEMPL_ID_RGN_LAYOUT2 UI_TEMPL_ID_RGN_LAYOUT3 UI_TEMPL_ID_WHEN_RGN_HDR INTEGRATION_MODE DISPLAY_FLAG DISPLAY_CONDITION_ID ENABLE_CONDITION_ID NESTED_GROUP_FLAG USER_INPUT_REQUIRED_FLAG END_MODEL_VERSION DELETED_FLAG UI_TIMESTAMP_ADD UI_TIMESTAMP_REMOVE UNSELECTED_IMAGE_ATTACHMENT_ID SELECTED_IMAGE_ATTACHMENT_ID EXCLUDED_IMAGE_ATTACHMENT_ID CHILD_SORT_ORDER LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.UI_HINT_ID, B.START_MODEL_VERSION, B.OBJECT_VERSION_NUMBER, B.MODEL_ID, TL.CAPTION, B.NODE_PATH, B.NODE_ID, B.TRANS_ATTR_ID, B.CREATE_PAGE_FLAG, B.UI_TEMPL_ID_WHEN_REGION, B.UI_TEMPL_ID_WHEN_PAGE, B.UI_TEMPL_ID_WHEN_PAGE_ITEM, B.UI_TEMPL_ID_RGN_LAYOUT1, B.UI_TEMPL_ID_RGN_LAYOUT2, B.UI_TEMPL_ID_RGN_LAYOUT3, B.UI_TEMPL_ID_WHEN_RGN_HDR, B.INTEGRATION_MODE, B.DISPLAY_FLAG, B.DISPLAY_CONDITION_ID, B.ENABLE_CONDITION_ID, B.NESTED_GROUP_FLAG, B.USER_INPUT_REQUIRED_FLAG, B.END_MODEL_VERSION, B.DELETED_FLAG, B.UI_TIMESTAMP_ADD, B.UI_TIMESTAMP_REMOVE, B.UNSELECTED_IMAGE_ATTACHMENT_ID, B.SELECTED_IMAGE_ATTACHMENT_ID, B.EXCLUDED_IMAGE_ATTACHMENT_ID, B.CHILD_SORT_ORDER, B.LAST_UPDATE_DATE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM CZ_UI_HINTS_B B, CZ_UI_HINTS_TL TL WHERE B.UI_HINT_ID = TL.UI_HINT_ID AND B.START_MODEL_VERSION = TL.START_MODEL_VERSION AND TL.LANGUAGE = USERENV('LANG')