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


VIEW: APPS.AZ_PROCESSES_V

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

View Type

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


A view based on az_processes table. It provides a view of az_processes filtering processes by their
process type. The view contains wizard processes having process type equal to the current implementation mode which is a profile option.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (30) Yes Workflow item type
PROCESS_NAME VARCHAR2 (30) Yes Workflow process 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_CODE VARCHAR2 (30) Yes Implementation status for this process
PROCESS_TYPE VARCHAR2 (30) Yes Process type
CONTEXT_TYPE VARCHAR2 (30) Yes Context type
CONTEXT_NAME VARCHAR2 (80)
Name of the context
COMMENTS VARCHAR2 (2000)
Comments recorded for this process
Query Text

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


SELECT ITEM_TYPE
,      PROCESS_NAME
,      CONTEXT_ID
,      PARENT_ID
,      DISPLAY_ORDER
,      STATUS_CODE
,      PROCESS_TYPE
,      CONTEXT_TYPE
,      CONTEXT_NAME
,      COMMENTS
FROM APPS.AZ_PROCESSES_V;

Dependencies

[top of page]

APPS.AZ_PROCESSES_V references the following:

SchemaAPPS
SynonymAZ_PROCESSES
PL/SQL PackageFND_PROFILE - show dependent code

APPS.AZ_PROCESSES_V is not referenced by any database object