MTH — Oracle Manufacturing Operations Center
230 documented tables · 0 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
MTH_DIM_LEVEL_LOOKUP_ERR |
Error table for MTH_DIM_LEVEL_LOOKUP | standalone |
MTH_PRODUCTION_SEGMENTS_ERR |
Error Table for MTH_PRODUCTION_SEGMENTS_F | standalone |
MTH_PLANTS_D |
This table stores information for the plant dimension. It provides information like Plant name, Currency code, | standalone |
MTH_PROD_MTL_PRODUCED_F |
This table stores the work order item information. It holds information about the quantity of each item to be | standalone |
MTH_PERSONNEL_ERR |
Error table for MTH_PERSONNEL_D | standalone |
MTH_WORKDAY_SHIFTS_D |
This table stores the workday shifts definition for the time dimension. It provides information like Shift dat | standalone |
MTH_EQUIP_ENTITIES_MST |
This table stores the entity definitions for equipment dimension. It holds information on Entity name and Ent | standalone |
MTH_ITEM_HIERARCHY_ERR |
Error table for MTH_ITEM_HIERARCHY | standalone |
MTH_QUARTER_D |
This table stores information on quarter level definition for time dimension hierarchies. | standalone |
MTH_EQUIPMENT_DENORM_D |
This table stores denormalized data for equipment hierarchy. | standalone |
MTH_GREGORIAN_CALENDAR |
This table stores gregorian calendar | standalone |
MTH_USER_DIM_ENTITIES_ERR |
Error table for MTH_USER_DIM_ENTITIES | standalone |
MTH_445_PERIOD_CALENDAR |
This table stores 445/544 period calendar | standalone |
MTH_RESOURCE_REQUIREMENTS_F |
This table stores information on planned resource usages at each operation level on the work order | standalone |
MTH_PERSONNEL_D |
This table stores information about personnel. It holds information like First name, Last name, Resource and O | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.