HZ_STYLE_FMT_LAYOUTS_VL

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name
STYLE_FMT_LAYOUT_ID PROMPT STYLE_FORMAT_CODE VARIATION_NUMBER ATTRIBUTE_CODE LINE_NUMBER POSITION MANDATORY_FLAG USE_INITIAL_FLAG UPPERCASE_FLAG TRANSFORM_FUNCTION DELIMITER_BEFORE DELIMITER_AFTER BLANK_LINES_BEFORE BLANK_LINES_AFTER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DISPLAY_SIZE START_DATE_ACTIVE END_DATE_ACTIVE STATUS_FLAG

Query

SQL_Statement

SELECT B.STYLE_FMT_LAYOUT_ID, T.PROMPT, B.STYLE_FORMAT_CODE, B.VARIATION_NUMBER, B.ATTRIBUTE_CODE, B.LINE_NUMBER, B.POSITION, B.MANDATORY_FLAG, B.USE_INITIAL_FLAG, B.UPPERCASE_FLAG, B.TRANSFORM_FUNCTION, B.DELIMITER_BEFORE, B.DELIMITER_AFTER, B.BLANK_LINES_BEFORE, B.BLANK_LINES_AFTER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.DISPLAY_SIZE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE,B.STATUS_FLAG FROM HZ_STYLE_FMT_LAYOUTS_B B, HZ_STYLE_FMT_LAYOUTS_TL T WHERE B.STYLE_FMT_LAYOUT_ID = T.STYLE_FMT_LAYOUT_ID AND T.LANGUAGE = USERENV('LANG')