FND Design Data [Home] [Help]

Table: ENG_ENGINEERING_CHANGES

Product: ENG - Engineering
Description: Engineering change orders
Implementation/DBA Data: TableENG.ENG_ENGINEERING_CHANGES
Primary Key: ENG_ENGINEERING_CHANGES_PK
  1. ColumnCHANGE_NOTICE
  2. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ENG_ENGINEERING_CHANGES FK Joins to TableENG_CHANGE_PRIORITIES ENG_ENGINEERING_CHANGES.PRIORITY_CODE
ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
ENG_ENGINEERING_CHANGES FK Joins to TableENG_CHANGE_REASONS ENG_ENGINEERING_CHANGES.REASON_CODE
ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
ENG_ENGINEERING_CHANGES FK Joins to TableENG_ECN_APPROVAL_LISTS ENG_ENGINEERING_CHANGES.APPROVAL_LIST_ID
ENG_ENGINEERING_CHANGES FK Joins to TableENG_CHANGE_ORDER_TYPES ENG_ENGINEERING_CHANGES.CHANGE_ORDER_TYPE_ID
ENG_ENGINEERING_CHANGES FK Joins to TableHR_ALL_ORGANIZATION_UNITS ENG_ENGINEERING_CHANGES.RESPONSIBLE_ORGANIZATION_ID
ENG_ENGINEERING_CHANGES FK Joins to TableMTL_PARAMETERS ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
TableBOM_BILL_OF_MATERIALS FK Joins to ENG_ENGINEERING_CHANGES BOM_BILL_OF_MATERIALS.PENDING_FROM_ECN
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
TableBOM_STRUCTURES_B FK Joins to ENG_ENGINEERING_CHANGES BOM_STRUCTURES_B.PENDING_FROM_ECN
BOM_STRUCTURES_B.ORGANIZATION_ID
TableENG_CHANGE_ORDER_REVISIONS FK Joins to ENG_ENGINEERING_CHANGES ENG_CHANGE_ORDER_REVISIONS.CHANGE_NOTICE
ENG_CHANGE_ORDER_REVISIONS.ORGANIZATION_ID
TableENG_REVISED_ITEMS FK Joins to ENG_ENGINEERING_CHANGES ENG_REVISED_ITEMS.CHANGE_NOTICE
ENG_REVISED_ITEMS.ORGANIZATION_ID
TableMRP_PENDING_ENG_CHANGES FK Joins to ENG_ENGINEERING_CHANGES MRP_PENDING_ENG_CHANGES.CHANGE_NOTICE
MRP_PENDING_ENG_CHANGES.ORGANIZATION_ID
TableMTL_ITEM_REVISIONS_B FK Joins to ENG_ENGINEERING_CHANGES MTL_ITEM_REVISIONS_B.CHANGE_NOTICE
MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
TableMTL_RTG_ITEM_REVISIONS FK Joins to ENG_ENGINEERING_CHANGES MTL_RTG_ITEM_REVISIONS.CHANGE_NOTICE
MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID
TableMTL_SYSTEM_ITEMS_B FK Joins to ENG_ENGINEERING_CHANGES MTL_SYSTEM_ITEMS_B.ENGINEERING_ECN_CODE
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID