DBA Data[Home] [Help]

VIEW: APPS.CZ_EXT_APPLICATIONS_V

Source

View Text - Preformatted

SELECT fnd_application.APPLICATION_ID, fnd_application.application_short_name, fnd_application.basepath, fnd_application.created_by, fnd_application.creation_date, fnd_application.last_updated_by, fnd_application.last_update_date, fnd_application_tl.language, fnd_application_tl.application_name, fnd_application_tl.description, cz_ext_applications.preferred_ui_style from fnd_application, fnd_application_tl, cz_ext_applications WHERE cz_ext_applications.application_id = fnd_application.application_id and fnd_application.application_id = fnd_application_tl.application_id AND fnd_application_tl.language = userenv('LANG')
View Text - HTML Formatted

SELECT FND_APPLICATION.APPLICATION_ID
, FND_APPLICATION.APPLICATION_SHORT_NAME
, FND_APPLICATION.BASEPATH
, FND_APPLICATION.CREATED_BY
, FND_APPLICATION.CREATION_DATE
, FND_APPLICATION.LAST_UPDATED_BY
, FND_APPLICATION.LAST_UPDATE_DATE
, FND_APPLICATION_TL.LANGUAGE
, FND_APPLICATION_TL.APPLICATION_NAME
, FND_APPLICATION_TL.DESCRIPTION
, CZ_EXT_APPLICATIONS.PREFERRED_UI_STYLE
FROM FND_APPLICATION
, FND_APPLICATION_TL
, CZ_EXT_APPLICATIONS
WHERE CZ_EXT_APPLICATIONS.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID
AND FND_APPLICATION.APPLICATION_ID = FND_APPLICATION_TL.APPLICATION_ID
AND FND_APPLICATION_TL.LANGUAGE = USERENV('LANG')