[Home] [Help]
View: AZ_API_PREF_SRC_ATTRIBUTES_VL
View Text
SELECT
B.PREFERENCE_CODE
, B.DATA_SOURCE
, B.ATTRIBUTE_CODE
, T.DISPLAY_NAME
,
B.KEY_FLAG
, B.ENABLE_REPORT_FLAG
, B.PARAM1
, B.PARAM2
, B.PARAM3
, B.PARAM4
, B.PARAM5
,
B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
FROM
AZ_API_PREF_SRC_ATTRIBUTES_B B
, AZ_API_PREF_SRC_ATTRIBUTES_TL T
WHERE
B.PREFERENCE_CODE = T.PREFERENCE_CODE
AND
B.DATA_SOURCE = T.DATA_SOURCE
AND
B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
AND
T.LANGUAGE = USERENV('LANG')