[Home] [Help] [Dependency Information]
Object Name: | ZPB_ANALYSIS_CYCLE_TASKS |
---|---|
Object Type: | TABLE |
Owner: | ZPB |
Subobject Name: | |
Status: | VALID |
Set of Tasks for an Analysis Cycle definition. It is also the set to be run for instances of published analysis cycles.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZPB_ANALYSIS_CYCLE_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TASK_ID |
ZPB_ANALYSIS_CYCLE_TASKS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ANALYSIS_CYCLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANALYSIS_CYCLE_ID | NUMBER | Yes | Instance of a published cycle - part of zpb_instance_tasks_pk | |
TASK_ID | NUMBER | Yes | A task within an instance of a published cycle - part of zpb_instance_tasks_pk | |
SEQUENCE | NUMBER | Yes | Order of tasks within an Instance | |
TASK_NAME | VARCHAR2 | (256) | Task Name | |
STATUS_CODE | VARCHAR2 | (30) | Last know status for this task. | |
ITEM_TYPE | VARCHAR2 | (8) | Yes | Workflow Item Type where process is defined |
WF_PROCESS_NAME | VARCHAR2 | (30) | Yes | Name of Workflow process to be started for this task |
ITEM_KEY | VARCHAR2 | (240) | Workflow Item Key used for this task process. | |
START_DATE | DATE | Date this task was started. | ||
HIDE_SHOW | VARCHAR2 | (1) | Used to drill to more detail | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OWNER_ID | NUMBER | Yes | Owner of the Task |
Cut, paste (and edit) the following text to query this object:
SELECT ANALYSIS_CYCLE_ID
, TASK_ID
, SEQUENCE
, TASK_NAME
, STATUS_CODE
, ITEM_TYPE
, WF_PROCESS_NAME
, ITEM_KEY
, START_DATE
, HIDE_SHOW
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OWNER_ID
FROM ZPB.ZPB_ANALYSIS_CYCLE_TASKS;
ZPB.ZPB_ANALYSIS_CYCLE_TASKS does not reference any database object
ZPB.ZPB_ANALYSIS_CYCLE_TASKS is referenced by following:
|
|
|