[Home] [Help] [Dependency Information]
Object Name: | ZPB_INSTANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view lists Business Process Instances of published Business Processes.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANALYSIS_CYCLE_ID | NUMBER | Yes | Business Process ID. | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status of the Business Process, e.g. whether it is Enabled, or Disabled, or Marked For Deletion etc. |
NAME | VARCHAR2 | (300) | Yes | Business Process Name. |
DESCRIPTION | VARCHAR2 | (4000) | Business Process description. | |
LOCKED_BY | NUMBER | Yes | User ID of the user who is currently locking the cycle for modifications. | |
VALIDATE_STATUS | VARCHAR2 | (30) | Yes | Stores the validation status of the Business Process, i.e. whether it has not yet been validated, or whether it has passed the validation checks, or whether it has failed the validation checks. |
CURRENT_INSTANCE_ID | NUMBER | Business Process ID of currently running instance of the business process identified by the ANALYSIS_CYCLE_ID column. | ||
PUBLISHED_DATE | DATE | The date on which the Business Process was published. | ||
PUBLISHED_BY | NUMBER | User ID of the user who published the Business Process identified by ANALYSIS_CYCLE_ID. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
INSTANCE_DESCRIPTION | VARCHAR2 | (300) | Description for the Instance. | |
PARENT_CYCLE_ID | NUMBER | Yes | Business Process ID. |
Cut, paste (and edit) the following text to query this object:
SELECT ANALYSIS_CYCLE_ID
, STATUS_CODE
, NAME
, DESCRIPTION
, LOCKED_BY
, VALIDATE_STATUS
, CURRENT_INSTANCE_ID
, PUBLISHED_DATE
, PUBLISHED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, INSTANCE_DESCRIPTION
, PARENT_CYCLE_ID
FROM APPS.ZPB_INSTANCES_V;
APPS.ZPB_INSTANCES_V is not referenced by any database object
|
|
|