Product: | AR - Receivables |
---|---|
Description: | Translation view for name and address formatting style layouts |
Implementation/DBA Data: | APPS.HZ_STYLE_FMT_LAYOUTS_VL |
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')