DBA Data[Home] [Help]

VIEW: APPS.CSM_HZ_STYLE_FORMATS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.STYLE_FORMAT_CODE, T.STYLE_FORMAT_NAME, T.DESCRIPTION, B.STYLE_CODE, B.DEFAULT_FLAG FROM CSM_HZ_STYLE_FORMATS_ACC ACC, HZ_STYLE_FORMATS_B B, HZ_STYLE_FORMATS_TL T WHERE B.STYLE_FORMAT_CODE=ACC.STYLE_FORMAT_CODE AND B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.STYLE_FORMAT_CODE
, T.STYLE_FORMAT_NAME
, T.DESCRIPTION
, B.STYLE_CODE
, B.DEFAULT_FLAG
FROM CSM_HZ_STYLE_FORMATS_ACC ACC
, HZ_STYLE_FORMATS_B B
, HZ_STYLE_FORMATS_TL T
WHERE B.STYLE_FORMAT_CODE=ACC.STYLE_FORMAT_CODE
AND B.STYLE_FORMAT_CODE = T.STYLE_FORMAT_CODE
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE