[Home] [Help] [Dependency Information]
Object Name: | ZPB_EDITABLE_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 Business Process and instance definition parameters including the Name, Description and Status for editable business process.
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. |
PUBLISHED_AC_ID | NUMBER | Published 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
, PUBLISHED_AC_ID
, TMP_AC_ID
FROM APPS.ZPB_EDITABLE_CYCLES_V;
APPS.ZPB_EDITABLE_CYCLES_V is not referenced by any database object
|
|
|