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