[Home] [Help] [Dependency Information]
Object Name: | ZPB_PUBLISHED_CYCLES_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 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 | Standard who column. | ||
PUBLISHED_BY | NUMBER | Standard who column. | ||
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. |
EDITABLE_AC_ID | NUMBER | Editable Business Process ID. | ||
TMP_AC_ID | NUMBER | Temporary 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
, EDITABLE_AC_ID
, TMP_AC_ID
FROM APPS.ZPB_PUBLISHED_CYCLES_V;
|
|
|