eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: BOM_BILL_OF_MATERIALS

Product:	BOM - Bills of Material
Description:	Bills of material
Implementation/DBA Data:	Not implemented in this database

Primary Key: BOM_BILL_OF_MATERIALS_PK

BILL_SEQUENCE_ID

Primary Key: BOM_BILL_OF_MATERIALS_UK1

ASSEMBLY_ITEM_ID
ORGANIZATION_ID
ALTERNATE_BOM_DESIGNATOR

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_BILL_OF_MATERIALS	MTL_SYSTEM_ITEMS_B	BOM_BILL_OF_MATERIALS.ASSEMBLY_ITEM_ID BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS	ENG_ENGINEERING_CHANGES	BOM_BILL_OF_MATERIALS.PENDING_FROM_ECN BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS	BOM_ALTERNATE_DESIGNATORS	BOM_BILL_OF_MATERIALS.ALTERNATE_BOM_DESIGNATOR BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS	BOM_BILL_OF_MATERIALS	BOM_BILL_OF_MATERIALS.COMMON_BILL_SEQUENCE_ID
BOM_BILL_OF_MATERIALS	MTL_SYSTEM_ITEMS_B	BOM_BILL_OF_MATERIALS.COMMON_ASSEMBLY_ITEM_ID BOM_BILL_OF_MATERIALS.COMMON_ORGANIZATION_ID
BOM_BILL_OF_MATERIALS	HR_ALL_ORGANIZATION_UNITS	BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS	BOM_BILL_OF_MATERIALS	BOM_BILL_OF_MATERIALS.COMMON_BILL_SEQUENCE_ID
BOM_BILL_REVISIONS_B	BOM_BILL_OF_MATERIALS	BOM_BILL_REVISIONS_B.BILL_SEQUENCE_ID
BOM_INVENTORY_COMPONENTS	BOM_BILL_OF_MATERIALS	BOM_INVENTORY_COMPONENTS.BILL_SEQUENCE_ID
SO_LINES_ALL	BOM_BILL_OF_MATERIALS	SO_LINES_ALL.COMPONENT_SEQUENCE_ID
SO_LINE_DETAILS	BOM_BILL_OF_MATERIALS	SO_LINE_DETAILS.COMPONENT_SEQUENCE_ID
WSM_CO_PRODUCTS	BOM_BILL_OF_MATERIALS	WSM_CO_PRODUCTS.BILL_SEQUENCE_ID
WSM_LOT_JOB_INTERFACE	BOM_BILL_OF_MATERIALS	WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID WSM_LOT_JOB_INTERFACE.ALTERNATE_BOM_DESIGNATOR