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_RESOURCES

Product:	BOM - Bills of Material
Description:	Resources, overheads, material cost codes, and material overheads
Implementation/DBA Data:	BOM.BOM_RESOURCES

Primary Key: BOM_RESOURCES_PK

RESOURCE_ID

Primary Key: BOM_RESOURCES_UK1

RESOURCE_CODE
ORGANIZATION_ID
COST_CODE_TYPE

Primary Key: BOM_RESOURCE_UK1

RESOURCE_CODE
ORGANIZATION_ID
COST_CODE_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
BOM_RESOURCES	MTL_PARAMETERS	BOM_RESOURCES.ORGANIZATION_ID
BOM_RESOURCES	CST_COST_ELEMENTS	BOM_RESOURCES.COST_ELEMENT_ID
BOM_RESOURCES	CST_ACTIVITIES	BOM_RESOURCES.DEFAULT_ACTIVITY_ID
BOM_RESOURCES	GL_CODE_COMBINATIONS	BOM_RESOURCES.ABSORPTION_ACCOUNT
BOM_RESOURCES	GL_CODE_COMBINATIONS	BOM_RESOURCES.RATE_VARIANCE_ACCOUNT
AHL_OPERATION_RESOURCES	BOM_RESOURCES	AHL_OPERATION_RESOURCES.RESOURCE_ID
AHL_RESOURCE_MAPPINGS	BOM_RESOURCES	AHL_RESOURCE_MAPPINGS.BOM_RESOURCE_ID
AHL_WO_OPERATIONS_TXNS	BOM_RESOURCES	AHL_WO_OPERATIONS_TXNS.BOM_RESOURCE_ID
BOM_DEPARTMENT_RESOURCES	BOM_RESOURCES	BOM_DEPARTMENT_RESOURCES.RESOURCE_ID
BOM_RESOURCE_SETUPS	BOM_RESOURCES	BOM_RESOURCE_SETUPS.RESOURCE_ID
BOM_STD_SUB_OP_RESOURCES	BOM_RESOURCES	BOM_STD_SUB_OP_RESOURCES.RESOURCE_ID
CSD_REPAIR_ESTIMATE_LINES	BOM_RESOURCES	CSD_REPAIR_ESTIMATE_LINES.RESOURCE_ID
CST_AE_LINES	BOM_RESOURCES	CST_AE_LINES.RESOURCE_ID
CST_DEPARTMENT_OVERHEADS	BOM_RESOURCES	CST_DEPARTMENT_OVERHEADS.OVERHEAD_ID
CST_ITEM_COST_DETAILS	BOM_RESOURCES	CST_ITEM_COST_DETAILS.RESOURCE_ID
CST_ITEM_COST_DETAILS	BOM_RESOURCES	CST_ITEM_COST_DETAILS.BASIS_RESOURCE_ID
CST_ITEM_CST_DTLS_INTERFACE	BOM_RESOURCES	CST_ITEM_CST_DTLS_INTERFACE.RESOURCE_ID
CST_ITEM_CST_DTLS_INTERFACE	BOM_RESOURCES	CST_ITEM_CST_DTLS_INTERFACE.BASIS_RESOURCE_ID
CST_ITEM_OVERHEAD_DEFAULTS	BOM_RESOURCES	CST_ITEM_OVERHEAD_DEFAULTS.MATERIAL_OVERHEAD_ID
CST_RESOURCE_COSTS	BOM_RESOURCES	CST_RESOURCE_COSTS.RESOURCE_ID
CST_RESOURCE_OVERHEADS	BOM_RESOURCES	CST_RESOURCE_OVERHEADS.RESOURCE_ID
CST_RESOURCE_OVERHEADS	BOM_RESOURCES	CST_RESOURCE_OVERHEADS.OVERHEAD_ID
CST_STD_COST_ADJ_DEBUG	BOM_RESOURCES	CST_STD_COST_ADJ_DEBUG.RESOURCE_ID
CST_STD_COST_ADJ_TEMP	BOM_RESOURCES	CST_STD_COST_ADJ_TEMP.RESOURCE_ID
CST_STD_COST_ADJ_VALUES	BOM_RESOURCES	CST_STD_COST_ADJ_VALUES.RESOURCE_ID
FLM_MMM_OP_RESOURCES	BOM_RESOURCES	FLM_MMM_OP_RESOURCES.RESOURCE_ID
MRP_PLANNED_RESOURCE_REQS	BOM_RESOURCES	MRP_PLANNED_RESOURCE_REQS.RESOURCE_ID
MTL_ACTUAL_COST_SUBELEMENT	BOM_RESOURCES	MTL_ACTUAL_COST_SUBELEMENT.RESOURCE_ID
MTL_PAC_COST_SUBELEMENTS	BOM_RESOURCES	MTL_PAC_COST_SUBELEMENTS.RESOURCE_ID
MTL_PARAMETERS	BOM_RESOURCES	MTL_PARAMETERS.DEFAULT_MATERIAL_COST_ID
MTL_TRANSACTION_ACCOUNTS	BOM_RESOURCES	MTL_TRANSACTION_ACCOUNTS.RESOURCE_ID
PA_EXPENDITURE_ITEMS_AR	BOM_RESOURCES	PA_EXPENDITURE_ITEMS_AR.WIP_RESOURCE_ID
PA_EXPENDITURE_ITEMS_ALL	BOM_RESOURCES	PA_EXPENDITURE_ITEMS_ALL.WIP_RESOURCE_ID
PA_RESOURCE_ASSIGNMENTS	BOM_RESOURCES	PA_RESOURCE_ASSIGNMENTS.BOM_RESOURCE_ID
PA_RESOURCE_LIST_MEMBERS	BOM_RESOURCES	PA_RESOURCE_LIST_MEMBERS.BOM_RESOURCE_ID
PA_TRANSACTION_INTERFACE_ALL	BOM_RESOURCES	PA_TRANSACTION_INTERFACE_ALL.WIP_RESOURCE_ID
PA_TXN_INTERFACE_AUDIT_AR	BOM_RESOURCES	PA_TXN_INTERFACE_AUDIT_AR.WIP_RESOURCE_ID
PA_TXN_INTERFACE_AUDIT_ALL	BOM_RESOURCES	PA_TXN_INTERFACE_AUDIT_ALL.WIP_RESOURCE_ID
PO_DISTRIBUTIONS_ARCHIVE_ALL	BOM_RESOURCES	PO_DISTRIBUTIONS_ARCHIVE_ALL.BOM_RESOURCE_ID
PO_DISTRIBUTIONS_ALL	BOM_RESOURCES	PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID
PO_REQUISITION_LINES_ALL	BOM_RESOURCES	PO_REQUISITION_LINES_ALL.BOM_RESOURCE_ID
QA_RESULTS	BOM_RESOURCES	QA_RESULTS.RESOURCE_ID
RCV_TRANSACTIONS	BOM_RESOURCES	RCV_TRANSACTIONS.BOM_RESOURCE_ID
RCV_TRANSACTIONS_INTERFACE	BOM_RESOURCES	RCV_TRANSACTIONS_INTERFACE.BOM_RESOURCE_ID
WIP_COST_TXN_INTERFACE	BOM_RESOURCES	WIP_COST_TXN_INTERFACE.RESOURCE_ID
WIP_OPERATION_OVERHEADS	BOM_RESOURCES	WIP_OPERATION_OVERHEADS.OVERHEAD_ID
WIP_OPERATION_RESOURCES	BOM_RESOURCES	WIP_OPERATION_RESOURCES.RESOURCE_ID
WIP_PAC_ACTUAL_COST_DETAILS	BOM_RESOURCES	WIP_PAC_ACTUAL_COST_DETAILS.RESOURCE_ID
WIP_SUB_OPERATION_RESOURCES	BOM_RESOURCES	WIP_SUB_OPERATION_RESOURCES.RESOURCE_ID
WIP_TRANSACTIONS	BOM_RESOURCES	WIP_TRANSACTIONS.RESOURCE_ID
WIP_TRANSACTION_ACCOUNTS	BOM_RESOURCES	WIP_TRANSACTION_ACCOUNTS.RESOURCE_ID
WMS_DISPATCHED_TASKS_ARCH	BOM_RESOURCES	WMS_DISPATCHED_TASKS_ARCH.PERSON_RESOURCE_ID
WMS_DISPATCHED_TASKS_ARCH	BOM_RESOURCES	WMS_DISPATCHED_TASKS_ARCH.MACHINE_RESOURCE_ID
WMS_DISPATCHED_TASKS	BOM_RESOURCES	WMS_DISPATCHED_TASKS.PERSON_RESOURCE_ID
WMS_DISPATCHED_TASKS	BOM_RESOURCES	WMS_DISPATCHED_TASKS.MACHINE_RESOURCE_ID
WMS_DISPATCHED_TASKS_HISTORY	BOM_RESOURCES	WMS_DISPATCHED_TASKS_HISTORY.PERSON_RESOURCE_ID
WMS_DISPATCHED_TASKS_HISTORY	BOM_RESOURCES	WMS_DISPATCHED_TASKS_HISTORY.MACHINE_RESOURCE_ID