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: MTL_PARAMETERS

Product:	INV - Inventory
Description:	Inventory control options and defaults
Implementation/DBA Data:	INV.MTL_PARAMETERS

Primary Key: MTL_PARAMETERS_PK

ORGANIZATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.AP_ACCRUAL_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INTRANSIT_INV_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.RESOURCE_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.MATERIAL_OVERHEAD_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.AVERAGE_COST_VAR_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.MATL_OVHD_ABSORPTION_ACCT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.OVERHEAD_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.SALES_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.MATERIAL_ACCOUNT
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.COST_ORGANIZATION_ID
MTL_PARAMETERS	MTL_SECONDARY_INVENTORIES	MTL_PARAMETERS.SOURCE_SUBINVENTORY MTL_PARAMETERS.SOURCE_ORGANIZATION_ID
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.MASTER_ORGANIZATION_ID
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.OUTSIDE_PROCESSING_ACCOUNT
MTL_PARAMETERS	MTL_PICKING_RULES	MTL_PARAMETERS.DEFAULT_PICKING_RULE_ID
MTL_PARAMETERS	MTL_ATP_RULES	MTL_PARAMETERS.DEFAULT_ATP_RULE_ID
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INVOICE_PRICE_VAR_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.EXPENSE_ACCOUNT
MTL_PARAMETERS	BOM_CALENDARS	MTL_PARAMETERS.CALENDAR_CODE
MTL_PARAMETERS	BOM_EXCEPTION_SETS	MTL_PARAMETERS.CALENDAR_EXCEPTION_SET_ID
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.SOURCE_ORGANIZATION_ID
MTL_PARAMETERS	BOM_RESOURCES	MTL_PARAMETERS.DEFAULT_MATERIAL_COST_ID
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.COST_OF_SALES_ACCOUNT
MTL_PARAMETERS	HR_ALL_ORGANIZATION_UNITS	MTL_PARAMETERS.ORGANIZATION_ID
MTL_PARAMETERS	CST_COST_GROUPS	MTL_PARAMETERS.DEFAULT_COST_GROUP_ID
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.DEFERRED_COGS_ACCOUNT
MTL_PARAMETERS	WMS_CROSSDOCK_CRITERIA_B	MTL_PARAMETERS.DEFAULT_CROSSDOCK_CRITERIA_ID
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.PURCHASE_PRICE_VAR_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.ENCUMBRANCE_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INTERORG_TRANSFER_CR_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INTERORG_PAYABLES_ACCOUNT
MTL_PARAMETERS	GL_CODE_COMBINATIONS	MTL_PARAMETERS.INTERORG_PRICE_VAR_ACCOUNT
BOM_ALTERNATE_DESIGNATORS	MTL_PARAMETERS	BOM_ALTERNATE_DESIGNATORS.ORGANIZATION_ID
BOM_DEPARTMENTS	MTL_PARAMETERS	BOM_DEPARTMENTS.ORGANIZATION_ID
BOM_DEPARTMENT_CLASSES	MTL_PARAMETERS	BOM_DEPARTMENT_CLASSES.ORGANIZATION_ID
BOM_EAM_DEPT_APPROVERS	MTL_PARAMETERS	BOM_EAM_DEPT_APPROVERS.ORGANIZATION_ID
BOM_RESOURCES	MTL_PARAMETERS	BOM_RESOURCES.ORGANIZATION_ID
BOM_STANDARD_OPERATIONS	MTL_PARAMETERS	BOM_STANDARD_OPERATIONS.ORGANIZATION_ID
CSP_REQUIREMENT_HEADERS	MTL_PARAMETERS	CSP_REQUIREMENT_HEADERS.DESTINATION_ORGANIZATION_ID
CSP_REQUIREMENT_LINES	MTL_PARAMETERS	CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID
CST_AE_HEADERS	MTL_PARAMETERS	CST_AE_HEADERS.ORGANIZATION_ID
CST_COST_GROUP_ASSIGNMENTS	MTL_PARAMETERS	CST_COST_GROUP_ASSIGNMENTS.ORGANIZATION_ID
CST_MARGIN_BUILD	MTL_PARAMETERS	CST_MARGIN_BUILD.ORGANIZATION_ID
CST_PAC_EAM_WO_EST_STATUSES	MTL_PARAMETERS	CST_PAC_EAM_WO_EST_STATUSES.ORGANIZATION_ID
EAM_ASSET_STATUS_HISTORY	MTL_PARAMETERS	EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID
ENG_ENGINEERING_CHANGES	MTL_PARAMETERS	ENG_ENGINEERING_CHANGES.ORGANIZATION_ID
FLM_FILTER_CRITERIA	MTL_PARAMETERS	FLM_FILTER_CRITERIA.ORGANIZATION_ID
FLM_KANBAN_SUMMARY	MTL_PARAMETERS	FLM_KANBAN_SUMMARY.ORGANIZATION_ID
FLM_MMM_PLANS	MTL_PARAMETERS	FLM_MMM_PLANS.ORGANIZATION_ID
FLM_SEQ_LINE_RULES	MTL_PARAMETERS	FLM_SEQ_LINE_RULES.ORGANIZATION_ID
FLM_SEQ_RULES	MTL_PARAMETERS	FLM_SEQ_RULES.ORGANIZATION_ID
FLM_SEQ_RULE_CONSTRAINTS	MTL_PARAMETERS	FLM_SEQ_RULE_CONSTRAINTS.ORGANIZATION_ID
FLM_SEQ_TASKS	MTL_PARAMETERS	FLM_SEQ_TASKS.ORGANIZATION_ID
FLM_SEQ_TASK_CONSTRAINTS	MTL_PARAMETERS	FLM_SEQ_TASK_CONSTRAINTS.ORGANIZATION_ID
FLM_SEQ_TASK_DEMANDS	MTL_PARAMETERS	FLM_SEQ_TASK_DEMANDS.ORGANIZATION_ID
FLM_SEQ_TASK_EXCEPTIONS	MTL_PARAMETERS	FLM_SEQ_TASK_EXCEPTIONS.ORGANIZATION_ID
FLM_SEQ_TASK_LINES	MTL_PARAMETERS	FLM_SEQ_TASK_LINES.ORGANIZATION_ID
JMF_SHIKYU_REPLENISHMENTS	MTL_PARAMETERS	JMF_SHIKYU_REPLENISHMENTS.OEM_ORGANIZATION_ID
JMF_SHIKYU_REPLENISHMENTS	MTL_PARAMETERS	JMF_SHIKYU_REPLENISHMENTS.TP_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS	MTL_PARAMETERS	JMF_SUBCONTRACT_ORDERS.OEM_ORGANIZATION_ID
JMF_SUBCONTRACT_ORDERS	MTL_PARAMETERS	JMF_SUBCONTRACT_ORDERS.TP_ORGANIZATION_ID
MRP_ITEM_SUPPLIERS	MTL_PARAMETERS	MRP_ITEM_SUPPLIERS.ORGANIZATION_ID
MRP_PARAMETERS	MTL_PARAMETERS	MRP_PARAMETERS.ORGANIZATION_ID
MRP_SR_ASSIGNMENTS	MTL_PARAMETERS	MRP_SR_ASSIGNMENTS.ORGANIZATION_ID
MRP_SR_RECEIPT_ORG	MTL_PARAMETERS	MRP_SR_RECEIPT_ORG.RECEIPT_ORGANIZATION_ID
MRP_SR_SOURCE_ORG	MTL_PARAMETERS	MRP_SR_SOURCE_ORG.SOURCE_ORGANIZATION_ID
MRP_SUPPLIER_CAPACITIES	MTL_PARAMETERS	MRP_SUPPLIER_CAPACITIES.ORGANIZATION_ID
MRP_SUPPLIER_FLEX_FENCES	MTL_PARAMETERS	MRP_SUPPLIER_FLEX_FENCES.ORGANIZATION_ID
MTL_ABC_ASSIGNMENT_GROUPS	MTL_PARAMETERS	MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID
MTL_ABC_CLASSES	MTL_PARAMETERS	MTL_ABC_CLASSES.ORGANIZATION_ID
MTL_ABC_COMPILE_HEADERS	MTL_PARAMETERS	MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID
MTL_CATEGORY_ACCOUNTS	MTL_PARAMETERS	MTL_CATEGORY_ACCOUNTS.ORGANIZATION_ID
MTL_CC_ENTRIES_INTERFACE	MTL_PARAMETERS	MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID
MTL_CI_INTERFACE	MTL_PARAMETERS	MTL_CI_INTERFACE.CONTAINER_ITEM_ORG_ID
MTL_CI_XREFS_INTERFACE	MTL_PARAMETERS	MTL_CI_XREFS_INTERFACE.MASTER_ORGANIZATION_ID
MTL_CROSS_REFERENCES	MTL_PARAMETERS	MTL_CROSS_REFERENCES.ORGANIZATION_ID
MTL_CUSTOMER_ITEM_XREFS	MTL_PARAMETERS	MTL_CUSTOMER_ITEM_XREFS.MASTER_ORGANIZATION_ID
MTL_CUSTOMER_ITEMS	MTL_PARAMETERS	MTL_CUSTOMER_ITEMS.CONTAINER_ITEM_ORG_ID
MTL_CYCLE_COUNT_CLASSES	MTL_PARAMETERS	MTL_CYCLE_COUNT_CLASSES.ORGANIZATION_ID
MTL_CYCLE_COUNT_ENTRIES	MTL_PARAMETERS	MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID
MTL_CYCLE_COUNT_HEADERS	MTL_PARAMETERS	MTL_CYCLE_COUNT_HEADERS.ORGANIZATION_ID
MTL_EAM_ASSET_ACTIVITIES	MTL_PARAMETERS	MTL_EAM_ASSET_ACTIVITIES.ORGANIZATION_ID
MTL_EAM_ASSET_ATTR_GROUPS	MTL_PARAMETERS	MTL_EAM_ASSET_ATTR_GROUPS.ORGANIZATION_ID
MTL_EAM_ASSET_ATTR_VALUES	MTL_PARAMETERS	MTL_EAM_ASSET_ATTR_VALUES.ORGANIZATION_ID
MTL_EAM_LOCATIONS	MTL_PARAMETERS	MTL_EAM_LOCATIONS.ORGANIZATION_ID
MTL_EAM_NETWORK_ASSETS	MTL_PARAMETERS	MTL_EAM_NETWORK_ASSETS.ORGANIZATION_ID
MTL_GENERIC_DISPOSITIONS	MTL_PARAMETERS	MTL_GENERIC_DISPOSITIONS.ORGANIZATION_ID
MTL_INTERORG_PARAMETERS	MTL_PARAMETERS	MTL_INTERORG_PARAMETERS.FROM_ORGANIZATION_ID
MTL_INTERORG_PARAMETERS	MTL_PARAMETERS	MTL_INTERORG_PARAMETERS.TO_ORGANIZATION_ID
MTL_INTERORG_SHIP_METHODS	MTL_PARAMETERS	MTL_INTERORG_SHIP_METHODS.FROM_ORGANIZATION_ID
MTL_INTERORG_SHIP_METHODS	MTL_PARAMETERS	MTL_INTERORG_SHIP_METHODS.TO_ORGANIZATION_ID
MTL_ITEM_CATEGORIES	MTL_PARAMETERS	MTL_ITEM_CATEGORIES.ORGANIZATION_ID
MTL_ITEM_LOCATIONS	MTL_PARAMETERS	MTL_ITEM_LOCATIONS.ORGANIZATION_ID
MTL_ITEM_REVISIONS_B	MTL_PARAMETERS	MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
MTL_ITEM_SUB_INVENTORIES	MTL_PARAMETERS	MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID
MTL_ITEM_TEMPLATES	MTL_PARAMETERS	MTL_ITEM_TEMPLATES.CONTEXT_ORGANIZATION_ID
MTL_KANBAN_CARDS	MTL_PARAMETERS	MTL_KANBAN_CARDS.ORGANIZATION_ID
MTL_KANBAN_CARD_ACTIVITY	MTL_PARAMETERS	MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID
MTL_KANBAN_PULL_SEQUENCES	MTL_PARAMETERS	MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID
MTL_LOT_NUMBERS	MTL_PARAMETERS	MTL_LOT_NUMBERS.ORGANIZATION_ID
MTL_MATERIAL_TXN_ALLOCATIONS	MTL_PARAMETERS	MTL_MATERIAL_TXN_ALLOCATIONS.ORGANIZATION_ID
MTL_MFG_PART_NUMBERS	MTL_PARAMETERS	MTL_MFG_PART_NUMBERS.ORGANIZATION_ID
MTL_ORG_REPORT_TEMP	MTL_PARAMETERS	MTL_ORG_REPORT_TEMP.ORGANIZATION_ID
WMS_LABEL_REQUESTS	MTL_PARAMETERS	WMS_LABEL_REQUESTS.ORGANIZATION_ID
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.COST_ORGANIZATION_ID
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.MASTER_ORGANIZATION_ID
MTL_PARAMETERS	MTL_PARAMETERS	MTL_PARAMETERS.SOURCE_ORGANIZATION_ID
MTL_PENDING_ITEM_STATUS	MTL_PARAMETERS	MTL_PENDING_ITEM_STATUS.ORGANIZATION_ID
MTL_PHYSICAL_INVENTORIES	MTL_PARAMETERS	MTL_PHYSICAL_INVENTORIES.ORGANIZATION_ID
MTL_PHYSICAL_SUBINVENTORIES	MTL_PARAMETERS	MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID
MTL_PLANNERS	MTL_PARAMETERS	MTL_PLANNERS.ORGANIZATION_ID
MTL_PURGE_HEADER	MTL_PARAMETERS	MTL_PURGE_HEADER.ORGANIZATION_ID
MTL_RELATED_ITEMS	MTL_PARAMETERS	MTL_RELATED_ITEMS.ORGANIZATION_ID
MTL_REPLENISH_HEADERS	MTL_PARAMETERS	MTL_REPLENISH_HEADERS.ORGANIZATION_ID
MTL_REPLENISH_LINES	MTL_PARAMETERS	MTL_REPLENISH_LINES.ORGANIZATION_ID
MTL_REPLENISH_HEADERS_INT	MTL_PARAMETERS	MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID
MTL_REPLENISH_LINES	MTL_PARAMETERS	MTL_REPLENISH_LINES.SOURCE_ORGANIZATION_ID
MTL_REPLENISH_LINES_INT	MTL_PARAMETERS	MTL_REPLENISH_LINES_INT.ORGANIZATION_ID
MTL_RESERVATIONS	MTL_PARAMETERS	MTL_RESERVATIONS.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_PARAMETERS	MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID
MTL_RESERVATIONS_INTERFACE	MTL_PARAMETERS	MTL_RESERVATIONS_INTERFACE.TO_ORGANIZATION_ID
MTL_RTG_ITEM_REVISIONS	MTL_PARAMETERS	MTL_RTG_ITEM_REVISIONS.ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES	MTL_PARAMETERS	MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID
MTL_SECONDARY_INVENTORIES	MTL_PARAMETERS	MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID
MTL_SERIAL_NUMBERS	MTL_PARAMETERS	MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID
MTL_SHORT_CHK_PARAM	MTL_PARAMETERS	MTL_SHORT_CHK_PARAM.ORGANIZATION_ID
MTL_SHORT_CHK_STATEMENTS	MTL_PARAMETERS	MTL_SHORT_CHK_STATEMENTS.ORGANIZATION_ID
MTL_SHORT_CHK_TEMP	MTL_PARAMETERS	MTL_SHORT_CHK_TEMP.ORGANIZATION_ID
MTL_SUPPLY	MTL_PARAMETERS	MTL_SUPPLY.TO_ORGANIZATION_ID
MTL_SUPPLY	MTL_PARAMETERS	MTL_SUPPLY.INTRANSIT_OWNING_ORG_ID
MTL_SUPPLY	MTL_PARAMETERS	MTL_SUPPLY.MRP_TO_ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B	MTL_PARAMETERS	MTL_SYSTEM_ITEMS_B.DEFAULT_SHIPPING_ORG
MTL_SYSTEM_ITEMS_B	MTL_PARAMETERS	MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B	MTL_PARAMETERS	MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID
MTL_TXN_REQUEST_HEADERS	MTL_PARAMETERS	MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID
MTL_TXN_REQUEST_LINES	MTL_PARAMETERS	MTL_TXN_REQUEST_LINES.TO_ORGANIZATION_ID
MTL_TXN_REQUEST_LINES	MTL_PARAMETERS	MTL_TXN_REQUEST_LINES.ORGANIZATION_ID
MTL_USER_SUPPLY	MTL_PARAMETERS	MTL_USER_SUPPLY.ORGANIZATION_ID
ORG_ACCT_PERIODS	MTL_PARAMETERS	ORG_ACCT_PERIODS.ORGANIZATION_ID
ORG_FREIGHT_TL	MTL_PARAMETERS	ORG_FREIGHT_TL.ORGANIZATION_ID
ORG_GL_BATCHES	MTL_PARAMETERS	ORG_GL_BATCHES.ORGANIZATION_ID
PJM_ORG_PARAMETERS	MTL_PARAMETERS	PJM_ORG_PARAMETERS.ORGANIZATION_ID
PJM_UNIT_NUMBERS	MTL_PARAMETERS	PJM_UNIT_NUMBERS.MASTER_ORGANIZATION_ID
RCV_ACCOUNTING_EVENTS	MTL_PARAMETERS	RCV_ACCOUNTING_EVENTS.ORGANIZATION_ID
RCV_ACCOUNTING_EVENTS	MTL_PARAMETERS	RCV_ACCOUNTING_EVENTS.TRANSFER_ORGANIZATION_ID
WIP_EAM_PARAMETERS	MTL_PARAMETERS	WIP_EAM_PARAMETERS.ORGANIZATION_ID
WIP_PAC_PERIOD_BALANCES	MTL_PARAMETERS	WIP_PAC_PERIOD_BALANCES.ORGANIZATION_ID
WMS_BUS_EVENT_DEVICES	MTL_PARAMETERS	WMS_BUS_EVENT_DEVICES.ORGANIZATION_ID
WMS_DEPARTMENT_SUBINVENTORIES	MTL_PARAMETERS	WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID
WMS_DEVICES_B	MTL_PARAMETERS	WMS_DEVICES_B.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_ARCH	MTL_PARAMETERS	WMS_DISPATCHED_TASKS_ARCH.ORGANIZATION_ID
WMS_DISPATCHED_TASKS	MTL_PARAMETERS	WMS_DISPATCHED_TASKS.ORGANIZATION_ID
WMS_DISPATCHED_TASKS_HISTORY	MTL_PARAMETERS	WMS_DISPATCHED_TASKS_HISTORY.ORGANIZATION_ID
WMS_EXCEPTIONS	MTL_PARAMETERS	WMS_EXCEPTIONS.ORGANIZATION_ID
WMS_LICENSE_PLATE_NUMBERS	MTL_PARAMETERS	WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID
WMS_LOCATIONS_LOCATORS	MTL_PARAMETERS	WMS_LOCATIONS_LOCATORS.ORGANIZATION_ID
WMS_LPN_INTERFACE	MTL_PARAMETERS	WMS_LPN_INTERFACE.ORGANIZATION_ID
WMS_ORG_HIERARCHY_OBJS	MTL_PARAMETERS	WMS_ORG_HIERARCHY_OBJS.ORGANIZATION_ID
WMS_RULES_B	MTL_PARAMETERS	WMS_RULES_B.ORGANIZATION_ID
WMS_SKIP_TASK_EXCEPTIONS	MTL_PARAMETERS	WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID
WMS_STRATEGIES_B	MTL_PARAMETERS	WMS_STRATEGIES_B.ORGANIZATION_ID
WMS_STRATEGY_ASSIGNMENTS	MTL_PARAMETERS	WMS_STRATEGY_ASSIGNMENTS.ORGANIZATION_ID
WSM_PARAMETERS	MTL_PARAMETERS	WSM_PARAMETERS.ORGANIZATION_ID