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]

TABLE: AZ.AZ_GROUPS

Object Details

Object Name:	AZ_GROUPS
Object Type:	TABLE
Owner:	AZ
FND Design Data:	AZ.AZ_GROUPS
Subobject Name:
Status:	VALID

AZ_GROUPS stores information about the process groups used in the Implementation Wizard form. Each record contains the unique identifier of the group, the parent process group that is associated with the group, as well as the display order, color code, complete flag, and the application or lookup code that the process group is associated with. Additionally, to enable differents types of implementation of the Wizard, there is also a process type for each group indicating its implementation type.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AZ_GROUPS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	GROUP_ID PROCESS_TYPE
AZ_GROUPS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	HIERARCHY_PARENT_ID HIERARCHY_PARENT_PROCESS_TYPE
AZ_GROUPS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	DEPENDENCY_PARENT_ID DEPENDENCY_PARENT_PROCESS_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	VARCHAR2	(240)	Yes	Group identifier
PROCESS_TYPE	VARCHAR2	(30)	Yes	Identifies the implementation type for the process
HIERARCHY_PARENT_PROCESS_TYPE	VARCHAR2	(30)		Implementation type for the parent of the node
COMPLETE_FLAG	VARCHAR2	(1)	Yes	Indicates whether the process group is complete
COLOR_CODE	VARCHAR2	(30)		Color code associated with the process group
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
DEPENDENCY_PARENT_PROCESS_TYPE	VARCHAR2	(30)		Implementation type (upgrade or fresh implementation) of dependency parent or node
DISPLAY_ORDER	NUMBER	(15)	Yes	Display order of process groups at different levels
APPLICATION_ID	NUMBER	(15)		Application identifier
LOOKUP_CODE	VARCHAR2	(30)		Quickcode code
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
HIERARCHY_PARENT_ID	VARCHAR2	(240)		Parent process group that the process group is associated with in the hierarchy tree
DEPENDENCY_PARENT_ID	VARCHAR2	(240)		Parent process group that the process group is associated with in the dependency chart

Query Text

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


SELECT GROUP_ID
,      PROCESS_TYPE
,      HIERARCHY_PARENT_PROCESS_TYPE
,      COMPLETE_FLAG
,      COLOR_CODE
,      CREATION_DATE
,      CREATED_BY
,      DEPENDENCY_PARENT_PROCESS_TYPE
,      DISPLAY_ORDER
,      APPLICATION_ID
,      LOOKUP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      HIERARCHY_PARENT_ID
,      DEPENDENCY_PARENT_ID
FROM AZ.AZ_GROUPS;

Dependencies

[top of page]

AZ.AZ_GROUPS does not reference any database object

AZ.AZ_GROUPS is referenced by following:

AZ: AZ_GROUPS#