ENG Tables (87)
ENG - Engineering — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
ENG_ATTACHMENT_CHANGES |
36 | Table that stores the attachment related changes |
ENG_ATTRIBUTES_SECTIONS_B |
8 | Stores attribute sections |
ENG_ATTRIBUTES_SECTIONS_TL |
10 | MLS table for attribute sections |
ENG_AUTO_NUMBER_ECN |
17 | Holds the prefix and numbers for auto numbering an engineering change order (ECO) |
ENG_CATEGORY_RELATIONSHIPS |
11 | Stores change category relationships |
ENG_CATEGORY_SUBJECTS |
11 | ENG_CATEGORY_SUBJECTS |
ENG_CHANGES_EXT |
101 | |
ENG_CHANGES_EXT_B |
99 | It stores the user defined attribute values for Change Object |
ENG_CHANGES_EXT_TL |
51 | It stores the user defined attribute values for Change Object ( MLS table) |
ENG_CHANGE_ACTIONS |
30 | Change Management Actions |
ENG_CHANGE_ACTIONS_TL |
9 | Engineering Change Management Actions (MLS Table) |
ENG_CHANGE_CLASSIFICATIONS_B |
8 | Stores change classification information |
ENG_CHANGE_CLASSIFICATIONS_TL |
10 | MLS table for change classifications |
ENG_CHANGE_IMTEXT_TL |
8 | CHANGE_IMTEXT_TL |
ENG_CHANGE_LINES |
34 | Engineering Change Lines (Base MLS table) |
ENG_CHANGE_LINES_EXT |
101 | |
ENG_CHANGE_LINES_EXT_B |
99 | Engineering Change Line User Defined Attribute values (Base MLS table) |
ENG_CHANGE_LINES_EXT_TL |
51 | Engineering Change Line User Defined Attribute values ( MLS table) |
ENG_CHANGE_LINES_INTERFACE |
29 | Engineering Change Lines Import |
ENG_CHANGE_LINES_TL |
10 | Engineering Change Lines (MLS table) |
ENG_CHANGE_LOCAL_ORGS |
8 | This table is used to store list of Local organizations for a change with or without a hierarchy reference |
ENG_CHANGE_LOGS_B |
16 | Table to store change log information |
ENG_CHANGE_LOGS_TL |
9 | MLS table for change logs |
ENG_CHANGE_MGMT_TYPES |
11 | Enginnering Change Categories (Base MLS table) |
ENG_CHANGE_MGMT_TYPES_TL |
11 | Enginnering Change Categories ( MLS table) |
ENG_CHANGE_OBJECTS |
25 | Engineering Change Objects (Base MLS Table) |
ENG_CHANGE_OBJECTS_TL |
13 | Engineering Change Objects ( MLS Table) |
ENG_CHANGE_OBJ_RELATIONSHIPS |
14 | ENG Change Relationships |
ENG_CHANGE_ORDER_REVISIONS |
34 | Engineering change order (ECO) reasons |
ENG_CHANGE_ORDER_TYPES |
49 | Engineering change order types |
ENG_CHANGE_ORDER_TYPES_TL |
12 | MLS table for eng change order types |
ENG_CHANGE_PEOPLE_INTF |
26 | Engineering Change People Import |
ENG_CHANGE_POLICIES |
14 | Engineering change policies |
ENG_CHANGE_POLICY_APPROVERS |
9 | Stores the approver information of a change policies |
ENG_CHANGE_POLICY_VALUES |
9 | Stores change policy values |
ENG_CHANGE_PRIORITIES |
31 | Engineering change order priorities |
ENG_CHANGE_PROPAGATION_MAPS |
28 | This table is used to store Change propagation mapping betwen source and destination entities |
ENG_CHANGE_REASONS |
30 | Engineering change order reasons |
ENG_CHANGE_ROLES_TEMP |
3 | Engineering Change Roles Import |
ENG_CHANGE_ROUTES |
47 | Engineering Change Route Teamplates (Base MLS Table) |
ENG_CHANGE_ROUTES_TL |
11 | Engineering Change Route Teamplates ( MLS Table) |
ENG_CHANGE_ROUTE_ASSOCS |
25 | |
ENG_CHANGE_ROUTE_PEOPLE |
23 | Engineering Change Route Template People (Base MLS Table) |
ENG_CHANGE_ROUTE_PEOPLE_TL |
10 | Engineering Change Route Template People ( MLS Table) |
ENG_CHANGE_ROUTE_STEPS |
42 | Engineering Change Route Steps ( Base MLS Table) |
ENG_CHANGE_ROUTE_STEPS_TL |
10 | Engineering Change Route Steps ( MLS Table) |
ENG_CHANGE_RULES |
10 | Engineering change rules |
ENG_CHANGE_RULE_ATTRIBUTES_B |
11 | Stores the change rule attributes |
ENG_CHANGE_RULE_ATTRIBUTES_TL |
13 | MLS table for Change rule attributes |
ENG_CHANGE_STATUSES |
12 | Engineering Change Statuses (Base MLS Table) |
ENG_CHANGE_STATUSES_TL |
11 | Engineering Change Statuses ( MLS Table) |
ENG_CHANGE_SUBJECTS |
20 | |
ENG_CHANGE_TASKS_B |
12 | Stores the engineering change tasks |
ENG_CHANGE_TASKS_TL |
10 | MLS table for change tasks |
ENG_CHANGE_TEMPLATES_B |
9 | Stores change templates information |
ENG_CHANGE_TEMPLATES_TL |
10 | MLS table for change templates |
ENG_CHANGE_TYPE_APPLICATIONS |
8 | Change type applications |
ENG_CHANGE_TYPE_CLASS_CODES |
8 | Change type class codes |
ENG_CHANGE_TYPE_ORG_TASKS |
11 | Change Type organization tasks |
ENG_CHANGE_TYPE_PRIORITIES |
8 | Change type priorities |
ENG_CHANGE_TYPE_PROCESSES |
29 | Engineering change type processes |
ENG_CHANGE_TYPE_REASONS |
8 | Stores the associated reasons for change types |
ENG_CHANGE_TYPE_ROUTES |
11 | Engineering Change Type Route Templates |
ENG_CHG_USR_ATR_INTERFACE |
30 | Engineering Change User Defined Attributes Import |
ENG_CURRENT_SCHEDULED_DATES |
20 | Current and historical ECO scheduled implementation dates |
ENG_ECN_APPROVAL_LISTS |
25 | Engineering change order approval lists |
ENG_ECN_APPROVERS |
27 | Engineering change order approvers |
ENG_ECO_REVISIONS_INTERFACE |
38 | Temporary store of revision information about an engineering change order |
ENG_ECO_SUBMIT_REVISIONS |
14 | Approval history |
ENG_ENGINEERING_CHANGES |
73 | Engineering change orders |
ENG_ENG_CHANGES_INTERFACE |
85 | Mass change orders |
ENG_LIFECYCLE_STATUSES |
26 | Stores the statuses of lifecycle |
ENG_LOGIN_ACCESS_CHANGES |
3 | Engineering Change People Import to check the user access |
ENG_ORG_HIERARCHY_POLICIES |
8 | Organization hierarchy policies |
ENG_PENDING_CHANGE_CTX |
21 | Pending changes |
ENG_RELATIONSHIP_CHANGES |
25 | Stores related entity information |
ENG_REVISED_COMPONENTS |
83 | Implemented and cancelled revised components |
ENG_REVISED_ITEMS |
94 | Pending and implemented revised items |
ENG_REVISED_ITEMS_INTERFACE |
82 | Mass change details |
ENG_REVISED_ITEMS_TEMP |
22 | |
ENG_REVISED_OPERATIONS |
65 | Revised Operations |
ENG_STATUS_PROPERTIES |
9 | Stores the properties of the change lifecycle statuses |
ENG_SUBJECTS_B |
12 | Stores subject information |
ENG_SUBJECTS_TL |
10 | MLS table for subjects |
ENG_SUBJECT_ENTITIES |
16 | Stores subject entities |
ENG_TYPE_ORG_HIERARCHIES |
10 | Organization hierarchies and change type intersection table |
ENG_TYPE_ORG_PROPERTIES |
9 | Change type organization properties |