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')
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')
|
|
|