[Home] [Help] [Dependency Information]
Object Name: | ENG_CHANGE_TYPE_ORG_TASKS |
---|---|
Object Type: | TABLE |
Owner: | ENG |
FND Design Data: | ENG.ENG_CHANGE_TYPE_ORG_TASKS |
Subobject Name: | |
Status: | VALID |
Change tasks help ensure that mandatory work is completed before a change
order is implemented or promoted to the next status. You can use change tasks
to create and assign work to individuals or groups. Each change task must be
started after and completed before specific statuses. Before you promote a
change order through its various statuses, its Mandatory change tasks must be
completed. If a task is listed, but is not Mandatory, the change order can be
promoted to the next status without completion of the task. CHANGE_TEMPLATE_OR_TASK_ID column refers to either ENG_CHANGE_TEMPLATES_B.CHANGE_TEMPLATE_ID or ENG_CHANGE_TASKS_B.CHANGE_TASK_ID"
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHANGE_TYPE_ID | NUMBER | Yes | Internal identifier for change types | |
ORGANIZATION_ID | NUMBER | Yes | Internal identifier for organization | |
TEMPLATE_OR_TASK_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate a template or a task |
CHANGE_TEMPLATE_OR_TASK_ID | NUMBER | Yes | Internal identifier of template or task | |
COMPLETE_BEFORE_STATUS_CODE | NUMBER | Complete before status code | ||
START_AFTER_STATUS_CODE | NUMBER | Start after status code | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT CHANGE_TYPE_ID
, ORGANIZATION_ID
, TEMPLATE_OR_TASK_FLAG
, CHANGE_TEMPLATE_OR_TASK_ID
, COMPLETE_BEFORE_STATUS_CODE
, START_AFTER_STATUS_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM ENG.ENG_CHANGE_TYPE_ORG_TASKS;
ENG.ENG_CHANGE_TYPE_ORG_TASKS does not reference any database object
ENG.ENG_CHANGE_TYPE_ORG_TASKS is referenced by following:
|
|
|