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

VIEW: APPS.AZ_PROCESSES_ALL_V

Object Details
Object Name: AZ_PROCESSES_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAZ.AZ_PROCESSES_ALL_V
Subobject Name:
Status: VALID

View Type

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


AZ_PROCESSES_V is a view based on ap_processes regardless of the process_type. It also provides quick access to the display name and the context type name of the processes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (30) Yes Workflow item type
PROCESS_NAME VARCHAR2 (30) Yes Workflow process name
DISPLAY_NAME VARCHAR2 (80) Yes Display name
CONTEXT_ID NUMBER (15) Yes ID of the context for this process
PARENT_ID VARCHAR2 (240) Yes Parent process ID
DISPLAY_ORDER NUMBER (15) Yes The display order for this process
STATUS VARCHAR2 (30) Yes Implementation status of this process
PROCESS_TYPE VARCHAR2 (30) Yes Process type
CONTEXT_TYPE VARCHAR2 (30) Yes Context type
CONTEXT_TYPE_NAME VARCHAR2 (80) Yes Context type display name
CONTEXT_NAME VARCHAR2 (80)
Name of the context
COMMENTS VARCHAR2 (2000)
Comments recorded for this context
DESCRIPTION VARCHAR2 (240)
Description for this process
Query Text

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


SELECT ITEM_TYPE
,      PROCESS_NAME
,      DISPLAY_NAME
,      CONTEXT_ID
,      PARENT_ID
,      DISPLAY_ORDER
,      STATUS
,      PROCESS_TYPE
,      CONTEXT_TYPE
,      CONTEXT_TYPE_NAME
,      CONTEXT_NAME
,      COMMENTS
,      DESCRIPTION
FROM APPS.AZ_PROCESSES_ALL_V;

Dependencies

[top of page]

APPS.AZ_PROCESSES_ALL_V references the following:

SchemaAPPS
SynonymAZ_PROCESSES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewWF_ACTIVITIES_VL
APPS.AZ_PROCESSES_ALL_V is referenced by following:

SchemaAPPS
Package BodyAZW_ARCHIVE - show dependent code
Package BodyAZW_REPORT - show dependent code