[Home] [Help]
View: AZ_TAXONOMIES_VL
View Text
SELECT
B.TAXONOMY_CODE
, B.USER_ID
, B.ENABLED_FLAG
, T.TAXONOMY_NAME
,
T.TAXONOMY_DESC
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM
AZ_TAXONOMIES_B B
, AZ_TAXONOMIES_TL T
WHERE
B.TAXONOMY_CODE = T.TAXONOMY_CODE
AND B.USER_ID = T.USER_ID
AND T.LANGUAGE = USERENV('LANG')