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_DEPARTMENTS

Product:	BOM - Bills of Material
Description:	Departments
Implementation/DBA Data:	BOM.BOM_DEPARTMENTS

Primary Key: BOM_DEPARTMENTS_PK

DEPARTMENT_ID

Primary Key: BOM_DEPARTMENTS_UK1

DEPARTMENT_CODE
ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_DEPARTMENTS	MTL_PARAMETERS	BOM_DEPARTMENTS.ORGANIZATION_ID
BOM_DEPARTMENTS	HR_LOCATIONS_ALL	BOM_DEPARTMENTS.LOCATION_ID
AHL_DEPARTMENT_SHIFTS	BOM_DEPARTMENTS	AHL_DEPARTMENT_SHIFTS.DEPARTMENT_ID
AHL_UNIT_EFFECTIVITIES_B	BOM_DEPARTMENTS	AHL_UNIT_EFFECTIVITIES_B.CLEAR_STATION_DEPT_ID
AHL_VISITS_B	BOM_DEPARTMENTS	AHL_VISITS_B.DEPARTMENT_ID
AHL_VISIT_TASKS_B	BOM_DEPARTMENTS	AHL_VISIT_TASKS_B.DEPARTMENT_ID
BOM_DEPARTMENT_RESOURCES	BOM_DEPARTMENTS	BOM_DEPARTMENT_RESOURCES.DEPARTMENT_ID
BOM_OPERATION_SEQUENCES	BOM_DEPARTMENTS	BOM_OPERATION_SEQUENCES.DEPARTMENT_ID
BOM_STANDARD_OPERATIONS	BOM_DEPARTMENTS	BOM_STANDARD_OPERATIONS.DEPARTMENT_ID
CST_DEPARTMENT_OVERHEADS	BOM_DEPARTMENTS	CST_DEPARTMENT_OVERHEADS.DEPARTMENT_ID
CST_EAM_BALANCE_BY_ACCOUNTS	BOM_DEPARTMENTS	CST_EAM_BALANCE_BY_ACCOUNTS.OWNING_DEPT_ID
CST_ITEM_COST_DETAILS	BOM_DEPARTMENTS	CST_ITEM_COST_DETAILS.DEPARTMENT_ID
CST_ITEM_CST_DTLS_INTERFACE	BOM_DEPARTMENTS	CST_ITEM_CST_DTLS_INTERFACE.DEPARTMENT_ID
CST_STD_COST_ADJ_DEBUG	BOM_DEPARTMENTS	CST_STD_COST_ADJ_DEBUG.DEPARTMENT_ID
CST_STD_COST_ADJ_TEMP	BOM_DEPARTMENTS	CST_STD_COST_ADJ_TEMP.DEPARTMENT_ID
CST_STD_COST_ADJ_VALUES	BOM_DEPARTMENTS	CST_STD_COST_ADJ_VALUES.DEPARTMENT_ID
CS_INCIDENTS_ALL_B	BOM_DEPARTMENTS	CS_INCIDENTS_ALL_B.OWNING_DEPARTMENT_ID
MRP_PLANNED_RESOURCE_REQS	BOM_DEPARTMENTS	MRP_PLANNED_RESOURCE_REQS.DEPARTMENT_ID
PJM_DEFAULT_TASKS	BOM_DEPARTMENTS	PJM_DEFAULT_TASKS.DEPARTMENT_ID
QA_RESULTS	BOM_DEPARTMENTS	QA_RESULTS.DEPARTMENT_ID
WIP_COST_TXN_INTERFACE	BOM_DEPARTMENTS	WIP_COST_TXN_INTERFACE.DEPARTMENT_ID
WIP_MOVE_TRANSACTIONS	BOM_DEPARTMENTS	WIP_MOVE_TRANSACTIONS.FM_DEPARTMENT_ID
WIP_MOVE_TRANSACTIONS	BOM_DEPARTMENTS	WIP_MOVE_TRANSACTIONS.TO_DEPARTMENT_ID
WIP_OPERATIONS	BOM_DEPARTMENTS	WIP_OPERATIONS.DEPARTMENT_ID
WIP_REQUIREMENT_OPERATIONS	BOM_DEPARTMENTS	WIP_REQUIREMENT_OPERATIONS.DEPARTMENT_ID
WIP_TRANSACTIONS	BOM_DEPARTMENTS	WIP_TRANSACTIONS.DEPARTMENT_ID
WMS_DEPARTMENT_SUBINVENTORIES	BOM_DEPARTMENTS	WMS_DEPARTMENT_SUBINVENTORIES.DEPARTMENT_ID
WSM_LOT_MOVE_TXN_INTERFACE	BOM_DEPARTMENTS	WSM_LOT_MOVE_TXN_INTERFACE.FM_DEPARTMENT_ID
WSM_LOT_MOVE_TXN_INTERFACE	BOM_DEPARTMENTS	WSM_LOT_MOVE_TXN_INTERFACE.TO_DEPARTMENT_ID