DBA Data[Home] [Help]

VIEW: APPS.AZ_API_PREFERENCES_VL

Source

View Text - Preformatted

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


View Text - HTML Formatted

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