[Home] [Help] [Dependency Information]
Object Name: | ZPB_TMP_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 Temporary 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. |
PUBLISHED_AC_ID | NUMBER | Published Business Process ID. | ||
EDITABLE_AC_ID | NUMBER | Editable 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
, EDITABLE_AC_ID
FROM APPS.ZPB_TMP_CYCLES_V;
APPS.ZPB_TMP_CYCLES_V is not referenced by any database object
|
|
|