[Home] [Help]
View: AZ_API_PREFERENCES_VL
View Text
SELECT B.PREFERENCE_CODE
,
T.PREFERENCE_NAME
,
T.PREFERENCE_DESC
,
B.API_CODE
,
B.API_VERSION
,
B.ENABLED_FLAG
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.USER_ID
FROM AZ_API_PREFERENCES_B B
,
AZ_API_PREFERENCES_TL T
WHERE B.PREFERENCE_CODE = T.PREFERENCE_CODE
AND T.LANGUAGE = USERENV('LANG')