Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - MTH Tables and Views

TABLE - MTH.MTH_445_PERIOD_CALENDAR
TABLE - APPS.MTH_445_PERIOD_CAL_HOUR_MV
TABLE - APPS.MTH_ALL_ENTITIES_MV
TABLE - MTH.MTH_ASSET_ERR
TABLE - MTH.MTH_ASSET_MST
TABLE - MTH.MTH_ASSET_STG
TABLE - MTH.MTH_CONTEXTUALIZATION_METHOD
TABLE - MTH.MTH_CONTEXTUALIZATION_REQ
TABLE - MTH.MTH_DAY_D
TABLE - MTH.MTH_DAY_STG
TABLE - MTH.MTH_DEPT_ENTITIES_I_STG
TABLE - MTH.MTH_DIM_HIERARCHY
TABLE - MTH.MTH_DIM_HIERARCHY_ERR
TABLE - MTH.MTH_DIM_HIERARCHY_STG
TABLE - MTH.MTH_DIM_LEVEL_LOOKUP
TABLE - MTH.MTH_DIM_LEVEL_LOOKUP_ERR
TABLE - MTH.MTH_DIM_LEVEL_LOOKUP_STG
TABLE - MTH.MTH_ENTITIES
TABLE - MTH.MTH_ENTITY_ATTRIBUTES
TABLE - MTH.MTH_ENTITY_PLANNED_USAGE
TABLE - MTH.MTH_ENTITY_PLANNED_USAGE_ERR
TABLE - APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV
TABLE - APPS.MTH_ENTITY_PLANNED_USAGE_MV
TABLE - APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV
TABLE - MTH.MTH_ENTITY_PLANNED_USAGE_STG
TABLE - MTH.MTH_ENTITY_SUSTAIN_ASPECT
TABLE - MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR
TABLE - MTH.MTH_ENTITY_SUST_EMISSIONS
TABLE - MTH.MTH_ENTITY_SUST_HR_EMISSIONS
TABLE - MTH.MTH_EQUIPMENTS_D
TABLE - MTH.MTH_EQUIPMENTS_ERR
TABLE - MTH.MTH_EQUIPMENTS_EXT_B
TABLE - MTH.MTH_EQUIPMENTS_EXT_TL
TABLE - MTH.MTH_EQUIPMENTS_STG
TABLE - MTH.MTH_EQUIPMENT_DENORM_D
TABLE - MTH.MTH_EQUIPMENT_REASON_SETUP
TABLE - MTH.MTH_EQUIPMENT_REASON_SETUP_ERR
TABLE - MTH.MTH_EQUIPMENT_REASON_SETUP_STG
TABLE - MTH.MTH_EQUIPMENT_SHIFTS_D
TABLE - MTH.MTH_EQUIPMENT_SHIFTS_ERR
TABLE - MTH.MTH_EQUIPMENT_SHIFTS_STG
TABLE - MTH.MTH_EQUIP_ENTITIES_ERR
TABLE - MTH.MTH_EQUIP_ENTITIES_MST
TABLE - MTH.MTH_EQUIP_ENTITIES_STG
TABLE - MTH.MTH_EQUIP_HIERARCHY
TABLE - MTH.MTH_EQUIP_HIERARCHY_ERR
TABLE - MTH.MTH_EQUIP_HIERARCHY_STG
TABLE - MTH.MTH_EQUIP_OUTPUT
TABLE - MTH.MTH_EQUIP_OUTPUT_ERR
TABLE - MTH.MTH_EQUIP_OUTPUT_STG
TABLE - MTH.MTH_EQUIP_OUTPUT_SUMMARY
TABLE - MTH.MTH_EQUIP_PROD_PERFORMANCE_ERR
TABLE - MTH.MTH_EQUIP_PROD_PERFORMANCE_F
TABLE - MTH.MTH_EQUIP_PROD_PERFORMANCE_STG
TABLE - MTH.MTH_EQUIP_PROD_PERF_DETAIL_F
TABLE - MTH.MTH_EQUIP_PROD_SCHEDULE_ERR
TABLE - MTH.MTH_EQUIP_PROD_SCHEDULE_F
TABLE - MTH.MTH_EQUIP_PROD_SCHEDULE_STG
TABLE - MTH.MTH_EQUIP_PROD_SUSTAIN_F
TABLE - APPS.MTH_EQUIP_SHFT_DD_MV
TABLE - MTH.MTH_EQUIP_STANDARD_RATES_ERR
TABLE - MTH.MTH_EQUIP_STANDARD_RATES_F
TABLE - MTH.MTH_EQUIP_STANDARD_RATES_STG
TABLE - MTH.MTH_EQUIP_STATUSES
TABLE - MTH.MTH_EQUIP_STATUSES_ERR
TABLE - MTH.MTH_EQUIP_STATUSES_STG
TABLE - MTH.MTH_EQUIP_STATUS_SUMMARY
TABLE - MTH.MTH_EVENTS
TABLE - MTH.MTH_EVENT_ACTIONS
TABLE - MTH.MTH_EVENT_ACTION_SETUP
TABLE - MTH.MTH_EVENT_ACTION_SETUP_ERR
TABLE - MTH.MTH_EVENT_ACTION_SETUP_STG
TABLE - MTH.MTH_EVENT_SETUP
TABLE - MTH.MTH_EXT_ATTR_ERR
TABLE - MTH.MTH_EXT_ATTR_I_STG
TABLE - MTH.MTH_EXT_ATTR_T_STG
TABLE - MTH.MTH_GREGORIAN_CALENDAR
TABLE - MTH.MTH_HOUR_D
TABLE - MTH.MTH_ITEMS_D
TABLE - MTH.MTH_ITEMS_ERR
TABLE - MTH.MTH_ITEMS_EXT_B
TABLE - MTH.MTH_ITEMS_EXT_TL
TABLE - MTH.MTH_ITEMS_I_STG
TABLE - MTH.MTH_ITEMS_STG
TABLE - MTH.MTH_ITEM_CATEGORIES_D
TABLE - MTH.MTH_ITEM_CATEGORIES_I_STG
TABLE - MTH.MTH_ITEM_CATEGORIES_STG
TABLE - MTH.MTH_ITEM_COST
TABLE - MTH.MTH_ITEM_COST_ERR
TABLE - MTH.MTH_ITEM_COST_I_STG
TABLE - MTH.MTH_ITEM_COST_STG
TABLE - MTH.MTH_ITEM_DENORM_D
TABLE - MTH.MTH_ITEM_DENORM_D_TMP
TABLE - MTH.MTH_ITEM_HIERARCHY
TABLE - MTH.MTH_ITEM_HIERARCHY_ERR
TABLE - MTH.MTH_ITEM_HIERARCHY_I_STG
TABLE - MTH.MTH_ITEM_HIERARCHY_STG
TABLE - MTH.MTH_LOOKUPS_D
TABLE - MTH.MTH_MASTER_SETUP
TABLE - MTH.MTH_METERS
TABLE - MTH.MTH_METER_ENTITIES
TABLE - MTH.MTH_METER_READINGS
TABLE - MTH.MTH_METER_READINGS_ERR
TABLE - MTH.MTH_METER_READINGS_STG
TABLE - MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR
TABLE - MTH.MTH_MTL_CONSUMED_TXN_LOT_F
TABLE - MTH.MTH_MTL_CONSUMED_TXN_LOT_STG
TABLE - MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR
TABLE - MTH.MTH_MTL_PRODUCED_TXN_LOT_F
TABLE - MTH.MTH_MTL_PRODUCED_TXN_LOT_STG
TABLE - MTH.MTH_OPEN_SALES_ORDERS_F
TABLE - MTH.MTH_ORGANIZATIONS_L
TABLE - MTH.MTH_OTHERS_D
TABLE - MTH.MTH_OTHERS_EXT_B
TABLE - MTH.MTH_OTHERS_EXT_TL
TABLE - MTH.MTH_PERIOD_D
TABLE - MTH.MTH_PERIOD_ERR
TABLE - MTH.MTH_PERIOD_STG
TABLE - MTH.MTH_PERSONNEL_D
TABLE - MTH.MTH_PERSONNEL_ERR
TABLE - MTH.MTH_PERSONNEL_STG
TABLE - MTH.MTH_PLANTS_D
TABLE - MTH.MTH_PLANTS_ERR
TABLE - MTH.MTH_PLANTS_STG
TABLE - MTH.MTH_PLANT_ATTRIBUTES
TABLE - MTH.MTH_PRODUCTION_SCHEDULES_ERR
TABLE - MTH.MTH_PRODUCTION_SCHEDULES_EXT_B
TABLE - MTH.MTH_PRODUCTION_SCHEDULES_F
TABLE - MTH.MTH_PRODUCTION_SCHEDULES_I_STG
TABLE - MTH.MTH_PRODUCTION_SCHEDULES_STG
TABLE - MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL
TABLE - MTH.MTH_PRODUCTION_SEGMENTS_ERR
TABLE - MTH.MTH_PRODUCTION_SEGMENTS_EXT_B
TABLE - MTH.MTH_PRODUCTION_SEGMENTS_EXT_TL
TABLE - MTH.MTH_PRODUCTION_SEGMENTS_F
TABLE - MTH.MTH_PRODUCTION_SEGMENTS_STG
TABLE - MTH.MTH_PROD_MTL_CONSUMED_ERR
TABLE - MTH.MTH_PROD_MTL_CONSUMED_F
TABLE - MTH.MTH_PROD_MTL_CONSUMED_STG
TABLE - MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR
TABLE - MTH.MTH_PROD_MTL_CONSUMED_TXN_F
TABLE - MTH.MTH_PROD_MTL_CONSUMED_TXN_STG
TABLE - MTH.MTH_PROD_MTL_PRODUCED_ERR
TABLE - MTH.MTH_PROD_MTL_PRODUCED_F
TABLE - MTH.MTH_PROD_MTL_PRODUCED_I_STG
TABLE - MTH.MTH_PROD_MTL_PRODUCED_STG
TABLE - MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR
TABLE - MTH.MTH_PROD_MTL_PRODUCED_TXN_F
TABLE - MTH.MTH_PROD_MTL_PRODUCED_TXN_STG
TABLE - MTH.MTH_PROD_SEGMENTS_TXN_ERR
TABLE - MTH.MTH_PROD_SEGMENTS_TXN_F
TABLE - MTH.MTH_PROD_SEGMENTS_TXN_STG
TABLE - MTH.MTH_PROD_SUB_SEGMENTS_ERR
TABLE - MTH.MTH_PROD_SUB_SEGMENTS_F
TABLE - MTH.MTH_PROD_SUB_SEGMENTS_STG
TABLE - MTH.MTH_QUARTER_D
TABLE - MTH.MTH_QUARTER_ERR
TABLE - MTH.MTH_QUARTER_STG
TABLE - MTH.MTH_RESOURCES_D
TABLE - MTH.MTH_RESOURCES_ERR
TABLE - MTH.MTH_RESOURCES_I_STG
TABLE - MTH.MTH_RESOURCES_STG
TABLE - MTH.MTH_RESOURCE_COST
TABLE - MTH.MTH_RESOURCE_COST_ERR
TABLE - MTH.MTH_RESOURCE_COST_I_STG
TABLE - MTH.MTH_RESOURCE_COST_STG
TABLE - MTH.MTH_RESOURCE_REQUIREMENTS_ERR
TABLE - MTH.MTH_RESOURCE_REQUIREMENTS_F
TABLE - MTH.MTH_RESOURCE_REQUIREMENTS_STG
TABLE - MTH.MTH_RESOURCE_TXN_ERR
TABLE - MTH.MTH_RESOURCE_TXN_F
TABLE - MTH.MTH_RESOURCE_TXN_STG
TABLE - MTH.MTH_RES_GRP_ENTITIES_I_STG
TABLE - MTH.MTH_RUNTIME_ERR
TABLE - MTH.MTH_RUN_LOG
TABLE - APPS.MTH_SHIFT_REFERENCE_MV
TABLE - MTH.MTH_SITE_SHIFT_DEFINITIONS
TABLE - MTH.MTH_SITE_SUSTAINABILITIES
TABLE - MTH.MTH_SITE_SUSTAIN_SOURCES
TABLE - MTH.MTH_SOURCE_EMISSION_FACTORS
TABLE - MTH.MTH_SUSTAIN_ASPECTS
TABLE - MTH.MTH_SUSTAIN_EMISSIONS
TABLE - MTH.MTH_SUSTAIN_USAGES
TABLE - MTH.MTH_SYSTEMS_SETUP
TABLE - MTH.MTH_TAG_DATA_SOURCES
TABLE - MTH.MTH_TAG_DATA_SOURCES_ERR
TABLE - MTH.MTH_TAG_DATA_SOURCES_STG
TABLE - MTH.MTH_TAG_DESTINATION_MAP
TABLE - MTH.MTH_TAG_MASTER
TABLE - MTH.MTH_TAG_MASTER_ERR
TABLE - MTH.MTH_TAG_MASTER_STG
TABLE - MTH.MTH_TAG_METER_READINGS_LATEST
TABLE - MTH.MTH_TAG_METER_READINGS_RAW
TABLE - MTH.MTH_TAG_READINGS
TABLE - MTH.MTH_TAG_READINGS_ERR
TABLE - MTH.MTH_TAG_READINGS_LATEST
TABLE - MTH.MTH_TAG_READINGS_RAW
TABLE - MTH.MTH_TAG_READINGS_RAW_ERR
TABLE - MTH.MTH_TAG_READINGS_RAW_PROCESSED
TABLE - MTH.MTH_TAG_READINGS_STG
TABLE - MTH.MTH_TAG_READINGS_STG_ERR
TABLE - MTH.MTH_TAG_READINGS_T_STG
TABLE - MTH.MTH_TAG_READINGS_UNPROCESS_ERR
TABLE - MTH.MTH_TAG_REASON_READINGS
TABLE - MTH.MTH_TIME_HIERARCHY
TABLE - MTH.MTH_TIME_HIERARCHY_ERR
TABLE - MTH.MTH_TIME_HIERARCHY_STG
TABLE - MTH.MTH_TRANSLATED_MESSAGE
TABLE - MTH.MTH_USER_DIM_ENTITIES_ERR
TABLE - MTH.MTH_USER_DIM_ENTITIES_MST
TABLE - MTH.MTH_USER_DIM_ENTITIES_STG
TABLE - MTH.MTH_USER_DIM_HIERARCHY
TABLE - MTH.MTH_USER_DIM_HIERARCHY_ERR
TABLE - MTH.MTH_USER_DIM_HIERARCHY_STG
TABLE - MTH.MTH_USER_ENTITIES_EXT_B
TABLE - MTH.MTH_USER_ENTITIES_EXT_TL
TABLE - MTH.MTH_VIRTUAL_METER_COMPONENTS
TABLE - MTH.MTH_WEEK_D
TABLE - MTH.MTH_WEEK_ERR
TABLE - MTH.MTH_WEEK_STG
TABLE - MTH.MTH_WORKDAY_SHIFTS_D
TABLE - MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG
TABLE - MTH.MTH_WORKDAY_SHIFTS_ERR
TABLE - MTH.MTH_WORKDAY_SHIFTS_STG
TABLE - MTH.MTH_WO_SALES_ORDERS_ERR
TABLE - MTH.MTH_WO_SALES_ORDERS_F
TABLE - MTH.MTH_WO_SALES_ORDERS_I_STG
TABLE - MTH.MTH_WO_SALES_ORDERS_STG
TABLE - MTH.MTH_YEAR_D
TABLE - MTH.MTH_YEAR_ERR
TABLE - MTH.MTH_YEAR_STG

Table: MTH_445_PERIOD_CALENDAR

Description: This table stores 445/544 period calendar
Primary Key: MTH_445_P_DIMENSION_KEY_PK
  1. DIMENSION_KEY

[top of page]

MTH.MTH_445_PERIOD_CALENDAR does not reference any database object

MTH.MTH_445_PERIOD_CALENDAR is referenced by following:

APPS
MATERIALIZED VIEW - MTH_445_PERIOD_CAL_HOUR_MV
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_MV
MTH
VIEW - MTH_445_PERIOD_CALENDAR#

[top of page]

Table: MTH_445_PERIOD_CAL_HOUR_MV

Description:

[top of page]

APPS.MTH_445_PERIOD_CAL_HOUR_MV does not reference any database object

APPS.MTH_445_PERIOD_CAL_HOUR_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_445_PERIOD_CAL_HOUR_MV

[top of page]

Table: MTH_ALL_ENTITIES_MV

Description:

[top of page]

APPS.MTH_ALL_ENTITIES_MV does not reference any database object

APPS.MTH_ALL_ENTITIES_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ALL_ENTITIES_MV
VIEW - MTH_ENTITY_PLANNED_USAGE_HR_M#
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_HR_MV

[top of page]

Table: MTH_ASSET_ERR

Description: Error table for MTH_ASSET_MST

[top of page]

MTH.MTH_ASSET_ERR does not reference any database object

MTH.MTH_ASSET_ERR is referenced by following:

MTH
VIEW - MTH_ASSET_ERR#

[top of page]

Table: MTH_ASSET_MST

Description: This table stores information about assets. It holds information like Asset Number, Asset Group, Maintenance Organization code and other asset attributes.

[top of page]

MTH.MTH_ASSET_MST does not reference any database object

MTH.MTH_ASSET_MST is referenced by following:

MTH
VIEW - MTH_ASSET_MST#

[top of page]

Table: MTH_ASSET_STG

Description:

[top of page]

MTH.MTH_ASSET_STG does not reference any database object

MTH.MTH_ASSET_STG is referenced by following:

MTH
VIEW - MTH_ASSET_STG#

[top of page]

Table: MTH_CONTEXTUALIZATION_METHOD

Description: This table stores contextualization method setup for equipments

[top of page]

MTH.MTH_CONTEXTUALIZATION_METHOD does not reference any database object

MTH.MTH_CONTEXTUALIZATION_METHOD is referenced by following:

MTH
VIEW - MTH_CONTEXTUALIZATION_METHOD#

[top of page]

Table: MTH_CONTEXTUALIZATION_REQ

Description: This table stores the contextualization rules setup for equipments

[top of page]

MTH.MTH_CONTEXTUALIZATION_REQ does not reference any database object

MTH.MTH_CONTEXTUALIZATION_REQ is referenced by following:

MTH
VIEW - MTH_CONTEXTUALIZATION_REQ#

[top of page]

Table: MTH_DAY_D

Description: This table stores information on day level definition for time dimension.
Primary Key: MTH_DAY_D_U1
  1. REPORT_DATE

[top of page]

MTH.MTH_DAY_D does not reference any database object

MTH.MTH_DAY_D is referenced by following:

MTH
VIEW - MTH_DAY_D#

[top of page]

Table: MTH_DAY_STG

Description:

[top of page]

MTH.MTH_DAY_STG does not reference any database object

MTH.MTH_DAY_STG is referenced by following:

MTH
VIEW - MTH_DAY_STG#

[top of page]

Table: MTH_DEPT_ENTITIES_I_STG

Description: Interface table for MTH_EQUIP_ENTITIES_MST

[top of page]

MTH.MTH_DEPT_ENTITIES_I_STG does not reference any database object

MTH.MTH_DEPT_ENTITIES_I_STG is referenced by following:

MTH
VIEW - MTH_DEPT_ENTITIES_I_STG#

[top of page]

Table: MTH_DIM_HIERARCHY

Description: This table is the hierarchy master table for all dimensions.
Primary Key: MTH_DIM_HIERARCHY_U1
  1. DIMENSION_NAME
  2. HIERARCHY_NAME

[top of page]

MTH.MTH_DIM_HIERARCHY does not reference any database object

MTH.MTH_DIM_HIERARCHY is referenced by following:

MTH
VIEW - MTH_DIM_HIERARCHY#

[top of page]

Table: MTH_DIM_HIERARCHY_ERR

Description: Error table for MTH_DIM_HIERARCHY

[top of page]

MTH.MTH_DIM_HIERARCHY_ERR does not reference any database object

MTH.MTH_DIM_HIERARCHY_ERR is referenced by following:

MTH
VIEW - MTH_DIM_HIERARCHY_ERR#

[top of page]

Table: MTH_DIM_HIERARCHY_STG

Description:

[top of page]

MTH.MTH_DIM_HIERARCHY_STG does not reference any database object

MTH.MTH_DIM_HIERARCHY_STG is referenced by following:

MTH
VIEW - MTH_DIM_HIERARCHY_STG#

[top of page]

Table: MTH_DIM_LEVEL_LOOKUP

Description: This table stores the level information for the dimension hierarchies. It holds information on level number, level name and level type.
Primary Key: MTH_DIM_LEVEL_LOOKUP_U1
  1. DIMENSION_ID
  2. HIERARCHY_ID
  3. LEVEL_NUM

[top of page]

MTH.MTH_DIM_LEVEL_LOOKUP does not reference any database object

MTH.MTH_DIM_LEVEL_LOOKUP is referenced by following:

MTH
VIEW - MTH_DIM_LEVEL_LOOKUP#

[top of page]

Table: MTH_DIM_LEVEL_LOOKUP_ERR

Description: Error table for MTH_DIM_LEVEL_LOOKUP
Primary Key: MTH_DIM_LEVEL_LOOKUP_ERR_U1
  1. HIERARCHY_NAME
  2. DIMENSION_NAME
  3. LEVEL_NUM

[top of page]

MTH.MTH_DIM_LEVEL_LOOKUP_ERR does not reference any database object

MTH.MTH_DIM_LEVEL_LOOKUP_ERR is referenced by following:

MTH
VIEW - MTH_DIM_LEVEL_LOOKUP_ERR#

[top of page]

Table: MTH_DIM_LEVEL_LOOKUP_STG

Description:

[top of page]

MTH.MTH_DIM_LEVEL_LOOKUP_STG does not reference any database object

MTH.MTH_DIM_LEVEL_LOOKUP_STG is referenced by following:

MTH
VIEW - MTH_DIM_LEVEL_LOOKUP_STG#

[top of page]

Table: MTH_ENTITIES

Description: This tables stores the pre-defined entities for Manufacturing Operations Center

[top of page]

MTH.MTH_ENTITIES does not reference any database object

MTH.MTH_ENTITIES is referenced by following:

MTH
VIEW - MTH_ENTITIES#

[top of page]

Table: MTH_ENTITY_ATTRIBUTES

Description: This table will store time-series attributes for Equipment Entities.

[top of page]

MTH.MTH_ENTITY_ATTRIBUTES does not reference any database object

MTH.MTH_ENTITY_ATTRIBUTES is referenced by following:

MTH
VIEW - MTH_ENTITY_ATTRIBUTES#

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE

Description: MTH_ENTITY_PLANNED_USAGE will contain the planned energy usage for an entity for a particular period, which can be month, week or year. It can also store Planned usages for other Sustainability Aspects, if any are added later.

[top of page]

MTH.MTH_ENTITY_PLANNED_USAGE does not reference any database object

MTH.MTH_ENTITY_PLANNED_USAGE is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_MV
MTH
VIEW - MTH_ENTITY_PLANNED_USAGE#

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE_ERR

Description:

[top of page]

MTH.MTH_ENTITY_PLANNED_USAGE_ERR does not reference any database object

MTH.MTH_ENTITY_PLANNED_USAGE_ERR is referenced by following:

MTH
VIEW - MTH_ENTITY_PLANNED_USAGE_ERR#

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE_HR_MV

Description:

[top of page]

APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV does not reference any database object

APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_HR_MV
VIEW - MTH_ENTITY_PLANNED_USAGE_SM_M#
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_SM_MV

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE_MV

Description:

[top of page]

APPS.MTH_ENTITY_PLANNED_USAGE_MV does not reference any database object

APPS.MTH_ENTITY_PLANNED_USAGE_MV is referenced by following:

APPS
VIEW - MTH_ENTITY_PLANNED_USAGE_HR_M#
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_HR_MV
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_MV

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE_SM_MV

Description:

[top of page]

APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV does not reference any database object

APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_SM_MV

[top of page]

Table: MTH_ENTITY_PLANNED_USAGE_STG

Description:

[top of page]

MTH.MTH_ENTITY_PLANNED_USAGE_STG does not reference any database object

MTH.MTH_ENTITY_PLANNED_USAGE_STG is referenced by following:

MTH
VIEW - MTH_ENTITY_PLANNED_USAGE_STG#

[top of page]

Table: MTH_ENTITY_SUSTAIN_ASPECT

Description: MTH_ENTITY_SUSTAIN_ASPECT is used to store entity sustainability aspect

[top of page]

MTH.MTH_ENTITY_SUSTAIN_ASPECT does not reference any database object

MTH.MTH_ENTITY_SUSTAIN_ASPECT is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_ENTITY_SUSTAIN_ASPECT#

[top of page]

Table: MTH_ENTITY_SUSTAIN_ASPECT_HOUR

Description: MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour.

[top of page]

MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR does not reference any database object

MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_ENTITY_SUSTAIN_ASPECT_HOU#

[top of page]

Table: MTH_ENTITY_SUST_EMISSIONS

Description: MTH_ENTITY_SUST_EMISSIONS is a child table of MTH_ENTITY_SUSTAIN_ASPECT. It stores the emisssion information for each entry in the parent table.

[top of page]

MTH.MTH_ENTITY_SUST_EMISSIONS does not reference any database object

MTH.MTH_ENTITY_SUST_EMISSIONS is referenced by following:

MTH
VIEW - MTH_ENTITY_SUST_EMISSIONS#

[top of page]

Table: MTH_ENTITY_SUST_HR_EMISSIONS

Description: MTH_ENTITY_SUST_HR_EMISSIONS is a child table of MTH_ENTITY_SUSTAIN_ASPECT_HOUR. It stores the emisssion information for each entry in the parent table.

[top of page]

MTH.MTH_ENTITY_SUST_HR_EMISSIONS does not reference any database object

MTH.MTH_ENTITY_SUST_HR_EMISSIONS is referenced by following:

MTH
VIEW - MTH_ENTITY_SUST_HR_EMISSIONS#

[top of page]

Table: MTH_EQUIPMENTS_D

Description: This table stores information about equipments. It holds information like Equipment name, Equipment description and Fixed asset value and Organization.
Primary Key: MTH_EQUIPMENTS_D_U1
  1. EQUIPMENT_PK
Primary Key: PKEY
  1. EQUIPMENT_PK_KEY

[top of page]

MTH.MTH_EQUIPMENTS_D does not reference any database object

MTH.MTH_EQUIPMENTS_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ALL_ENTITIES_MV
MTH
VIEW - MTH_EQUIPMENTS_D#

[top of page]

Table: MTH_EQUIPMENTS_ERR

Description: Error table for MTH_EQUIPMENTS_D
Primary Key: MTH_EQUIPMENTS_ERR_U1
  1. EQUIPMENT_PK

[top of page]

MTH.MTH_EQUIPMENTS_ERR does not reference any database object

MTH.MTH_EQUIPMENTS_ERR is referenced by following:

MTH
VIEW - MTH_EQUIPMENTS_ERR#

[top of page]

Table: MTH_EQUIPMENTS_EXT_B

Description: This table stores the extensible attributes for equipments

[top of page]

MTH.MTH_EQUIPMENTS_EXT_B does not reference any database object

MTH.MTH_EQUIPMENTS_EXT_B is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIPMENTS_EXT_B#

[top of page]

Table: MTH_EQUIPMENTS_EXT_TL

Description: This table stores the translatable extensible attributes for Equipments

[top of page]

MTH.MTH_EQUIPMENTS_EXT_TL does not reference any database object

MTH.MTH_EQUIPMENTS_EXT_TL is referenced by following:

MTH
VIEW - MTH_EQUIPMENTS_EXT_TL#

[top of page]

Table: MTH_EQUIPMENTS_STG

Description:

[top of page]

MTH.MTH_EQUIPMENTS_STG does not reference any database object

MTH.MTH_EQUIPMENTS_STG is referenced by following:

MTH
VIEW - MTH_EQUIPMENTS_STG#

[top of page]

Table: MTH_EQUIPMENT_DENORM_D

Description: This table stores denormalized data for equipment hierarchy.
Primary Key: MTH_EQUIPM_DIMENSION_KEY_PK
  1. DIMENSION_KEY

[top of page]

MTH.MTH_EQUIPMENT_DENORM_D does not reference any database object

MTH.MTH_EQUIPMENT_DENORM_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_OP_SUM_DD_MV
MATERIALIZED VIEW - MTH_EQUIP_PROD_SCH_DD_MV
MATERIALIZED VIEW - MTH_EQUIP_SHFT_DD_MV
MATERIALIZED VIEW - MTH_EQUIP_ST_SUM_DD_MV
MTH
VIEW - MTH_EQUIPMENT_DENORM_D#

[top of page]

Table: MTH_EQUIPMENT_REASON_SETUP

Description: This table stores Reason code as well as the Expected Uptime for Equipments

[top of page]

MTH.MTH_EQUIPMENT_REASON_SETUP does not reference any database object

MTH.MTH_EQUIPMENT_REASON_SETUP is referenced by following:

MTH
VIEW - MTH_EQUIPMENT_REASON_SETUP#

[top of page]

Table: MTH_EQUIPMENT_REASON_SETUP_ERR

Description: Error table for MTH_EQUIPMENT_REASON_SETUP

[top of page]

MTH.MTH_EQUIPMENT_REASON_SETUP_ERR does not reference any database object

MTH.MTH_EQUIPMENT_REASON_SETUP_ERR is referenced by following:

MTH
VIEW - MTH_EQUIPMENT_REASON_SETUP_ER#

[top of page]

Table: MTH_EQUIPMENT_REASON_SETUP_STG

Description:

[top of page]

MTH.MTH_EQUIPMENT_REASON_SETUP_STG does not reference any database object

MTH.MTH_EQUIPMENT_REASON_SETUP_STG is referenced by following:

MTH
VIEW - MTH_EQUIPMENT_REASON_SETUP_ST#

[top of page]

Table: MTH_EQUIPMENT_SHIFTS_D

Description: This table stores shift information at equipment level.

[top of page]

MTH.MTH_EQUIPMENT_SHIFTS_D does not reference any database object

MTH.MTH_EQUIPMENT_SHIFTS_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_SHFT_DD_MV
MTH
VIEW - MTH_EQUIPMENT_SHIFTS_D#

[top of page]

Table: MTH_EQUIPMENT_SHIFTS_ERR

Description: Error table for MTH_EQUIPMENT_SHIFTS_D

[top of page]

MTH.MTH_EQUIPMENT_SHIFTS_ERR does not reference any database object

MTH.MTH_EQUIPMENT_SHIFTS_ERR is referenced by following:

MTH
VIEW - MTH_EQUIPMENT_SHIFTS_ERR#

[top of page]

Table: MTH_EQUIPMENT_SHIFTS_STG

Description:

[top of page]

MTH.MTH_EQUIPMENT_SHIFTS_STG does not reference any database object

MTH.MTH_EQUIPMENT_SHIFTS_STG is referenced by following:

MTH
VIEW - MTH_EQUIPMENT_SHIFTS_STG#

[top of page]

Table: MTH_EQUIP_ENTITIES_ERR

Description: Error table for MTH_EQUIP_ENTITIES_MST

[top of page]

MTH.MTH_EQUIP_ENTITIES_ERR does not reference any database object

MTH.MTH_EQUIP_ENTITIES_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_ENTITIES_ERR#

[top of page]

Table: MTH_EQUIP_ENTITIES_MST

Description: This table stores the entity definitions for equipment dimension. It holds information on Entity name and Entity type.
Primary Key: MTH_EQUIP_ENTITIES_MST_U1
  1. ENTITY_PK

[top of page]

MTH.MTH_EQUIP_ENTITIES_MST does not reference any database object

MTH.MTH_EQUIP_ENTITIES_MST is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ALL_ENTITIES_MV
MTH
VIEW - MTH_EQUIP_ENTITIES_MST#

[top of page]

Table: MTH_EQUIP_ENTITIES_STG

Description: Staging table for MTH_EQUIP_ENTITIES_MST

[top of page]

MTH.MTH_EQUIP_ENTITIES_STG does not reference any database object

MTH.MTH_EQUIP_ENTITIES_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_ENTITIES_STG#

[top of page]

Table: MTH_EQUIP_HIERARCHY

Description: This table stores the history of parent - child relationship for equipment hierarchy.
Primary Key: MTH_EQUIP_HIERARCHY_U1
  1. HIERARCHY_ID
  2. LEVEL_FK_KEY

[top of page]

MTH.MTH_EQUIP_HIERARCHY does not reference any database object

MTH.MTH_EQUIP_HIERARCHY is referenced by following:

MTH
VIEW - MTH_EQUIP_HIERARCHY#

[top of page]

Table: MTH_EQUIP_HIERARCHY_ERR

Description: Error table for MTH_EQUIPMENT_HIERARCHY
Primary Key: MTH_EQUIP_HIERARCHY_ERR_U1
  1. HIERARCHY_NAME
  2. LEVEL_FK

[top of page]

MTH.MTH_EQUIP_HIERARCHY_ERR does not reference any database object

MTH.MTH_EQUIP_HIERARCHY_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_HIERARCHY_ERR#

[top of page]

Table: MTH_EQUIP_HIERARCHY_STG

Description:

[top of page]

MTH.MTH_EQUIP_HIERARCHY_STG does not reference any database object

MTH.MTH_EQUIP_HIERARCHY_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_HIERARCHY_STG#

[top of page]

Table: MTH_EQUIP_OUTPUT

Description: This table stores the output information by reading time. It holds information on quantity completed, rejected, scrapped, reworked and good quantity.

[top of page]

MTH.MTH_EQUIP_OUTPUT does not reference any database object

MTH.MTH_EQUIP_OUTPUT is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_OUTPUT#

[top of page]

Table: MTH_EQUIP_OUTPUT_ERR

Description: Error table for MTH_EQUIP_OUTPUT

[top of page]

MTH.MTH_EQUIP_OUTPUT_ERR does not reference any database object

MTH.MTH_EQUIP_OUTPUT_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_OUTPUT_ERR#

[top of page]

Table: MTH_EQUIP_OUTPUT_STG

Description:

[top of page]

MTH.MTH_EQUIP_OUTPUT_STG does not reference any database object

MTH.MTH_EQUIP_OUTPUT_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_OUTPUT_STG#

[top of page]

Table: MTH_EQUIP_OUTPUT_SUMMARY

Description: This table stores summarized information on equipment output by quantity completed, rejected, scrapped, reworked and good quantity

[top of page]

MTH.MTH_EQUIP_OUTPUT_SUMMARY does not reference any database object

MTH.MTH_EQUIP_OUTPUT_SUMMARY is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_OP_SUM_DD_MV
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_OUTPUT_SUMMARY#

[top of page]

Table: MTH_EQUIP_PROD_PERFORMANCE_ERR

Description: Error table for MTH_EQUIP_PROD_PERFORMANCE_F

[top of page]

MTH.MTH_EQUIP_PROD_PERFORMANCE_ERR does not reference any database object

MTH.MTH_EQUIP_PROD_PERFORMANCE_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_PROD_PERFORMANCE_ER#

[top of page]

Table: MTH_EQUIP_PROD_PERFORMANCE_F

Description: This table stores information on actual equipment production schedule for each work order at the shift and operations level.

[top of page]

MTH.MTH_EQUIP_PROD_PERFORMANCE_F does not reference any database object

MTH.MTH_EQUIP_PROD_PERFORMANCE_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_PROD_PERFORMANCE_F#

[top of page]

Table: MTH_EQUIP_PROD_PERFORMANCE_STG

Description:

[top of page]

MTH.MTH_EQUIP_PROD_PERFORMANCE_STG does not reference any database object

MTH.MTH_EQUIP_PROD_PERFORMANCE_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_PROD_PERFORMANCE_ST#

[top of page]

Table: MTH_EQUIP_PROD_PERF_DETAIL_F

Description: It contains similar information in equipment production performace with more granular status information.

[top of page]

MTH.MTH_EQUIP_PROD_PERF_DETAIL_F does not reference any database object

MTH.MTH_EQUIP_PROD_PERF_DETAIL_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_PROD_PERF_DETAIL_F#

[top of page]

Table: MTH_EQUIP_PROD_SCHEDULE_ERR

Description: Error table for MTH_EQUIP_PROD_SCHEDULE_F

[top of page]

MTH.MTH_EQUIP_PROD_SCHEDULE_ERR does not reference any database object

MTH.MTH_EQUIP_PROD_SCHEDULE_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_PROD_SCHEDULE_ERR#

[top of page]

Table: MTH_EQUIP_PROD_SCHEDULE_F

Description: This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it is scheduled.
Primary Key: MTH_EQUIP_PROD_SCHEDULE_F_U1
  1. EQUIP_SCHEDULE_PK

[top of page]

MTH.MTH_EQUIP_PROD_SCHEDULE_F does not reference any database object

MTH.MTH_EQUIP_PROD_SCHEDULE_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_PROD_SCH_DD_MV
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_PROD_SCHEDULE_F#

[top of page]

Table: MTH_EQUIP_PROD_SCHEDULE_STG

Description:

[top of page]

MTH.MTH_EQUIP_PROD_SCHEDULE_STG does not reference any database object

MTH.MTH_EQUIP_PROD_SCHEDULE_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_PROD_SCHEDULE_STG#

[top of page]

Table: MTH_EQUIP_PROD_SUSTAIN_F

Description: This table will store the sutain aspect consumption and UOM for the workorder, segment, shift, and hour combination. This table is generic enough to hold consumption for more than one sustainability aspect for production.

[top of page]

MTH.MTH_EQUIP_PROD_SUSTAIN_F does not reference any database object

MTH.MTH_EQUIP_PROD_SUSTAIN_F is referenced by following:

MTH
VIEW - MTH_EQUIP_PROD_SUSTAIN_F#

[top of page]

Table: MTH_EQUIP_SHFT_DD_MV

Description:

[top of page]

APPS.MTH_EQUIP_SHFT_DD_MV does not reference any database object

APPS.MTH_EQUIP_SHFT_DD_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_SHFT_DD_MV
MATERIALIZED VIEW - MTH_EQUIP_SHFT_PM_MV
VIEW - MTH_EQUIP_SHFT_PM_MV#

[top of page]

Table: MTH_EQUIP_STANDARD_RATES_ERR

Description: Error table for MTH_EQUIP_STANDARD_RATES_F

[top of page]

MTH.MTH_EQUIP_STANDARD_RATES_ERR does not reference any database object

MTH.MTH_EQUIP_STANDARD_RATES_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_STANDARD_RATES_ERR#

[top of page]

Table: MTH_EQUIP_STANDARD_RATES_F

Description: This table stores information on standard production rates for equipments.

[top of page]

MTH.MTH_EQUIP_STANDARD_RATES_F does not reference any database object

MTH.MTH_EQUIP_STANDARD_RATES_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_STANDARD_RATES_F#

[top of page]

Table: MTH_EQUIP_STANDARD_RATES_STG

Description:

[top of page]

MTH.MTH_EQUIP_STANDARD_RATES_STG does not reference any database object

MTH.MTH_EQUIP_STANDARD_RATES_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_STANDARD_RATES_STG#

[top of page]

Table: MTH_EQUIP_STATUSES

Description: This table stores information on equipment statuses

[top of page]

MTH.MTH_EQUIP_STATUSES does not reference any database object

MTH.MTH_EQUIP_STATUSES is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_STATUSES#

[top of page]

Table: MTH_EQUIP_STATUSES_ERR

Description: Error table for MTH_EQUIP_STATUSES

[top of page]

MTH.MTH_EQUIP_STATUSES_ERR does not reference any database object

MTH.MTH_EQUIP_STATUSES_ERR is referenced by following:

MTH
VIEW - MTH_EQUIP_STATUSES_ERR#

[top of page]

Table: MTH_EQUIP_STATUSES_STG

Description:

[top of page]

MTH.MTH_EQUIP_STATUSES_STG does not reference any database object

MTH.MTH_EQUIP_STATUSES_STG is referenced by following:

MTH
VIEW - MTH_EQUIP_STATUSES_STG#

[top of page]

Table: MTH_EQUIP_STATUS_SUMMARY

Description: This table stores summarized information on equipment statuses by up time, down time, idle time and run time.

[top of page]

MTH.MTH_EQUIP_STATUS_SUMMARY does not reference any database object

MTH.MTH_EQUIP_STATUS_SUMMARY is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_ST_SUM_DD_MV
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EQUIP_STATUS_SUMMARY#

[top of page]

Table: MTH_EVENTS

Description: This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notification setup.

[top of page]

MTH.MTH_EVENTS does not reference any database object

MTH.MTH_EVENTS is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_EVENTS#

[top of page]

Table: MTH_EVENT_ACTIONS

Description: This table stores the event actions history. It holds information like Event Type, Event action and details of Event action taken.

[top of page]

MTH.MTH_EVENT_ACTIONS does not reference any database object

MTH.MTH_EVENT_ACTIONS is referenced by following:

MTH
VIEW - MTH_EVENT_ACTIONS#

[top of page]

Table: MTH_EVENT_ACTION_SETUP

Description: This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notification setup.

[top of page]

MTH.MTH_EVENT_ACTION_SETUP does not reference any database object

MTH.MTH_EVENT_ACTION_SETUP is referenced by following:

MTH
VIEW - MTH_EVENT_ACTION_SETUP#

[top of page]

Table: MTH_EVENT_ACTION_SETUP_ERR

Description: Error table for MTH_EVENT_ACTION_SETUP

[top of page]

MTH.MTH_EVENT_ACTION_SETUP_ERR does not reference any database object

MTH.MTH_EVENT_ACTION_SETUP_ERR is referenced by following:

MTH
VIEW - MTH_EVENT_ACTION_SETUP_ERR#

[top of page]

Table: MTH_EVENT_ACTION_SETUP_STG

Description:

[top of page]

MTH.MTH_EVENT_ACTION_SETUP_STG does not reference any database object

MTH.MTH_EVENT_ACTION_SETUP_STG is referenced by following:

MTH
VIEW - MTH_EVENT_ACTION_SETUP_STG#

[top of page]

Table: MTH_EVENT_SETUP

Description: This table stores information on Event Action Setup for handling Events. It holds information like Equipment, Event Type and Reason.

[top of page]

MTH.MTH_EVENT_SETUP does not reference any database object

MTH.MTH_EVENT_SETUP is referenced by following:

MTH
VIEW - MTH_EVENT_SETUP#

[top of page]

Table: MTH_EXT_ATTR_ERR

Description: Error table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL

[top of page]

MTH.MTH_EXT_ATTR_ERR does not reference any database object

MTH.MTH_EXT_ATTR_ERR is referenced by following:

MTH
VIEW - MTH_EXT_ATTR_ERR#

[top of page]

Table: MTH_EXT_ATTR_I_STG

Description: Interface table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL

[top of page]

MTH.MTH_EXT_ATTR_I_STG does not reference any database object

MTH.MTH_EXT_ATTR_I_STG is referenced by following:

MTH
VIEW - MTH_EXT_ATTR_I_STG#

[top of page]

Table: MTH_EXT_ATTR_T_STG

Description: Staging table for MTH_EQUIPMENTS_EXT_B, MTH_EQUIPMENTS_EXT_TL, MTH_ITEMS_EXT_B, MTH_ITEMS_EXT_TL, MTH_PRODUCTION_SCHEDULES_EXT_B, MTH_PRODUCTION_SCHEDULE_EXT_TL, MTH_OTHERS_EXT_B and MTH_OTHERS_EXT_TL

[top of page]

MTH.MTH_EXT_ATTR_T_STG does not reference any database object

MTH.MTH_EXT_ATTR_T_STG is referenced by following:

MTH
VIEW - MTH_EXT_ATTR_T_STG#

[top of page]

Table: MTH_GREGORIAN_CALENDAR

Description: This table stores gregorian calendar
Primary Key: MTH_GREGOR_DIMENSION_KEY_PK
  1. DIMENSION_KEY

[top of page]

MTH.MTH_GREGORIAN_CALENDAR does not reference any database object

MTH.MTH_GREGORIAN_CALENDAR is referenced by following:

APPS
MATERIALIZED VIEW - MTH_MTL_CONS_IT_MV
MATERIALIZED VIEW - MTH_MTL_PROD_IT_MV
MATERIALIZED VIEW - MTH_RES_REQ_IT_MV
MATERIALIZED VIEW - MTH_RES_TXN_IT_MV
MATERIALIZED VIEW - MTH_SHIFT_GREGORIAN_DENORM_MV
MTH
VIEW - MTH_GREGORIAN_CALENDAR#

[top of page]

Table: MTH_HOUR_D

Description: MTH_HOUR_D will store the hourly time buckets for each day generated in the calendar.

[top of page]

MTH.MTH_HOUR_D does not reference any database object

MTH.MTH_HOUR_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_445_PERIOD_CAL_HOUR_MV
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_MV
MTH
VIEW - MTH_HOUR_D#

[top of page]

Table: MTH_ITEMS_D

Description: This table stores information on items and its attributes. It holds information like Item name, Item description, Base item, Primary UOM, Secondary UOM, Unit weight, Weight UOM, Unit volume and Volume UOM.
Primary Key: MTH_ITEMS_D_U1
  1. ITEM_PK

[top of page]

MTH.MTH_ITEMS_D does not reference any database object

MTH.MTH_ITEMS_D is referenced by following:

MTH
VIEW - MTH_ITEMS_D#

[top of page]

Table: MTH_ITEMS_ERR

Description: Error table for MTH_ITEMS_D
Primary Key: MTH_ITEMS_ERR_U1
  1. ITEM_PK

[top of page]

MTH.MTH_ITEMS_ERR does not reference any database object

MTH.MTH_ITEMS_ERR is referenced by following:

MTH
VIEW - MTH_ITEMS_ERR#

[top of page]

Table: MTH_ITEMS_EXT_B

Description: This table stores the extensible attributes for items

[top of page]

MTH.MTH_ITEMS_EXT_B does not reference any database object

MTH.MTH_ITEMS_EXT_B is referenced by following:

MTH
VIEW - MTH_ITEMS_EXT_B#

[top of page]

Table: MTH_ITEMS_EXT_TL

Description: This table stores the translatable extensible attributes for Items

[top of page]

MTH.MTH_ITEMS_EXT_TL does not reference any database object

MTH.MTH_ITEMS_EXT_TL is referenced by following:

MTH
VIEW - MTH_ITEMS_EXT_TL#

[top of page]

Table: MTH_ITEMS_I_STG

Description: Interface table for MTH_ITEMS_D

[top of page]

MTH.MTH_ITEMS_I_STG does not reference any database object

MTH.MTH_ITEMS_I_STG is referenced by following:

MTH
VIEW - MTH_ITEMS_I_STG#

[top of page]

Table: MTH_ITEMS_STG

Description:

[top of page]

MTH.MTH_ITEMS_STG does not reference any database object

MTH.MTH_ITEMS_STG is referenced by following:

MTH
VIEW - MTH_ITEMS_STG#

[top of page]

Table: MTH_ITEM_CATEGORIES_D

Description: This table stores information on Item Categories.
Primary Key: MTH_ITEM_CATEGORIES_D_U1
  1. CATEGORY_PK

[top of page]

MTH.MTH_ITEM_CATEGORIES_D does not reference any database object

MTH.MTH_ITEM_CATEGORIES_D is referenced by following:

MTH
VIEW - MTH_ITEM_CATEGORIES_D#

[top of page]

Table: MTH_ITEM_CATEGORIES_I_STG

Description: Interface table for MTH_ITEM_CATEGORIES_D

[top of page]

MTH.MTH_ITEM_CATEGORIES_I_STG does not reference any database object

MTH.MTH_ITEM_CATEGORIES_I_STG is referenced by following:

MTH
VIEW - MTH_ITEM_CATEGORIES_I_STG#

[top of page]

Table: MTH_ITEM_CATEGORIES_STG

Description: Staging table for MTH_ITEM_CATEGORIES_D

[top of page]

MTH.MTH_ITEM_CATEGORIES_STG does not reference any database object

MTH.MTH_ITEM_CATEGORIES_STG is referenced by following:

MTH
VIEW - MTH_ITEM_CATEGORIES_STG#

[top of page]

Table: MTH_ITEM_COST

Description: This table stores the information about item cost history. It holds information on item cost for every cost element of the item.

[top of page]

MTH.MTH_ITEM_COST does not reference any database object

MTH.MTH_ITEM_COST is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ITEM_COST_MV
MTH
VIEW - MTH_ITEM_COST#

[top of page]

Table: MTH_ITEM_COST_ERR

Description: Error table for MTH_ITEMS_COST

[top of page]

MTH.MTH_ITEM_COST_ERR does not reference any database object

MTH.MTH_ITEM_COST_ERR is referenced by following:

MTH
VIEW - MTH_ITEM_COST_ERR#

[top of page]

Table: MTH_ITEM_COST_I_STG

Description: Interface table for MTH_ITEM_COST

[top of page]

MTH.MTH_ITEM_COST_I_STG does not reference any database object

MTH.MTH_ITEM_COST_I_STG is referenced by following:

MTH
VIEW - MTH_ITEM_COST_I_STG#

[top of page]

Table: MTH_ITEM_COST_STG

Description:

[top of page]

MTH.MTH_ITEM_COST_STG does not reference any database object

MTH.MTH_ITEM_COST_STG is referenced by following:

MTH
VIEW - MTH_ITEM_COST_STG#

[top of page]

Table: MTH_ITEM_DENORM_D

Description: This table stores denormalized data for item hierarchy.

[top of page]

MTH.MTH_ITEM_DENORM_D does not reference any database object

MTH.MTH_ITEM_DENORM_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_OP_SUM_DD_MV
MATERIALIZED VIEW - MTH_EQUIP_PROD_SCH_DD_MV
MATERIALIZED VIEW - MTH_MTL_CONS_IT_MV
MATERIALIZED VIEW - MTH_MTL_PROD_IT_MV
MATERIALIZED VIEW - MTH_RES_REQ_IT_MV
MATERIALIZED VIEW - MTH_RES_TXN_IT_MV
MTH
VIEW - MTH_ITEM_DENORM_D#

[top of page]

Table: MTH_ITEM_DENORM_D_TMP

Description:

[top of page]

MTH.MTH_ITEM_DENORM_D_TMP does not reference any database object

MTH.MTH_ITEM_DENORM_D_TMP is referenced by following:

APPS
SYNONYM - MTH_ITEM_DENORM_D_TMP
PACKAGE BODY - MTH_ITEM_DIMENSION_PKG

[top of page]

Table: MTH_ITEM_HIERARCHY

Description: This table stores the latest parent - child relationship for item hierarchy.
Primary Key: MTH_ITEM_HIERARCHY_U1
  1. HIERARCHY_ID
  2. LEVEL_FK_KEY

[top of page]

MTH.MTH_ITEM_HIERARCHY does not reference any database object

MTH.MTH_ITEM_HIERARCHY is referenced by following:

MTH
VIEW - MTH_ITEM_HIERARCHY#

[top of page]

Table: MTH_ITEM_HIERARCHY_ERR

Description: Error table for MTH_ITEM_HIERARCHY
Primary Key: MTH_ITEM_HIERARCHY__ERR_U1
  1. HIERARCHY_NAME
  2. LEVEL_FK

[top of page]

MTH.MTH_ITEM_HIERARCHY_ERR does not reference any database object

MTH.MTH_ITEM_HIERARCHY_ERR is referenced by following:

MTH
VIEW - MTH_ITEM_HIERARCHY_ERR#

[top of page]

Table: MTH_ITEM_HIERARCHY_I_STG

Description: Interface table for MTH_ITEM_HIERARCHY

[top of page]

MTH.MTH_ITEM_HIERARCHY_I_STG does not reference any database object

MTH.MTH_ITEM_HIERARCHY_I_STG is referenced by following:

MTH
VIEW - MTH_ITEM_HIERARCHY_I_STG#

[top of page]

Table: MTH_ITEM_HIERARCHY_STG

Description:

[top of page]

MTH.MTH_ITEM_HIERARCHY_STG does not reference any database object

MTH.MTH_ITEM_HIERARCHY_STG is referenced by following:

MTH
VIEW - MTH_ITEM_HIERARCHY_STG#

[top of page]

Table: MTH_LOOKUPS_D

Description: This table stores the lookup code along with the context.

[top of page]

MTH.MTH_LOOKUPS_D does not reference any database object

MTH.MTH_LOOKUPS_D is referenced by following:

MTH
VIEW - MTH_LOOKUPS_D#

[top of page]

Table: MTH_MASTER_SETUP

Description: This table stores information related to Manufacturing Operations Center instance and its attributes .

[top of page]

MTH.MTH_MASTER_SETUP does not reference any database object

MTH.MTH_MASTER_SETUP is referenced by following:

MTH
VIEW - MTH_MASTER_SETUP#

[top of page]

Table: MTH_METERS

Description: This table defines actual and virtual meter definition

[top of page]

MTH.MTH_METERS does not reference any database object

MTH.MTH_METERS is referenced by following:

MTH
VIEW - MTH_METERS#

[top of page]

Table: MTH_METER_ENTITIES

Description: This table defines the association between entities and meter.

[top of page]

MTH.MTH_METER_ENTITIES does not reference any database object

MTH.MTH_METER_ENTITIES is referenced by following:

MTH
VIEW - MTH_METER_ENTITIES#

[top of page]

Table: MTH_METER_READINGS

Description: This table stores actual meter values based on the tag readings from MTH_METER_READINGS_RAW or laded from CSV file and calculated values for virtual meters

[top of page]

MTH.MTH_METER_READINGS does not reference any database object

MTH.MTH_METER_READINGS is referenced by following:

MTH
VIEW - MTH_METER_READINGS#

[top of page]

Table: MTH_METER_READINGS_ERR

Description: This table stores the error rows when processing the data from MTH_METER_READINGS_RAW, when loading data from CSV to MTH_METER_READINGS, and when loading data from MTH_METER_READINGS to MTH_ENTITY_SUSTAIN_ASPECT.

[top of page]

MTH.MTH_METER_READINGS_ERR does not reference any database object

MTH.MTH_METER_READINGS_ERR is referenced by following:

MTH
VIEW - MTH_METER_READINGS_ERR#

[top of page]

Table: MTH_METER_READINGS_STG

Description:

[top of page]

MTH.MTH_METER_READINGS_STG does not reference any database object

MTH.MTH_METER_READINGS_STG is referenced by following:

MTH
VIEW - MTH_METER_READINGS_STG#

[top of page]

Table: MTH_MTL_CONSUMED_TXN_LOT_ERR

Description: Error table for MTH_MTL_CONSUMED_TXN_LOT_F

[top of page]

MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR does not reference any database object

MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR is referenced by following:

MTH
VIEW - MTH_MTL_CONSUMED_TXN_LOT_ERR#

[top of page]

Table: MTH_MTL_CONSUMED_TXN_LOT_F

Description: This table stores the lot, sub-lot and serial number level information for both the product and components used
Primary Key: MTH_MTL_CONSUMED_TXN_LOT_F_U1
  1. WO_MAT_TXN_FK_KEY
  2. USER_DIM1_FK_KEY
  3. USER_DIM2_FK_KEY
  4. USER_DIM3_FK_KEY
  5. USER_DIM4_FK_KEY
  6. USER_DIM5_FK_KEY

[top of page]

MTH.MTH_MTL_CONSUMED_TXN_LOT_F does not reference any database object

MTH.MTH_MTL_CONSUMED_TXN_LOT_F is referenced by following:

MTH
VIEW - MTH_MTL_CONSUMED_TXN_LOT_F#

[top of page]

Table: MTH_MTL_CONSUMED_TXN_LOT_STG

Description:

[top of page]

MTH.MTH_MTL_CONSUMED_TXN_LOT_STG does not reference any database object

MTH.MTH_MTL_CONSUMED_TXN_LOT_STG is referenced by following:

MTH
VIEW - MTH_MTL_CONSUMED_TXN_LOT_STG#

[top of page]

Table: MTH_MTL_PRODUCED_TXN_LOT_ERR

Description: Error table for MTH_MTL_PRODUCED_TXN_LOT_F

[top of page]

MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR does not reference any database object

MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR is referenced by following:

MTH
VIEW - MTH_MTL_PRODUCED_TXN_LOT_ERR#

[top of page]

Table: MTH_MTL_PRODUCED_TXN_LOT_F

Description: This table stores the lot, sub-lot and serial number level information for the products manufactured
Primary Key: MTH_MTL_PRODUCED_TXN_LOT_F_U1
  1. WO_COMP_FK_KEY
  2. USER_DIM1_FK_KEY
  3. USER_DIM2_FK_KEY
  4. USER_DIM3_FK_KEY
  5. USER_DIM4_FK_KEY
  6. USER_DIM5_FK_KEY

[top of page]

MTH.MTH_MTL_PRODUCED_TXN_LOT_F does not reference any database object

MTH.MTH_MTL_PRODUCED_TXN_LOT_F is referenced by following:

MTH
VIEW - MTH_MTL_PRODUCED_TXN_LOT_F#

[top of page]

Table: MTH_MTL_PRODUCED_TXN_LOT_STG

Description:

[top of page]

MTH.MTH_MTL_PRODUCED_TXN_LOT_STG does not reference any database object

MTH.MTH_MTL_PRODUCED_TXN_LOT_STG is referenced by following:

MTH
VIEW - MTH_MTL_PRODUCED_TXN_LOT_STG#

[top of page]

Table: MTH_OPEN_SALES_ORDERS_F

Description:

[top of page]

MTH.MTH_OPEN_SALES_ORDERS_F does not reference any database object

MTH.MTH_OPEN_SALES_ORDERS_F is referenced by following:

MTH
VIEW - MTH_OPEN_SALES_ORDERS_F#

[top of page]

Table: MTH_ORGANIZATIONS_L

Description: This table stores information for the organization dimension. It provides information like Organization name, Organization code, Currency code, Primary cost method and whether the organization is Process enabled.

[top of page]

MTH.MTH_ORGANIZATIONS_L does not reference any database object

MTH.MTH_ORGANIZATIONS_L is referenced by following:

MTH
VIEW - MTH_ORGANIZATIONS_L#

[top of page]

Table: MTH_OTHERS_D

Description: This table stores classifications for "Others" entity
Primary Key: MTH_OTHERS_D_U1
  1. OTHER_CLASSIFICATION

[top of page]

MTH.MTH_OTHERS_D does not reference any database object

MTH.MTH_OTHERS_D is referenced by following:

MTH
VIEW - MTH_OTHERS_D#

[top of page]

Table: MTH_OTHERS_EXT_B

Description: This table stores the extensible attributes for OTHERS entity

[top of page]

MTH.MTH_OTHERS_EXT_B does not reference any database object

MTH.MTH_OTHERS_EXT_B is referenced by following:

MTH
VIEW - MTH_OTHERS_EXT_B#

[top of page]

Table: MTH_OTHERS_EXT_TL

Description: This table stores the translatable extensible attributes for OTHERS entity

[top of page]

MTH.MTH_OTHERS_EXT_TL does not reference any database object

MTH.MTH_OTHERS_EXT_TL is referenced by following:

MTH
VIEW - MTH_OTHERS_EXT_TL#

[top of page]

Table: MTH_PERIOD_D

Description: This table stores information on period level definition for time dimension hierarchies.
Primary Key: MTH_PERIOD_D_U1
  1. NAME
  2. HIERARCHY_ID

[top of page]

MTH.MTH_PERIOD_D does not reference any database object

MTH.MTH_PERIOD_D is referenced by following:

MTH
VIEW - MTH_PERIOD_D#

[top of page]

Table: MTH_PERIOD_ERR

Description: Error table for MTH_PERIOD_D
Primary Key: MTH_PERIOD_ERR_U1
  1. NAME
  2. HIERARCHY_NAME

[top of page]

MTH.MTH_PERIOD_ERR does not reference any database object

MTH.MTH_PERIOD_ERR is referenced by following:

MTH
VIEW - MTH_PERIOD_ERR#

[top of page]

Table: MTH_PERIOD_STG

Description:

[top of page]

MTH.MTH_PERIOD_STG does not reference any database object

MTH.MTH_PERIOD_STG is referenced by following:

MTH
VIEW - MTH_PERIOD_STG#

[top of page]

Table: MTH_PERSONNEL_D

Description: This table stores information about personnel. It holds information like First name, Last name, Resource and Organization.
Primary Key: MTH_PERSONNEL_D_U1
  1. PERSONNEL_PK

[top of page]

MTH.MTH_PERSONNEL_D does not reference any database object

MTH.MTH_PERSONNEL_D is referenced by following:

MTH
VIEW - MTH_PERSONNEL_D#

[top of page]

Table: MTH_PERSONNEL_ERR

Description: Error table for MTH_PERSONNEL_D
Primary Key: MTH_PERSONNEL_ERR_U1
  1. PERSONNEL_PK

[top of page]

MTH.MTH_PERSONNEL_ERR does not reference any database object

MTH.MTH_PERSONNEL_ERR is referenced by following:

MTH
VIEW - MTH_PERSONNEL_ERR#

[top of page]

Table: MTH_PERSONNEL_STG

Description:

[top of page]

MTH.MTH_PERSONNEL_STG does not reference any database object

MTH.MTH_PERSONNEL_STG is referenced by following:

MTH
VIEW - MTH_PERSONNEL_STG#

[top of page]

Table: MTH_PLANTS_D

Description: This table stores information for the plant dimension. It provides information like Plant name, Currency code, Plant start date, Plant end date and Graveyard shift definition for the plant.
Primary Key: MTH_PLANTS_D_U1
  1. PLANT_PK

[top of page]

MTH.MTH_PLANTS_D does not reference any database object

MTH.MTH_PLANTS_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ALL_ENTITIES_MV
MTH
VIEW - MTH_PLANTS_D#

[top of page]

Table: MTH_PLANTS_ERR

Description: This table will be used to store the error rows when loading data from the staging table to MTH_PLANTS_D table.

[top of page]

MTH.MTH_PLANTS_ERR does not reference any database object

MTH.MTH_PLANTS_ERR is referenced by following:

MTH
VIEW - MTH_PLANTS_ERR#

[top of page]

Table: MTH_PLANTS_STG

Description: This table will be used to as staging table to load the plants data from CSV

[top of page]

MTH.MTH_PLANTS_STG does not reference any database object

MTH.MTH_PLANTS_STG is referenced by following:

MTH
VIEW - MTH_PLANTS_STG#

[top of page]

Table: MTH_PLANT_ATTRIBUTES

Description: This table will store time-series attributes for Site.

[top of page]

MTH.MTH_PLANT_ATTRIBUTES does not reference any database object

MTH.MTH_PLANT_ATTRIBUTES is referenced by following:

MTH
VIEW - MTH_PLANT_ATTRIBUTES#

[top of page]

Table: MTH_PRODUCTION_SCHEDULES_ERR

Description: Error table for MTH_PRODUCTION_SCHEDULES_F
Primary Key: MTH_PRODUCTION_SCHEDULES_ER_U1
  1. WORKORDER_PK

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_ERR does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_ERR is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SCHEDULES_ERR#

[top of page]

Table: MTH_PRODUCTION_SCHEDULES_EXT_B

Description: This table stores the extensible attributes for Work Orders

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_EXT_B does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_EXT_B is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SCHEDULES_EXT_#

[top of page]

Table: MTH_PRODUCTION_SCHEDULES_F

Description: This table stores the work order information for all types of work orders. It holds information on work order type, status, the scheduled and the actual start and end dates, the BOM and Routing information used on the work order, the demand
Primary Key: MTH_PRODUCTION_SCHEDULES_F_U1
  1. WORKORDER_PK

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_F does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_EQUIP_OP_SUM_DD_MV
MTH
VIEW - MTH_PRODUCTION_SCHEDULES_F#

[top of page]

Table: MTH_PRODUCTION_SCHEDULES_I_STG

Description: Interface table for MTH_PRODUCTION_SCHEDULES_F

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_I_STG does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_I_STG is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SCHEDULES_I_ST#

[top of page]

Table: MTH_PRODUCTION_SCHEDULES_STG

Description:

[top of page]

MTH.MTH_PRODUCTION_SCHEDULES_STG does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULES_STG is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SCHEDULES_STG#

[top of page]

Table: MTH_PRODUCTION_SCHEDULE_EXT_TL

Description: This table stores the translatable extensible attributes for Work Orders

[top of page]

MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL does not reference any database object

MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SCHEDULE_EXT_T#

[top of page]

Table: MTH_PRODUCTION_SEGMENTS_ERR

Description: Error Table for MTH_PRODUCTION_SEGMENTS_F
Primary Key: MTH_PRODUCTION_SEGMENTS_ERR_U1
  1. SEGMENT_PK

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_ERR does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_ERR is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SEGMENTS_ERR#

[top of page]

Table: MTH_PRODUCTION_SEGMENTS_EXT_B

Description: This table stores external attributes data for Workorder Segments

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_EXT_B does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_EXT_B is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SEGMENTS_EXT_B#

[top of page]

Table: MTH_PRODUCTION_SEGMENTS_EXT_TL

Description: This table stores the translatable extensible attributes for Workorder Segments

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_EXT_TL does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_EXT_TL is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SEGMENTS_EXT_T#

[top of page]

Table: MTH_PRODUCTION_SEGMENTS_F

Description: This table stores information on operations for various types of work orders. It holds information on Scheduled quantity, actual completed, scrapped, rejected, reworked and actual start and completion dates.
Primary Key: MTH_PRODUCTION_SEGMENTS_F_U1
  1. SEGMENT_PK

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_F does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_F is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SEGMENTS_F#

[top of page]

Table: MTH_PRODUCTION_SEGMENTS_STG

Description:

[top of page]

MTH.MTH_PRODUCTION_SEGMENTS_STG does not reference any database object

MTH.MTH_PRODUCTION_SEGMENTS_STG is referenced by following:

MTH
VIEW - MTH_PRODUCTION_SEGMENTS_STG#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_ERR

Description: Error table for MTH_PROD_MTL_CONSUMED_F

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_ERR does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_ERR is referenced by following:

MTH
VIEW - MTH_PROD_MTL_CONSUMED_ERR#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_F

Description: This table stores the information on planned and actual usage quantities for components
Primary Key: MTH_PROD_MTL_CONSUMED_F_U1
  1. WO_MAT_REQ_PK

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_F does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_MTL_CONS_IT_MV
MTH
VIEW - MTH_PROD_MTL_CONSUMED_F#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_STG

Description:

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_STG does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_STG is referenced by following:

MTH
VIEW - MTH_PROD_MTL_CONSUMED_STG#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_TXN_ERR

Description: Error table for MTH_PROD_MTL_CONSUMED_TXN_F
Primary Key: MTH_PROD_MTL_CONSUMED_TXN_E_U1
  1. WO_MAT_TXN_PK

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR is referenced by following:

MTH
VIEW - MTH_PROD_MTL_CONSUMED_TXN_ERR#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_TXN_F

Description: This table stores the information on transactions that consume the component material at the operation level of the work orders
Primary Key: MTH_PROD_MTL_CONSUMED_TXN_F_U1
  1. WO_MAT_TXN_PK

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_TXN_F does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_TXN_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_PROD_MTL_CONSUMED_TXN_F#

[top of page]

Table: MTH_PROD_MTL_CONSUMED_TXN_STG

Description:

[top of page]

MTH.MTH_PROD_MTL_CONSUMED_TXN_STG does not reference any database object

MTH.MTH_PROD_MTL_CONSUMED_TXN_STG is referenced by following:

MTH
VIEW - MTH_PROD_MTL_CONSUMED_TXN_STG#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_ERR

Description: Error table for MTH_PROD_MTL_PRODUCED_F
Primary Key: MTH_PROD_MTL_PRODUCED_ERR_U1
  1. ITEM_FK
  2. WORKORDER_FK

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_ERR does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_ERR is referenced by following:

MTH
VIEW - MTH_PROD_MTL_PRODUCED_ERR#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_F

Description: This table stores the work order item information. It holds information about the quantity of each item to be assembled, the actual quantity completed along with the scrap, reject and the reworked quantities, the type of the item and its e
Primary Key: MTH_PROD_MTL_PRODUCED_F_U1
  1. WORKORDER_FK_KEY
  2. ITEM_FK_KEY

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_F does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_MTL_PROD_IT_MV
MTH
VIEW - MTH_PROD_MTL_PRODUCED_F#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_I_STG

Description: Interface table for MTH_PROD_MTL_PRODUCED_F

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_I_STG does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_I_STG is referenced by following:

MTH
VIEW - MTH_PROD_MTL_PRODUCED_I_STG#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_STG

Description:

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_STG does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_STG is referenced by following:

MTH
VIEW - MTH_PROD_MTL_PRODUCED_STG#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_TXN_ERR

Description: Error table for MTH_PROD_MTL_PRODUCED_TXN_F
Primary Key: MTH_PROD_MTL_PRODUCED_TXN_E_U1
  1. WO_COMP_PK

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR is referenced by following:

MTH
VIEW - MTH_PROD_MTL_PRODUCED_TXN_ERR#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_TXN_F

Description: This table stores information on assembly completion transactions at the operation level of the work orders
Primary Key: MTH_PROD_MTL_PRODUCED_TXN_F_U1
  1. WO_COMP_PK

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_TXN_F does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_TXN_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_PROD_MTL_PRODUCED_TXN_F#

[top of page]

Table: MTH_PROD_MTL_PRODUCED_TXN_STG

Description:

[top of page]

MTH.MTH_PROD_MTL_PRODUCED_TXN_STG does not reference any database object

MTH.MTH_PROD_MTL_PRODUCED_TXN_STG is referenced by following:

MTH
VIEW - MTH_PROD_MTL_PRODUCED_TXN_STG#

[top of page]

Table: MTH_PROD_SEGMENTS_TXN_ERR

Description: Error table for MTH_PROD_SEGMENTS_TXN_F
Primary Key: MTH_PROD_SEGMENTS_TXN_ERR_U1
  1. USER_DIM1_FK
  2. WORKORDER_FK
  3. FROM_SEGMENT_FK
  4. USER_DIM2_FK
  5. TO_SEGMENT_FK
  6. USER_DIM3_FK
  7. TRANSACTION_DATE
  8. USER_DIM4_FK
  9. USER_DIM5_FK
  10. ITEM_FK
  11. FROM_STEP_TYPE
  12. TO_STEP_TYPE

[top of page]

MTH.MTH_PROD_SEGMENTS_TXN_ERR does not reference any database object

MTH.MTH_PROD_SEGMENTS_TXN_ERR is referenced by following:

MTH
VIEW - MTH_PROD_SEGMENTS_TXN_ERR#

[top of page]

Table: MTH_PROD_SEGMENTS_TXN_F

Description: This table stores information about the intra-operation transactions that take place at the operation level. It holds information on quantity moved from one intra-operation type to another intra-operation type of the same or a different ope
Primary Key: MTH_PROD_SEGMENTS_TXN_F_U1
  1. WORKORDER_FK_KEY
  2. FROM_SEGMENT_FK_KEY
  3. TO_SEGMENT_FK_KEY
  4. TRANSACTION_DATE
  5. ITEM_FK_KEY
  6. FROM_STEP_TYPE
  7. TO_STEP_TYPE
  8. USER_DIM1_FK_KEY
  9. USER_DIM2_FK_KEY
  10. USER_DIM3_FK_KEY
  11. USER_DIM4_FK_KEY
  12. USER_DIM5_FK_KEY

[top of page]

MTH.MTH_PROD_SEGMENTS_TXN_F does not reference any database object

MTH.MTH_PROD_SEGMENTS_TXN_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_PROD_SEGMENTS_TXN_F#

[top of page]

Table: MTH_PROD_SEGMENTS_TXN_STG

Description:

[top of page]

MTH.MTH_PROD_SEGMENTS_TXN_STG does not reference any database object

MTH.MTH_PROD_SEGMENTS_TXN_STG is referenced by following:

MTH
VIEW - MTH_PROD_SEGMENTS_TXN_STG#

[top of page]

Table: MTH_PROD_SUB_SEGMENTS_ERR

Description: Error table for MTH_PROD_SUB_SEGMENTS_STG

[top of page]

MTH.MTH_PROD_SUB_SEGMENTS_ERR does not reference any database object

MTH.MTH_PROD_SUB_SEGMENTS_ERR is referenced by following:

MTH
VIEW - MTH_PROD_SUB_SEGMENTS_ERR#

[top of page]

Table: MTH_PROD_SUB_SEGMENTS_F

Description: This table stores information on activities for each operation (Segment). It holds information on Sub-segment, actual and planned start dates, actual and planned completion dates.

[top of page]

MTH.MTH_PROD_SUB_SEGMENTS_F does not reference any database object

MTH.MTH_PROD_SUB_SEGMENTS_F is referenced by following:

MTH
VIEW - MTH_PROD_SUB_SEGMENTS_F#

[top of page]

Table: MTH_PROD_SUB_SEGMENTS_STG

Description:

[top of page]

MTH.MTH_PROD_SUB_SEGMENTS_STG does not reference any database object

MTH.MTH_PROD_SUB_SEGMENTS_STG is referenced by following:

MTH
VIEW - MTH_PROD_SUB_SEGMENTS_STG#

[top of page]

Table: MTH_QUARTER_D

Description: This table stores information on quarter level definition for time dimension hierarchies.
Primary Key: MTH_QUARTER_D_U1
  1. NAME
  2. HIERARCHY_ID

[top of page]

MTH.MTH_QUARTER_D does not reference any database object

MTH.MTH_QUARTER_D is referenced by following:

MTH
VIEW - MTH_QUARTER_D#

[top of page]

Table: MTH_QUARTER_ERR

Description: Error table for MTH_QUARTER_D
Primary Key: MTH_QUARTER_ERR_U1
  1. NAME
  2. HIERARCHY_NAME

[top of page]

MTH.MTH_QUARTER_ERR does not reference any database object

MTH.MTH_QUARTER_ERR is referenced by following:

MTH
VIEW - MTH_QUARTER_ERR#

[top of page]

Table: MTH_QUARTER_STG

Description:

[top of page]

MTH.MTH_QUARTER_STG does not reference any database object

MTH.MTH_QUARTER_STG is referenced by following:

MTH
VIEW - MTH_QUARTER_STG#

[top of page]

Table: MTH_RESOURCES_D

Description: This table stores information about resources. It holds information like Resource name, Resource description, Resource type, Usage UOM, Resource capacity, whether the resource is available for 24 hours or shift based, Disable date, Departme
Primary Key: MTH_RESOURCES_D_U1
  1. RESOURCE_PK

[top of page]

MTH.MTH_RESOURCES_D does not reference any database object

MTH.MTH_RESOURCES_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ALL_ENTITIES_MV
MTH
VIEW - MTH_RESOURCES_D#

[top of page]

Table: MTH_RESOURCES_ERR

Description: Error table for MTH_RESOURCES_D
Primary Key: MTH_RESOURCES_ERR_U1
  1. RESOURCE_PK

[top of page]

MTH.MTH_RESOURCES_ERR does not reference any database object

MTH.MTH_RESOURCES_ERR is referenced by following:

MTH
VIEW - MTH_RESOURCES_ERR#

[top of page]

Table: MTH_RESOURCES_I_STG

Description: Interface table for MTH_RESOURCES_D

[top of page]

MTH.MTH_RESOURCES_I_STG does not reference any database object

MTH.MTH_RESOURCES_I_STG is referenced by following:

MTH
VIEW - MTH_RESOURCES_I_STG#

[top of page]

Table: MTH_RESOURCES_STG

Description:

[top of page]

MTH.MTH_RESOURCES_STG does not reference any database object

MTH.MTH_RESOURCES_STG is referenced by following:

MTH
VIEW - MTH_RESOURCES_STG#

[top of page]

Table: MTH_RESOURCE_COST

Description: This table stores the information about resource cost history. It holds information on resource cost for every cost element of the resource.

[top of page]

MTH.MTH_RESOURCE_COST does not reference any database object

MTH.MTH_RESOURCE_COST is referenced by following:

APPS
MATERIALIZED VIEW - MTH_RESOURCE_COST_MV
MTH
VIEW - MTH_RESOURCE_COST#

[top of page]

Table: MTH_RESOURCE_COST_ERR

Description: Error table for MTH_RESOURCE_COST

[top of page]

MTH.MTH_RESOURCE_COST_ERR does not reference any database object

MTH.MTH_RESOURCE_COST_ERR is referenced by following:

MTH
VIEW - MTH_RESOURCE_COST_ERR#

[top of page]

Table: MTH_RESOURCE_COST_I_STG

Description: Interface table for MTH_RESOURCE_COST

[top of page]

MTH.MTH_RESOURCE_COST_I_STG does not reference any database object

MTH.MTH_RESOURCE_COST_I_STG is referenced by following:

MTH
VIEW - MTH_RESOURCE_COST_I_STG#

[top of page]

Table: MTH_RESOURCE_COST_STG

Description:

[top of page]

MTH.MTH_RESOURCE_COST_STG does not reference any database object

MTH.MTH_RESOURCE_COST_STG is referenced by following:

MTH
VIEW - MTH_RESOURCE_COST_STG#

[top of page]

Table: MTH_RESOURCE_REQUIREMENTS_ERR

Description: Error table for MTH_RESOURCE_REQUIREMENTS_F
Primary Key: MTH_RESOURCE_REQUIREMENTS_E_U1
  1. WORKORDER_FK
  2. PRODUCT_FK
  3. RESOURCE_FK
  4. SEGMENT_FK
  5. SOURCE_ORG_CODE
  6. USER_DIM1_FK
  7. USER_DIM2_FK
  8. USER_DIM3_FK
  9. USER_DIM4_FK
  10. USER_DIM5_FK

[top of page]

MTH.MTH_RESOURCE_REQUIREMENTS_ERR does not reference any database object

MTH.MTH_RESOURCE_REQUIREMENTS_ERR is referenced by following:

MTH
VIEW - MTH_RESOURCE_REQUIREMENTS_ERR#

[top of page]

Table: MTH_RESOURCE_REQUIREMENTS_F

Description: This table stores information on planned resource usages at each operation level on the work order
Primary Key: MTH_RESOURCE_REQUIREMENTS_F_U1
  1. WORKORDER_FK_KEY
  2. PRODUCT_FK_KEY
  3. RESOURCE_FK_KEY
  4. SEGMENT_FK_KEY
  5. PLANT_FK_KEY
  6. USER_DIM1_FK_KEY
  7. USER_DIM2_FK_KEY
  8. USER_DIM3_FK_KEY
  9. USER_DIM4_FK_KEY
  10. USER_DIM5_FK_KEY

[top of page]

MTH.MTH_RESOURCE_REQUIREMENTS_F does not reference any database object

MTH.MTH_RESOURCE_REQUIREMENTS_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_RES_REQ_IT_MV
MTH
VIEW - MTH_RESOURCE_REQUIREMENTS_F#

[top of page]

Table: MTH_RESOURCE_REQUIREMENTS_STG

Description:

[top of page]

MTH.MTH_RESOURCE_REQUIREMENTS_STG does not reference any database object

MTH.MTH_RESOURCE_REQUIREMENTS_STG is referenced by following:

MTH
VIEW - MTH_RESOURCE_REQUIREMENTS_STG#

[top of page]

Table: MTH_RESOURCE_TXN_ERR

Description: Error table for MTH_RESOURCE_TXN_F

[top of page]

MTH.MTH_RESOURCE_TXN_ERR does not reference any database object

MTH.MTH_RESOURCE_TXN_ERR is referenced by following:

MTH
VIEW - MTH_RESOURCE_TXN_ERR#

[top of page]

Table: MTH_RESOURCE_TXN_F

Description: This table stores information on actual resource usages at each operation level on the work order
Primary Key: MTH_RESOURCE_TXN_F_U1
  1. WORKORDER_FK_KEY
  2. RESOURCE_FK_KEY
  3. PRODUCT_FK_KEY
  4. SEGMENT_FK_KEY
  5. SHIFT_WORKDAY_FK_KEY
  6. PLANT_FK_KEY
  7. TRANSACTION_DATE
  8. USER_DIM1_FK_KEY
  9. USER_DIM2_FK_KEY
  10. USER_DIM3_FK_KEY
  11. USER_DIM4_FK_KEY
  12. USER_DIM5_FK_KEY

[top of page]

MTH.MTH_RESOURCE_TXN_F does not reference any database object

MTH.MTH_RESOURCE_TXN_F is referenced by following:

APPS
MATERIALIZED VIEW - MTH_RES_TXN_IT_MV
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_RESOURCE_TXN_F#

[top of page]

Table: MTH_RESOURCE_TXN_STG

Description:

[top of page]

MTH.MTH_RESOURCE_TXN_STG does not reference any database object

MTH.MTH_RESOURCE_TXN_STG is referenced by following:

MTH
VIEW - MTH_RESOURCE_TXN_STG#

[top of page]

Table: MTH_RES_GRP_ENTITIES_I_STG

Description: Interface table for MTH_EQUIP_ENTITIES_MST

[top of page]

MTH.MTH_RES_GRP_ENTITIES_I_STG does not reference any database object

MTH.MTH_RES_GRP_ENTITIES_I_STG is referenced by following:

MTH
VIEW - MTH_RES_GRP_ENTITIES_I_STG#

[top of page]

Table: MTH_RUNTIME_ERR

Description: MTH_RUNTIME_ERR stores errors happened during run time.

[top of page]

MTH.MTH_RUNTIME_ERR does not reference any database object

MTH.MTH_RUNTIME_ERR is referenced by following:

MTH
VIEW - MTH_RUNTIME_ERR#

[top of page]

Table: MTH_RUN_LOG

Description: Log table for internal processing

[top of page]

MTH.MTH_RUN_LOG does not reference any database object

MTH.MTH_RUN_LOG is referenced by following:

MTH
VIEW - MTH_RUN_LOG#

[top of page]

Table: MTH_SHIFT_REFERENCE_MV

Description:

[top of page]

APPS.MTH_SHIFT_REFERENCE_MV does not reference any database object

APPS.MTH_SHIFT_REFERENCE_MV is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
PACKAGE BODY - MTH_UTIL_PKG

[top of page]

Table: MTH_SITE_SHIFT_DEFINITIONS

Description: This table stores the definition of the shift template for a site in order to generate shift for all entities belonging to the site as well as the site itself

[top of page]

MTH.MTH_SITE_SHIFT_DEFINITIONS does not reference any database object

MTH.MTH_SITE_SHIFT_DEFINITIONS is referenced by following:

MTH
VIEW - MTH_SITE_SHIFT_DEFINITIONS#

[top of page]

Table: MTH_SITE_SUSTAINABILITIES

Description: MTH_SITE_SUSTAINABILITIES stores the sustainability aspect setup information for each site.

[top of page]

MTH.MTH_SITE_SUSTAINABILITIES does not reference any database object

MTH.MTH_SITE_SUSTAINABILITIES is referenced by following:

APPS
MATERIALIZED VIEW - MTH_ENTITY_PLANNED_USAGE_HR_MV
MTH
VIEW - MTH_SITE_SUSTAINABILITIES#

[top of page]

Table: MTH_SITE_SUSTAIN_SOURCES

Description: MTH_SITE_SUSTAIN_SOURCES contains energy sources for each entry in MTH_SITE_SUSTAINABILITIES, which contains the combination of MTH_PLANTS and MTH_SUSTAIN_ASPECT_MST.

[top of page]

MTH.MTH_SITE_SUSTAIN_SOURCES does not reference any database object

MTH.MTH_SITE_SUSTAIN_SOURCES is referenced by following:

MTH
VIEW - MTH_SITE_SUSTAIN_SOURCES#

[top of page]

Table: MTH_SOURCE_EMISSION_FACTORS

Description: MTH_SOURCE_EMISSION_FACTORS is a child table of MTH_SITE_SUSTAIN_SOURCES.

[top of page]

MTH.MTH_SOURCE_EMISSION_FACTORS does not reference any database object

MTH.MTH_SOURCE_EMISSION_FACTORS is referenced by following:

MTH
VIEW - MTH_SOURCE_EMISSION_FACTORS#

[top of page]

Table: MTH_SUSTAIN_ASPECTS

Description: This table stores the information for Sustainability Aspects.

[top of page]

MTH.MTH_SUSTAIN_ASPECTS does not reference any database object

MTH.MTH_SUSTAIN_ASPECTS is referenced by following:

MTH
VIEW - MTH_SUSTAIN_ASPECTS#

[top of page]

Table: MTH_SUSTAIN_EMISSIONS

Description: MTH_SUSTAIN_EMISSION is a child table of MTH_SUSTAIN_ASPECTS

[top of page]

MTH.MTH_SUSTAIN_EMISSIONS does not reference any database object

MTH.MTH_SUSTAIN_EMISSIONS is referenced by following:

MTH
VIEW - MTH_SUSTAIN_EMISSIONS#

[top of page]

Table: MTH_SUSTAIN_USAGES

Description: MTH_SUSTAIN_USAGE is a child table of MTH_SUSTAIN_ASPECTS

[top of page]

MTH.MTH_SUSTAIN_USAGES does not reference any database object

MTH.MTH_SUSTAIN_USAGES is referenced by following:

MTH
VIEW - MTH_SUSTAIN_USAGES#

[top of page]

Table: MTH_SYSTEMS_SETUP

Description: This table stores information related to MOC source systems and their attributes.

[top of page]

MTH.MTH_SYSTEMS_SETUP does not reference any database object

MTH.MTH_SYSTEMS_SETUP is referenced by following:

MTH
VIEW - MTH_SYSTEMS_SETUP#

[top of page]

Table: MTH_TAG_DATA_SOURCES

Description: This table defines the sources for tag

[top of page]

MTH.MTH_TAG_DATA_SOURCES does not reference any database object

MTH.MTH_TAG_DATA_SOURCES is referenced by following:

MTH
VIEW - MTH_TAG_DATA_SOURCES#

[top of page]

Table: MTH_TAG_DATA_SOURCES_ERR

Description: This is error table for MTH_TAG_DATA_SOURCES table

[top of page]

MTH.MTH_TAG_DATA_SOURCES_ERR does not reference any database object

MTH.MTH_TAG_DATA_SOURCES_ERR is referenced by following:

MTH
VIEW - MTH_TAG_DATA_SOURCES_ERR#

[top of page]

Table: MTH_TAG_DATA_SOURCES_STG

Description:

[top of page]

MTH.MTH_TAG_DATA_SOURCES_STG does not reference any database object

MTH.MTH_TAG_DATA_SOURCES_STG is referenced by following:

MTH
VIEW - MTH_TAG_DATA_SOURCES_STG#

[top of page]

Table: MTH_TAG_DESTINATION_MAP

Description: This table stores details on tag target entities

[top of page]

MTH.MTH_TAG_DESTINATION_MAP does not reference any database object

MTH.MTH_TAG_DESTINATION_MAP is referenced by following:

MTH
VIEW - MTH_TAG_DESTINATION_MAP#

[top of page]

Table: MTH_TAG_MASTER

Description: This table stores tag master information

[top of page]

MTH.MTH_TAG_MASTER does not reference any database object

MTH.MTH_TAG_MASTER is referenced by following:

MTH
VIEW - MTH_TAG_MASTER#

[top of page]

Table: MTH_TAG_MASTER_ERR

Description: This table stores tag master information

[top of page]

MTH.MTH_TAG_MASTER_ERR does not reference any database object

MTH.MTH_TAG_MASTER_ERR is referenced by following:

MTH
VIEW - MTH_TAG_MASTER_ERR#

[top of page]

Table: MTH_TAG_MASTER_STG

Description:

[top of page]

MTH.MTH_TAG_MASTER_STG does not reference any database object

MTH.MTH_TAG_MASTER_STG is referenced by following:

MTH
VIEW - MTH_TAG_MASTER_STG#

[top of page]

Table: MTH_TAG_METER_READINGS_LATEST

Description: This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_METER_READINGS_RAW

[top of page]

MTH.MTH_TAG_METER_READINGS_LATEST does not reference any database object

MTH.MTH_TAG_METER_READINGS_LATEST is referenced by following:

MTH
VIEW - MTH_TAG_METER_READINGS_LATEST#

[top of page]

Table: MTH_TAG_METER_READINGS_RAW

Description:

[top of page]

MTH.MTH_TAG_METER_READINGS_RAW does not reference any database object

MTH.MTH_TAG_METER_READINGS_RAW is referenced by following:

MTH
VIEW - MTH_TAG_METER_READINGS_RAW#

[top of page]

Table: MTH_TAG_READINGS

Description: This table contains the Manufacturing Operations Center processed tag data

[top of page]

MTH.MTH_TAG_READINGS does not reference any database object

MTH.MTH_TAG_READINGS is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_TAG_READINGS#

[top of page]

Table: MTH_TAG_READINGS_ERR

Description: Error table for MTH_TAG_READINGS

[top of page]

MTH.MTH_TAG_READINGS_ERR does not reference any database object

MTH.MTH_TAG_READINGS_ERR is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_TAG_READINGS_ERR#

[top of page]

Table: MTH_TAG_READINGS_LATEST

Description: This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_READINGS_RAW

[top of page]

MTH.MTH_TAG_READINGS_LATEST does not reference any database object

MTH.MTH_TAG_READINGS_LATEST is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_LATEST#

[top of page]

Table: MTH_TAG_READINGS_RAW

Description: This table contains the unprocessed tag data collected from PLCs

[top of page]

MTH.MTH_TAG_READINGS_RAW does not reference any database object

MTH.MTH_TAG_READINGS_RAW is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_RAW#

[top of page]

Table: MTH_TAG_READINGS_RAW_ERR

Description: Error table for MTH_TAG_READINGS_RAW

[top of page]

MTH.MTH_TAG_READINGS_RAW_ERR does not reference any database object

MTH.MTH_TAG_READINGS_RAW_ERR is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_RAW_ERR#

[top of page]

Table: MTH_TAG_READINGS_RAW_PROCESSED

Description: This table contains the tag data collected from PLCs after applying cumulative logic

[top of page]

MTH.MTH_TAG_READINGS_RAW_PROCESSED does not reference any database object

MTH.MTH_TAG_READINGS_RAW_PROCESSED is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_RAW_PROCESSE#

[top of page]

Table: MTH_TAG_READINGS_STG

Description: Staging table for MTH_TAG_READINGS

[top of page]

MTH.MTH_TAG_READINGS_STG does not reference any database object

MTH.MTH_TAG_READINGS_STG is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_STG#

[top of page]

Table: MTH_TAG_READINGS_STG_ERR

Description: Error table for MTH_TAG_READINGS_STG

[top of page]

MTH.MTH_TAG_READINGS_STG_ERR does not reference any database object

MTH.MTH_TAG_READINGS_STG_ERR is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_STG_ERR#

[top of page]

Table: MTH_TAG_READINGS_T_STG

Description: Staging table to move device data in MTH_EQUIPMENTS_EXT_B

[top of page]

MTH.MTH_TAG_READINGS_T_STG does not reference any database object

MTH.MTH_TAG_READINGS_T_STG is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_TAG_READINGS_T_STG#

[top of page]

Table: MTH_TAG_READINGS_UNPROCESS_ERR

Description: Error table for MTH_TAG_READINGS_RAW

[top of page]

MTH.MTH_TAG_READINGS_UNPROCESS_ERR does not reference any database object

MTH.MTH_TAG_READINGS_UNPROCESS_ERR is referenced by following:

MTH
VIEW - MTH_TAG_READINGS_UNPROCESS_ER#

[top of page]

Table: MTH_TAG_REASON_READINGS

Description: This table stores reasons for downtime and scrap

[top of page]

MTH.MTH_TAG_REASON_READINGS does not reference any database object

MTH.MTH_TAG_REASON_READINGS is referenced by following:

MTH
VIEW - MTH_TAG_REASON_READINGS#

[top of page]

Table: MTH_TIME_HIERARCHY

Description: This table stores the latest parent - child relationship for time hierarchy.
Primary Key: MTH_TIME_HIERARCHY_U1
  1. HIERARCHY_ID
  2. LEVEL_FK_KEY

[top of page]

MTH.MTH_TIME_HIERARCHY does not reference any database object

MTH.MTH_TIME_HIERARCHY is referenced by following:

MTH
VIEW - MTH_TIME_HIERARCHY#

[top of page]

Table: MTH_TIME_HIERARCHY_ERR

Description: Error table for MTH_TIME_HIERARCHY
Primary Key: MTH_TIME_HIERARCHY_ERR_U1
  1. HIERARCHY_NAME
  2. CHILD_FK

[top of page]

MTH.MTH_TIME_HIERARCHY_ERR does not reference any database object

MTH.MTH_TIME_HIERARCHY_ERR is referenced by following:

MTH
VIEW - MTH_TIME_HIERARCHY_ERR#

[top of page]

Table: MTH_TIME_HIERARCHY_STG

Description:

[top of page]

MTH.MTH_TIME_HIERARCHY_STG does not reference any database object

MTH.MTH_TIME_HIERARCHY_STG is referenced by following:

MTH
VIEW - MTH_TIME_HIERARCHY_STG#

[top of page]

Table: MTH_TRANSLATED_MESSAGE

Description: This table is using to store seeding data for translation

[top of page]

MTH.MTH_TRANSLATED_MESSAGE does not reference any database object

MTH.MTH_TRANSLATED_MESSAGE is referenced by following:

MTH
VIEW - MTH_TRANSLATED_MESSAGE#

[top of page]

Table: MTH_USER_DIM_ENTITIES_ERR

Description: Error table for MTH_USER_DIM_ENTITIES
Primary Key: MTH_USER_DIM_ENTITIES_ERR_U1
  1. ENTITY_PK

[top of page]

MTH.MTH_USER_DIM_ENTITIES_ERR does not reference any database object

MTH.MTH_USER_DIM_ENTITIES_ERR is referenced by following:

MTH
VIEW - MTH_USER_DIM_ENTITIES_ERR#

[top of page]

Table: MTH_USER_DIM_ENTITIES_MST

Description: This table stores the entity definitions for user-defined dimensions. It holds information on Entity name and Entity type.
Primary Key: MTH_USER_DIM_ENTITIES_MST_U1
  1. ENTITY_PK

[top of page]

MTH.MTH_USER_DIM_ENTITIES_MST does not reference any database object

MTH.MTH_USER_DIM_ENTITIES_MST is referenced by following:

MTH
VIEW - MTH_USER_DIM_ENTITIES_MST#

[top of page]

Table: MTH_USER_DIM_ENTITIES_STG

Description:

[top of page]

MTH.MTH_USER_DIM_ENTITIES_STG does not reference any database object

MTH.MTH_USER_DIM_ENTITIES_STG is referenced by following:

MTH
VIEW - MTH_USER_DIM_ENTITIES_STG#

[top of page]

Table: MTH_USER_DIM_HIERARCHY

Description: This table stores the latest parent-child hierarchy relationship for user-defined hierarchies.
Primary Key: MTH_USER_DIM_HIERARCHY_U1
  1. HIERARCHY_ID
  2. LEVEL_FK_KEY

[top of page]

MTH.MTH_USER_DIM_HIERARCHY does not reference any database object

MTH.MTH_USER_DIM_HIERARCHY is referenced by following:

MTH
VIEW - MTH_USER_DIM_HIERARCHY#

[top of page]

Table: MTH_USER_DIM_HIERARCHY_ERR

Description: Error table for MTH_USER_DIM_HIERARCHY
Primary Key: MTH_USER_DIM_HIERARCHY_ERR_U1
  1. DIMENSION_NAME
  2. HIERARCHY_NAME
  3. LEVEL_FK

[top of page]

MTH.MTH_USER_DIM_HIERARCHY_ERR does not reference any database object

MTH.MTH_USER_DIM_HIERARCHY_ERR is referenced by following:

MTH
VIEW - MTH_USER_DIM_HIERARCHY_ERR#

[top of page]

Table: MTH_USER_DIM_HIERARCHY_STG

Description:

[top of page]

MTH.MTH_USER_DIM_HIERARCHY_STG does not reference any database object

MTH.MTH_USER_DIM_HIERARCHY_STG is referenced by following:

MTH
VIEW - MTH_USER_DIM_HIERARCHY_STG#

[top of page]

Table: MTH_USER_ENTITIES_EXT_B

Description: This table stores the extensible attributes for User-Defined Entities,Resource and Site

[top of page]

MTH.MTH_USER_ENTITIES_EXT_B does not reference any database object

MTH.MTH_USER_ENTITIES_EXT_B is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_USER_ENTITIES_EXT_B#

[top of page]

Table: MTH_USER_ENTITIES_EXT_TL

Description: This table stores the translatable extensible attributes for User-Defined Entities,Resource and Site

[top of page]

MTH.MTH_USER_ENTITIES_EXT_TL does not reference any database object

MTH.MTH_USER_ENTITIES_EXT_TL is referenced by following:

MTH
VIEW - MTH_USER_ENTITIES_EXT_TL#

[top of page]

Table: MTH_VIRTUAL_METER_COMPONENTS

Description: This table defines required componets for formula in order to calculate the energy consumption.

[top of page]

MTH.MTH_VIRTUAL_METER_COMPONENTS does not reference any database object

MTH.MTH_VIRTUAL_METER_COMPONENTS is referenced by following:

MTH
VIEW - MTH_VIRTUAL_METER_COMPONENTS#

[top of page]

Table: MTH_WEEK_D

Description: This table stores information on week level definition for time dimension hierarchies.
Primary Key: MTH_WEEK_D_U1
  1. NAME
  2. HIERARCHY_ID

[top of page]

MTH.MTH_WEEK_D does not reference any database object

MTH.MTH_WEEK_D is referenced by following:

MTH
VIEW - MTH_WEEK_D#

[top of page]

Table: MTH_WEEK_ERR

Description: Error table for MTH_WEEK_D
Primary Key: MTH_WEEK_ERR_U1
  1. NAME
  2. HIERARCHY_NAME

[top of page]

MTH.MTH_WEEK_ERR does not reference any database object

MTH.MTH_WEEK_ERR is referenced by following:

MTH
VIEW - MTH_WEEK_ERR#

[top of page]

Table: MTH_WEEK_STG

Description:

[top of page]

MTH.MTH_WEEK_STG does not reference any database object

MTH.MTH_WEEK_STG is referenced by following:

MTH
VIEW - MTH_WEEK_STG#

[top of page]

Table: MTH_WORKDAY_SHIFTS_D

Description: This table stores the workday shifts definition for the time dimension. It provides information like Shift date, Shift From Time, Shift To Time, Shift name and Shift number.
Primary Key: MTH_WORKDAY_SHIFTS_D_U1
  1. SHIFT_WORKDAY_PK
  2. PLANT_FK_KEY

[top of page]

MTH.MTH_WORKDAY_SHIFTS_D does not reference any database object

MTH.MTH_WORKDAY_SHIFTS_D is referenced by following:

APPS
MATERIALIZED VIEW - MTH_SHIFT_GREGORIAN_DENORM_MV
MATERIALIZED VIEW - MTH_SHIFT_REFERENCE_MV
MTH
VIEW - MTH_WORKDAY_SHIFTS_D#

[top of page]

Table: MTH_WORKDAY_SHIFTS_DIS_I_STG

Description: Interface table for MTH_WORKDAY_SHIFTS_D

[top of page]

MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG does not reference any database object

MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG is referenced by following:

MTH
VIEW - MTH_WORKDAY_SHIFTS_DIS_I_STG#

[top of page]

Table: MTH_WORKDAY_SHIFTS_ERR

Description: Error table for MTH_WORKDAY_SHIFTS_D
Primary Key: MTH_WORKDAY_SHIFTS_ERR_U1
  1. SHIFT_WORKDAY_PK
  2. SOURCE_ORG_CODE

[top of page]

MTH.MTH_WORKDAY_SHIFTS_ERR does not reference any database object

MTH.MTH_WORKDAY_SHIFTS_ERR is referenced by following:

MTH
VIEW - MTH_WORKDAY_SHIFTS_ERR#

[top of page]

Table: MTH_WORKDAY_SHIFTS_STG

Description:

[top of page]

MTH.MTH_WORKDAY_SHIFTS_STG does not reference any database object

MTH.MTH_WORKDAY_SHIFTS_STG is referenced by following:

MTH
VIEW - MTH_WORKDAY_SHIFTS_STG#

[top of page]

Table: MTH_WO_SALES_ORDERS_ERR

Description: Error table for MTH_WO_SALES_ORDERS_F
Primary Key: MTH_WO_SALES_ORDERS_ERR_U1
  1. WORKORDER_FK
  2. SALESORDER_NUMBER
  3. SALESORDER_LNUMBER

[top of page]

MTH.MTH_WO_SALES_ORDERS_ERR does not reference any database object

MTH.MTH_WO_SALES_ORDERS_ERR is referenced by following:

MTH
VIEW - MTH_WO_SALES_ORDERS_ERR#

[top of page]

Table: MTH_WO_SALES_ORDERS_F

Description: This table stores information on the sales orders that originate the demand for the work orders. It holds information about the sales order line that originated the demand for a given work order, order quantity, customer name, requested, pr
Primary Key: MTH_WO_SALES_ORDERS_F_U1
  1. WORKORDER_FK_KEY
  2. SALESORDER_NUMBER
  3. SALESORDER_LNUMBER

[top of page]

MTH.MTH_WO_SALES_ORDERS_F does not reference any database object

MTH.MTH_WO_SALES_ORDERS_F is referenced by following:

MTH
VIEW - MTH_WO_SALES_ORDERS_F#

[top of page]

Table: MTH_WO_SALES_ORDERS_I_STG

Description: Interface table for MTH_WO_SALES_ORDERS_F

[top of page]

MTH.MTH_WO_SALES_ORDERS_I_STG does not reference any database object

MTH.MTH_WO_SALES_ORDERS_I_STG is referenced by following:

MTH
VIEW - MTH_WO_SALES_ORDERS_I_STG#

[top of page]

Table: MTH_WO_SALES_ORDERS_STG

Description:

[top of page]

MTH.MTH_WO_SALES_ORDERS_STG does not reference any database object

MTH.MTH_WO_SALES_ORDERS_STG is referenced by following:

MTH
VIEW - MTH_WO_SALES_ORDERS_STG#

[top of page]

Table: MTH_YEAR_D

Description: This table stores information on year level definition for time dimension hierarchies.
Primary Key: MTH_YEAR_D_U1
  1. NAME
  2. HIERARCHY_ID

[top of page]

MTH.MTH_YEAR_D does not reference any database object

MTH.MTH_YEAR_D is referenced by following:

MTH
VIEW - MTH_YEAR_D#

[top of page]

Table: MTH_YEAR_ERR

Description: Error table for MTH_YEAR_D
Primary Key: MTH_YEAR_ERR_U1
  1. NAME
  2. HIERARCHY_NAME

[top of page]

MTH.MTH_YEAR_ERR does not reference any database object

MTH.MTH_YEAR_ERR is referenced by following:

MTH
VIEW - MTH_YEAR_ERR#

[top of page]

Table: MTH_YEAR_STG

Description:

[top of page]

MTH.MTH_YEAR_STG does not reference any database object

MTH.MTH_YEAR_STG is referenced by following:

MTH
VIEW - MTH_YEAR_STG#

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract