VIEW: APPS.AZ_TAXONOMIES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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