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_PROCESSES

Object Details

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

AZ_PROCESSES stores information about the runnable workflow
processes with different context names and context types. Each record
contains the item type, process name, context ID, context name, and
context type, as well as the complete flag, the parent process group
that it is associated with, the display order in the hierarchy tree,
and the user entered comments for the process from the Implementation
Wizard form.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AZ_PROCESSES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ITEM_TYPE PROCESS_NAME CONTEXT_ID
AZ_PROCESSES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	PARENT_ID PROCESS_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_TYPE	VARCHAR2	(30)	Yes	Identifies if the process belongs to a fresh implementation or an upgrade
ITEM_TYPE	VARCHAR2	(30)	Yes	Item type
PROCESS_NAME	VARCHAR2	(30)	Yes	Internal name of the process activity
CONTEXT_ID	NUMBER	(15)	Yes	Context identifier
DISPLAY_ORDER	NUMBER	(15)	Yes	Display order of the process in the hierarchy tree
STATUS_CODE	VARCHAR2	(30)	Yes	Status for the process (A for Active, N for Not Started, C for Complete)
CONTEXT_TYPE	VARCHAR2	(30)	Yes	Context type of the process (BG for business group, IO for inventory organization, OU for operating unit, SOB for set of books)
CONTEXT_NAME	VARCHAR2	(80)		Context name of the process
COMMENTS	VARCHAR2	(2000)		User-entered comments for the process
PARENT_ID	VARCHAR2	(240)	Yes	Parent process group that the process is associated with
COMPLETE_FLAG	VARCHAR2	(1)		Flag to indicate whether the process is complete

Query Text

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


SELECT PROCESS_TYPE
,      ITEM_TYPE
,      PROCESS_NAME
,      CONTEXT_ID
,      DISPLAY_ORDER
,      STATUS_CODE
,      CONTEXT_TYPE
,      CONTEXT_NAME
,      COMMENTS
,      PARENT_ID
,      COMPLETE_FLAG
FROM AZ.AZ_PROCESSES;

Dependencies

[top of page]

AZ.AZ_PROCESSES does not reference any database object

AZ.AZ_PROCESSES is referenced by following:

APPS: AZ_PROCESSES