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

VIEW: APPS.ZPB_PROCESS_DETAILS_V

Object Details
Object Name: ZPB_PROCESS_DETAILS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view lists all the Tasks for a given Business Process.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ANALYSIS_CYCLE_ID NUMBER
Yes Business Process ID.
CYCLE_NAME VARCHAR2 (300) Yes Business Process Name.
TASK_NAME VARCHAR2 (256)
Task Name.
SEQUENCE NUMBER
Yes Order of tasks within an Instance
NAME VARCHAR2 (100)
Internal Name for parameter used within this task
TASK_ID NUMBER
Yes A unique task within a Business Process or one of its instances.
VALUE VARCHAR2 (4000)
Parameter Value.
PARAM_ID NUMBER (22) Yes Unique ID corresponding to a parameter value.
Query Text

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


SELECT ANALYSIS_CYCLE_ID
,      CYCLE_NAME
,      TASK_NAME
,      SEQUENCE
,      NAME
,      TASK_ID
,      VALUE
,      PARAM_ID
FROM APPS.ZPB_PROCESS_DETAILS_V;

Dependencies

[top of page]

APPS.ZPB_PROCESS_DETAILS_V references the following:

SchemaAPPS
SynonymZPB_ANALYSIS_CYCLES
SynonymZPB_ANALYSIS_CYCLE_TASKS
SynonymZPB_TASK_PARAMETERS
APPS.ZPB_PROCESS_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyZPB_WF - show dependent code
Package BodyZPB_WFMNT - show dependent code
Package BodyZPB_WF_NTF - show dependent code