VIEW: APPS.CZ_MODEL_USAGES_VL

Source

View Text - Preformatted

SELECT cz_model_usages.model_usage_id, cz_model_usages.name, cz_model_usages_tl.description, cz_model_usages_tl.language, cz_model_usages_tl.source_lang, cz_model_usages.note, cz_model_usages.in_use, cz_model_usages.created_by, cz_model_usages.creation_date, cz_model_usages.last_updated_by, cz_model_usages.last_update_date, cz_model_usages.last_update_login FROM cz_model_usages, cz_model_usages_tl WHERE cz_model_usages_tl.LANGUAGE = userenv('LANG') and cz_model_usages.model_usage_id = cz_model_usages_tl.model_usage_id

View Text - HTML Formatted

SELECT CZ_MODEL_USAGES.MODEL_USAGE_ID
, CZ_MODEL_USAGES.NAME
, CZ_MODEL_USAGES_TL.DESCRIPTION
, CZ_MODEL_USAGES_TL.LANGUAGE
, CZ_MODEL_USAGES_TL.SOURCE_LANG
, CZ_MODEL_USAGES.NOTE
, CZ_MODEL_USAGES.IN_USE
, CZ_MODEL_USAGES.CREATED_BY
, CZ_MODEL_USAGES.CREATION_DATE
, CZ_MODEL_USAGES.LAST_UPDATED_BY
, CZ_MODEL_USAGES.LAST_UPDATE_DATE
, CZ_MODEL_USAGES.LAST_UPDATE_LOGIN
FROM CZ_MODEL_USAGES
, CZ_MODEL_USAGES_TL
WHERE CZ_MODEL_USAGES_TL.LANGUAGE = USERENV('LANG')
AND CZ_MODEL_USAGES.MODEL_USAGE_ID = CZ_MODEL_USAGES_TL.MODEL_USAGE_ID