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.AZ_GROUPS_V

Object Details

Object Name:	AZ_GROUPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AZ.AZ_GROUPS_V
Subobject Name:
Status:	VALID

View Type

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

AZ_GROUPS_V is a view that joins AZ_GROUPS, FND_APPLICATION_VL, and FND_LOOKUPS to provide quick access to the display name of each group.

[View Source]

Columns

Name	Datatype	Length	Comments
GROUP_ID	VARCHAR2	(240)	Implementation group ID
PROCESS_TYPE	VARCHAR2	(30)	Type of processes belonging to this group
DISPLAY_NAME	VARCHAR2	(240)	Display name
DISPLAY_ORDER	NUMBER	(15)	The display order for this group
STATUS	VARCHAR2	(1)	Implementation status of this group
COMPLETE_FLAG	VARCHAR2	(1)	Completion status
APPLICATION_ID	NUMBER	(15)	Application ID of the group
LOOKUP_CODE	VARCHAR2	(30)	Lookup code of this group
COLOR_CODE	VARCHAR2	(30)	Color code for display
HIERARCHY_PARENT_ID	VARCHAR2	(240)	Hierarchy parent ID
HIERARCHY_PARENT_PROCESS_TYPE	VARCHAR2	(30)	Hierarchy parent process type
DEPENDENCY_PARENT_ID	VARCHAR2	(240)	Dependency parent ID
DEPENDENCY_PARENT_PROCESS_TYPE	VARCHAR2	(30)	Dependency parent process type
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER	(15)	Standard who column
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column

Query Text

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


SELECT GROUP_ID
,      PROCESS_TYPE
,      DISPLAY_NAME
,      DISPLAY_ORDER
,      STATUS
,      COMPLETE_FLAG
,      APPLICATION_ID
,      LOOKUP_CODE
,      COLOR_CODE
,      HIERARCHY_PARENT_ID
,      HIERARCHY_PARENT_PROCESS_TYPE
,      DEPENDENCY_PARENT_ID
,      DEPENDENCY_PARENT_PROCESS_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.AZ_GROUPS_V;

Dependencies

[top of page]

APPS.AZ_GROUPS_V references the following:

APPS: AZ_GROUPS; FND_APPLICATION_VL; FND_GLOBAL - show dependent code; FND_LOOKUPS

APPS.AZ_GROUPS_V is referenced by following:

APPS: AZW_ARCHIVE - show dependent code; AZW_REPORT - show dependent code