[Home] [Help] [Dependency Information]
Object Name: | ZPB_ANALYSIS_CYCLES |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
This table stores the Business Process and instance definition parameters including the Name, Description and Status.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_ANALYSIS_CYCLES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ANALYSIS_CYCLE_ID |
ZPB_ANALYSIS_CYCLES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NAME |
ZPB_ANALYSIS_CYCLES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PUBLISHED_BY |
ZPB_ANALYSIS_CYCLES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_AREA_ID |
ZPB_ANALYSIS_CYCLES_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUS_CODE |
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. |
PREV_STATUS_CODE | VARCHAR2 | (30) | Previous status of Business Process. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
BUSINESS_AREA_ID | NUMBER | Yes | Business Area to which this Business Process belongs. | |
OWNER_ID | NUMBER | Yes | Owner of the Business Process. |
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
, PREV_STATUS_CODE
, LAST_UPDATE_LOGIN
, BUSINESS_AREA_ID
, OWNER_ID
FROM ZPB.ZPB_ANALYSIS_CYCLES;
ZPB.ZPB_ANALYSIS_CYCLES does not reference any database object
ZPB.ZPB_ANALYSIS_CYCLES is referenced by following:
|
|
|