DBA Data[Home] [Help] [Dependency Information]

TABLE: ENG.ENG_CHANGE_TASKS_B

Object Details
Object Name: ENG_CHANGE_TASKS_B
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_CHANGE_TASKS_B
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.This table stores the engineering change tasks.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CHANGE_TASK_ID NUMBER
Yes Change Tasks internal identifier
ORGANIZATION_ID NUMBER
Yes Internal identifier of organization
CHANGE_TEMPLATE_ID NUMBER

Internal identifier og change templates
SEQUENCE_NUMBER NUMBER

Sequence number of the tasks
REQUIRED_FLAG VARCHAR2 (1) Yes Flag to indicate if the task is mandatory
DEFAULT_ASSIGNEE_ID NUMBER

Internal identifier of the assignee who the task is defaulted to
DEFAULT_ASSIGNEE_TYPE VARCHAR2 (80)
Type of the default assignee
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHANGE_TASK_ID
,      ORGANIZATION_ID
,      CHANGE_TEMPLATE_ID
,      SEQUENCE_NUMBER
,      REQUIRED_FLAG
,      DEFAULT_ASSIGNEE_ID
,      DEFAULT_ASSIGNEE_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ENG.ENG_CHANGE_TASKS_B;

Dependencies

[top of page]

ENG.ENG_CHANGE_TASKS_B does not reference any database object

ENG.ENG_CHANGE_TASKS_B is referenced by following:

SchemaAPPS
SynonymENG_CHANGE_TASKS_B