DBA Data[Home] [Help]

VIEW: APPS.HZ_STYLE_FMT_LAYOUTS_VL

Source

View Text - Preformatted

SELECT B.STYLE_FMT_LAYOUT_ID, T.PROMPT, B.STYLE_FORMAT_CODE, B.VARIATION_NUMBER, B.ATTRIBUTE_CODE, B.ATTRIBUTE_APPLICATION_ID, 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 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')
View Text - HTML Formatted

SELECT B.STYLE_FMT_LAYOUT_ID
, T.PROMPT
, B.STYLE_FORMAT_CODE
, B.VARIATION_NUMBER
, B.ATTRIBUTE_CODE
, B.ATTRIBUTE_APPLICATION_ID
, 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
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')