[Home] [Help]
View: AZ_API_PREFERENCE_SOURCES_VL
View Text
SELECT
B.PREFERENCE_CODE
, B.DATA_SOURCE
, B.REF_DATA_SOURCE
, T.DISPLAY_NAME
,
B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
FROM
AZ_API_PREFERENCE_SOURCES_B B
, AZ_API_PREFERENCE_SOURCES_TL T
WHERE
B.PREFERENCE_CODE = T.PREFERENCE_CODE
AND
B.DATA_SOURCE = T.DATA_SOURCE
AND
T.LANGUAGE = USERENV('LANG')