Table: ENG_ENGINEERING_CHANGES

Product:	ENG - Engineering
Description:	Engineering change orders
Implementation/DBA Data:	ENG.ENG_ENGINEERING_CHANGES

Primary Key: ENG_ENGINEERING_CHANGES_PK

1. CHANGE_NOTICE
2. ORGANIZATION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
ENG_ENGINEERING_CHANGES		ENG_CHANGE_PRIORITIES	ENG_ENGINEERING_CHANGES.PRIORITY_CODE ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
ENG_ENGINEERING_CHANGES		ENG_CHANGE_REASONS	ENG_ENGINEERING_CHANGES.REASON_CODE ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
ENG_ENGINEERING_CHANGES		ENG_ECN_APPROVAL_LISTS	ENG_ENGINEERING_CHANGES.APPROVAL_LIST_ID
ENG_ENGINEERING_CHANGES		ENG_CHANGE_ORDER_TYPES	ENG_ENGINEERING_CHANGES.CHANGE_ORDER_TYPE_ID
ENG_ENGINEERING_CHANGES		HR_ALL_ORGANIZATION_UNITS	ENG_ENGINEERING_CHANGES.RESPONSIBLE_ORGANIZATION_ID
ENG_ENGINEERING_CHANGES		MTL_PARAMETERS	ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS		ENG_ENGINEERING_CHANGES	BOM_BILL_OF_MATERIALS.PENDING_FROM_ECN BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_STRUCTURES_B		ENG_ENGINEERING_CHANGES	BOM_STRUCTURES_B.PENDING_FROM_ECN BOM_STRUCTURES_B.ORGANIZATION_ID
ENG_CHANGE_ORDER_REVISIONS		ENG_ENGINEERING_CHANGES	ENG_CHANGE_ORDER_REVISIONS.CHANGE_NOTICE ENG_CHANGE_ORDER_REVISIONS.ORGANIZATION_ID
ENG_REVISED_ITEMS		ENG_ENGINEERING_CHANGES	ENG_REVISED_ITEMS.CHANGE_NOTICE ENG_REVISED_ITEMS.ORGANIZATION_ID
MRP_PENDING_ENG_CHANGES		ENG_ENGINEERING_CHANGES	MRP_PENDING_ENG_CHANGES.CHANGE_NOTICE MRP_PENDING_ENG_CHANGES.ORGANIZATION_ID
MTL_ITEM_REVISIONS_B		ENG_ENGINEERING_CHANGES	MTL_ITEM_REVISIONS_B.CHANGE_NOTICE MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
MTL_RTG_ITEM_REVISIONS		ENG_ENGINEERING_CHANGES	MTL_RTG_ITEM_REVISIONS.CHANGE_NOTICE MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B		ENG_ENGINEERING_CHANGES	MTL_SYSTEM_ITEMS_B.ENGINEERING_ECN_CODE MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID