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_COMPONENTS_B

Product:	BOM - Bills of Material
Description:	Bill of material components
Implementation/DBA Data:	BOM.BOM_COMPONENTS_B

Primary Key: BOM_COMPONENTS_B_PK

COMPONENT_SEQUENCE_ID

Primary Key: BOM_COMPONENTS_B_UK1

BILL_SEQUENCE_ID
COMPONENT_ITEM_ID
EFFECTIVITY_DATE
OPERATION_SEQ_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_COMPONENTS_B	ENG_REVISED_ITEMS	BOM_COMPONENTS_B.REVISED_ITEM_SEQUENCE_ID
BOM_COMPONENTS_B	BOM_STRUCTURES_B	BOM_COMPONENTS_B.BILL_SEQUENCE_ID
BOM_COMPONENTS_B	BOM_COMPONENTS_B	BOM_COMPONENTS_B.OLD_COMPONENT_SEQUENCE_ID
BOM_COMPARISON_TEMP	BOM_COMPONENTS_B	BOM_COMPARISON_TEMP.COMPONENT_SEQUENCE_ID1
BOM_COMPARISON_TEMP	BOM_COMPONENTS_B	BOM_COMPARISON_TEMP.COMPONENT_SEQUENCE_ID2
BOM_COMPONENTS_B	BOM_COMPONENTS_B	BOM_COMPONENTS_B.OLD_COMPONENT_SEQUENCE_ID
BOM_COMPONENT_OPERATIONS	BOM_COMPONENTS_B	BOM_COMPONENT_OPERATIONS.COMPONENT_SEQUENCE_ID
BOM_DELETE_SUB_ENTITIES	BOM_COMPONENTS_B	BOM_DELETE_SUB_ENTITIES.COMPONENT_SEQUENCE_ID
BOM_EXPLOSION_TEMP	BOM_COMPONENTS_B	BOM_EXPLOSION_TEMP.COMPONENT_SEQUENCE_ID
BOM_IMPLOSION_TEMP	BOM_COMPONENTS_B	BOM_IMPLOSION_TEMP.COMPONENT_SEQUENCE_ID
BOM_REFERENCE_DESIGNATORS	BOM_COMPONENTS_B	BOM_REFERENCE_DESIGNATORS.COMPONENT_SEQUENCE_ID
BOM_SMALL_EXPL_TEMP	BOM_COMPONENTS_B	BOM_SMALL_EXPL_TEMP.COMPONENT_SEQUENCE_ID
BOM_SUBSTITUTE_COMPONENTS	BOM_COMPONENTS_B	BOM_SUBSTITUTE_COMPONENTS.COMPONENT_SEQUENCE_ID
MTL_DEMAND	BOM_COMPONENTS_B	MTL_DEMAND.COMPONENT_SEQUENCE_ID
OE_ORDER_LINES_ALL	BOM_COMPONENTS_B	OE_ORDER_LINES_ALL.COMPONENT_SEQUENCE_ID
WIP_REQUIREMENT_OPERATIONS	BOM_COMPONENTS_B	WIP_REQUIREMENT_OPERATIONS.COMPONENT_SEQUENCE_ID