eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CZ_EXT_APPLICATIONS_V

Object Details

Object Name:	CZ_EXT_APPLICATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_EXT_APPLICATIONS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is written to present a list of client applications for which Configurator models can be published.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Contains the numeric Application ID
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Short name of the application
BASEPATH	VARCHAR2	(20)		File system path for the root directory of this application
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
LANGUAGE	VARCHAR2	(4)	Yes	Associates a language with this application
APPLICATION_NAME	VARCHAR2	(240)	Yes	Full name of the Application
DESCRIPTION	VARCHAR2	(240)		Descriptive text
PREFERRED_UI_STYLE	VARCHAR2	(3)	Yes	Indicates the default UI style to use (cf CZ_UI_DEFS.UI_STYLE): 0 - components tree/dhtml; 3 - model tree/applet

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      BASEPATH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LANGUAGE
,      APPLICATION_NAME
,      DESCRIPTION
,      PREFERRED_UI_STYLE
FROM APPS.CZ_EXT_APPLICATIONS_V;

Dependencies

[top of page]

APPS.CZ_EXT_APPLICATIONS_V references the following:

APPS: CZ_EXT_APPLICATIONS; FND_APPLICATION; FND_APPLICATION_TL

APPS.CZ_EXT_APPLICATIONS_V is referenced by following:

APPS: CZ_UPGRADE - show dependent code