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.
Description: | This table stores 445/544 period calendar |
---|
MTH.MTH_445_PERIOD_CALENDAR does not reference any database object
MTH.MTH_445_PERIOD_CALENDAR is referenced by following:
Description: |
---|
APPS.MTH_445_PERIOD_CAL_HOUR_MV does not reference any database object
APPS.MTH_445_PERIOD_CAL_HOUR_MV is referenced by following:
Description: |
---|
APPS.MTH_ALL_ENTITIES_MV does not reference any database object
APPS.MTH_ALL_ENTITIES_MV is referenced by following:
Description: | Error table for MTH_ASSET_MST |
---|
MTH.MTH_ASSET_ERR does not reference any database object
MTH.MTH_ASSET_ERR is referenced by following:
Description: | This table stores information about assets. It holds information like Asset Number, Asset Group, Maintenance Organization code and other asset attributes. |
---|
MTH.MTH_ASSET_MST does not reference any database object
MTH.MTH_ASSET_MST is referenced by following:
Description: |
---|
MTH.MTH_ASSET_STG does not reference any database object
MTH.MTH_ASSET_STG is referenced by following:
Description: | This table stores contextualization method setup for equipments |
---|
MTH.MTH_CONTEXTUALIZATION_METHOD does not reference any database object
MTH.MTH_CONTEXTUALIZATION_METHOD is referenced by following:
Description: | This table stores the contextualization rules setup for equipments |
---|
MTH.MTH_CONTEXTUALIZATION_REQ does not reference any database object
MTH.MTH_CONTEXTUALIZATION_REQ is referenced by following:
Description: | This table stores information on day level definition for time dimension. |
---|
MTH.MTH_DAY_D does not reference any database object
MTH.MTH_DAY_D is referenced by following:
Description: |
---|
MTH.MTH_DAY_STG does not reference any database object
MTH.MTH_DAY_STG is referenced by following:
Description: | Interface table for MTH_EQUIP_ENTITIES_MST |
---|
MTH.MTH_DEPT_ENTITIES_I_STG does not reference any database object
MTH.MTH_DEPT_ENTITIES_I_STG is referenced by following:
Description: | This table is the hierarchy master table for all dimensions. |
---|
MTH.MTH_DIM_HIERARCHY does not reference any database object
MTH.MTH_DIM_HIERARCHY is referenced by following:
Description: | Error table for MTH_DIM_HIERARCHY |
---|
MTH.MTH_DIM_HIERARCHY_ERR does not reference any database object
MTH.MTH_DIM_HIERARCHY_ERR is referenced by following:
Description: |
---|
MTH.MTH_DIM_HIERARCHY_STG does not reference any database object
MTH.MTH_DIM_HIERARCHY_STG is referenced by following:
Description: | This table stores the level information for the dimension hierarchies. It holds information on level number, level name and level type. |
---|
MTH.MTH_DIM_LEVEL_LOOKUP does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP is referenced by following:
Description: | Error table for MTH_DIM_LEVEL_LOOKUP |
---|
MTH.MTH_DIM_LEVEL_LOOKUP_ERR does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP_ERR is referenced by following:
Description: |
---|
MTH.MTH_DIM_LEVEL_LOOKUP_STG does not reference any database object
MTH.MTH_DIM_LEVEL_LOOKUP_STG is referenced by following:
Description: | This tables stores the pre-defined entities for Manufacturing Operations Center |
---|
MTH.MTH_ENTITIES does not reference any database object
MTH.MTH_ENTITIES is referenced by following:
Description: | This table will store time-series attributes for Equipment Entities. |
---|
MTH.MTH_ENTITY_ATTRIBUTES does not reference any database object
MTH.MTH_ENTITY_ATTRIBUTES is referenced by following:
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. |
---|
MTH.MTH_ENTITY_PLANNED_USAGE does not reference any database object
MTH.MTH_ENTITY_PLANNED_USAGE is referenced by following:
Description: |
---|
MTH.MTH_ENTITY_PLANNED_USAGE_ERR does not reference any database object
MTH.MTH_ENTITY_PLANNED_USAGE_ERR is referenced by following:
Description: |
---|
APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV does not reference any database object
APPS.MTH_ENTITY_PLANNED_USAGE_HR_MV is referenced by following:
Description: |
---|
APPS.MTH_ENTITY_PLANNED_USAGE_MV does not reference any database object
APPS.MTH_ENTITY_PLANNED_USAGE_MV is referenced by following:
Description: |
---|
APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV does not reference any database object
APPS.MTH_ENTITY_PLANNED_USAGE_SM_MV is referenced by following:
Description: |
---|
MTH.MTH_ENTITY_PLANNED_USAGE_STG does not reference any database object
MTH.MTH_ENTITY_PLANNED_USAGE_STG is referenced by following:
Description: | MTH_ENTITY_SUSTAIN_ASPECT is used to store entity sustainability aspect |
---|
MTH.MTH_ENTITY_SUSTAIN_ASPECT does not reference any database object
MTH.MTH_ENTITY_SUSTAIN_ASPECT is referenced by following:
Description: | MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour. |
---|
MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR does not reference any database object
MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR is referenced by following:
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. |
---|
MTH.MTH_ENTITY_SUST_EMISSIONS does not reference any database object
MTH.MTH_ENTITY_SUST_EMISSIONS is referenced by following:
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. |
---|
MTH.MTH_ENTITY_SUST_HR_EMISSIONS does not reference any database object
MTH.MTH_ENTITY_SUST_HR_EMISSIONS is referenced by following:
Description: | This table stores information about equipments. It holds information like Equipment name, Equipment description and Fixed asset value and Organization. |
---|
MTH.MTH_EQUIPMENTS_D does not reference any database object
MTH.MTH_EQUIPMENTS_D is referenced by following:
Description: | Error table for MTH_EQUIPMENTS_D |
---|
MTH.MTH_EQUIPMENTS_ERR does not reference any database object
MTH.MTH_EQUIPMENTS_ERR is referenced by following:
Description: | This table stores the extensible attributes for equipments |
---|
MTH.MTH_EQUIPMENTS_EXT_B does not reference any database object
MTH.MTH_EQUIPMENTS_EXT_B is referenced by following:
Description: | This table stores the translatable extensible attributes for Equipments |
---|
MTH.MTH_EQUIPMENTS_EXT_TL does not reference any database object
MTH.MTH_EQUIPMENTS_EXT_TL is referenced by following:
Description: |
---|
MTH.MTH_EQUIPMENTS_STG does not reference any database object
MTH.MTH_EQUIPMENTS_STG is referenced by following:
Description: | This table stores denormalized data for equipment hierarchy. |
---|
MTH.MTH_EQUIPMENT_DENORM_D does not reference any database object
MTH.MTH_EQUIPMENT_DENORM_D is referenced by following:
Description: | This table stores Reason code as well as the Expected Uptime for Equipments |
---|
MTH.MTH_EQUIPMENT_REASON_SETUP does not reference any database object
MTH.MTH_EQUIPMENT_REASON_SETUP is referenced by following:
Description: | Error table for MTH_EQUIPMENT_REASON_SETUP |
---|
MTH.MTH_EQUIPMENT_REASON_SETUP_ERR does not reference any database object
MTH.MTH_EQUIPMENT_REASON_SETUP_ERR is referenced by following:
Description: |
---|
MTH.MTH_EQUIPMENT_REASON_SETUP_STG does not reference any database object
MTH.MTH_EQUIPMENT_REASON_SETUP_STG is referenced by following:
Description: | This table stores shift information at equipment level. |
---|
MTH.MTH_EQUIPMENT_SHIFTS_D does not reference any database object
MTH.MTH_EQUIPMENT_SHIFTS_D is referenced by following:
Description: | Error table for MTH_EQUIPMENT_SHIFTS_D |
---|
MTH.MTH_EQUIPMENT_SHIFTS_ERR does not reference any database object
MTH.MTH_EQUIPMENT_SHIFTS_ERR is referenced by following:
Description: |
---|
MTH.MTH_EQUIPMENT_SHIFTS_STG does not reference any database object
MTH.MTH_EQUIPMENT_SHIFTS_STG is referenced by following:
Description: | Error table for MTH_EQUIP_ENTITIES_MST |
---|
MTH.MTH_EQUIP_ENTITIES_ERR does not reference any database object
MTH.MTH_EQUIP_ENTITIES_ERR is referenced by following:
Description: | This table stores the entity definitions for equipment dimension. It holds information on Entity name and Entity type. |
---|
MTH.MTH_EQUIP_ENTITIES_MST does not reference any database object
MTH.MTH_EQUIP_ENTITIES_MST is referenced by following:
Description: | Staging table for MTH_EQUIP_ENTITIES_MST |
---|
MTH.MTH_EQUIP_ENTITIES_STG does not reference any database object
MTH.MTH_EQUIP_ENTITIES_STG is referenced by following:
Description: | This table stores the history of parent - child relationship for equipment hierarchy. |
---|
MTH.MTH_EQUIP_HIERARCHY does not reference any database object
MTH.MTH_EQUIP_HIERARCHY is referenced by following:
Description: | Error table for MTH_EQUIPMENT_HIERARCHY |
---|
MTH.MTH_EQUIP_HIERARCHY_ERR does not reference any database object
MTH.MTH_EQUIP_HIERARCHY_ERR is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_HIERARCHY_STG does not reference any database object
MTH.MTH_EQUIP_HIERARCHY_STG is referenced by following:
Description: | This table stores the output information by reading time. It holds information on quantity completed, rejected, scrapped, reworked and good quantity. |
---|
MTH.MTH_EQUIP_OUTPUT does not reference any database object
MTH.MTH_EQUIP_OUTPUT is referenced by following:
Description: | Error table for MTH_EQUIP_OUTPUT |
---|
MTH.MTH_EQUIP_OUTPUT_ERR does not reference any database object
MTH.MTH_EQUIP_OUTPUT_ERR is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_OUTPUT_STG does not reference any database object
MTH.MTH_EQUIP_OUTPUT_STG is referenced by following:
Description: | This table stores summarized information on equipment output by quantity completed, rejected, scrapped, reworked and good quantity |
---|
MTH.MTH_EQUIP_OUTPUT_SUMMARY does not reference any database object
MTH.MTH_EQUIP_OUTPUT_SUMMARY is referenced by following:
Description: | Error table for MTH_EQUIP_PROD_PERFORMANCE_F |
---|
MTH.MTH_EQUIP_PROD_PERFORMANCE_ERR does not reference any database object
MTH.MTH_EQUIP_PROD_PERFORMANCE_ERR is referenced by following:
Description: | This table stores information on actual equipment production schedule for each work order at the shift and operations level. |
---|
MTH.MTH_EQUIP_PROD_PERFORMANCE_F does not reference any database object
MTH.MTH_EQUIP_PROD_PERFORMANCE_F is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_PROD_PERFORMANCE_STG does not reference any database object
MTH.MTH_EQUIP_PROD_PERFORMANCE_STG is referenced by following:
Description: | It contains similar information in equipment production performace with more granular status information. |
---|
MTH.MTH_EQUIP_PROD_PERF_DETAIL_F does not reference any database object
MTH.MTH_EQUIP_PROD_PERF_DETAIL_F is referenced by following:
Description: | Error table for MTH_EQUIP_PROD_SCHEDULE_F |
---|
MTH.MTH_EQUIP_PROD_SCHEDULE_ERR does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_ERR is referenced by following:
Description: | This table stores information on scheduled quantity on every equipment. It holds additional information on the work order and operation it is scheduled. |
---|
MTH.MTH_EQUIP_PROD_SCHEDULE_F does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_F is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_PROD_SCHEDULE_STG does not reference any database object
MTH.MTH_EQUIP_PROD_SCHEDULE_STG is referenced by following:
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. |
---|
MTH.MTH_EQUIP_PROD_SUSTAIN_F does not reference any database object
MTH.MTH_EQUIP_PROD_SUSTAIN_F is referenced by following:
Description: |
---|
APPS.MTH_EQUIP_SHFT_DD_MV does not reference any database object
APPS.MTH_EQUIP_SHFT_DD_MV is referenced by following:
Description: | Error table for MTH_EQUIP_STANDARD_RATES_F |
---|
MTH.MTH_EQUIP_STANDARD_RATES_ERR does not reference any database object
MTH.MTH_EQUIP_STANDARD_RATES_ERR is referenced by following:
Description: | This table stores information on standard production rates for equipments. |
---|
MTH.MTH_EQUIP_STANDARD_RATES_F does not reference any database object
MTH.MTH_EQUIP_STANDARD_RATES_F is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_STANDARD_RATES_STG does not reference any database object
MTH.MTH_EQUIP_STANDARD_RATES_STG is referenced by following:
Description: | This table stores information on equipment statuses |
---|
MTH.MTH_EQUIP_STATUSES does not reference any database object
MTH.MTH_EQUIP_STATUSES is referenced by following:
Description: | Error table for MTH_EQUIP_STATUSES |
---|
MTH.MTH_EQUIP_STATUSES_ERR does not reference any database object
MTH.MTH_EQUIP_STATUSES_ERR is referenced by following:
Description: |
---|
MTH.MTH_EQUIP_STATUSES_STG does not reference any database object
MTH.MTH_EQUIP_STATUSES_STG is referenced by following:
Description: | This table stores summarized information on equipment statuses by up time, down time, idle time and run time. |
---|
MTH.MTH_EQUIP_STATUS_SUMMARY does not reference any database object
MTH.MTH_EQUIP_STATUS_SUMMARY is referenced by following:
Description: | This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notification setup. |
---|
MTH.MTH_EVENTS does not reference any database object
MTH.MTH_EVENTS is referenced by following:
Description: | This table stores the event actions history. It holds information like Event Type, Event action and details of Event action taken. |
---|
MTH.MTH_EVENT_ACTIONS does not reference any database object
MTH.MTH_EVENT_ACTIONS is referenced by following:
Description: | This table stores information on Event Action setup for handling Events. It holds information like Event Type, Event action and Event notification setup. |
---|
MTH.MTH_EVENT_ACTION_SETUP does not reference any database object
MTH.MTH_EVENT_ACTION_SETUP is referenced by following:
Description: | Error table for MTH_EVENT_ACTION_SETUP |
---|
MTH.MTH_EVENT_ACTION_SETUP_ERR does not reference any database object
MTH.MTH_EVENT_ACTION_SETUP_ERR is referenced by following:
Description: |
---|
MTH.MTH_EVENT_ACTION_SETUP_STG does not reference any database object
MTH.MTH_EVENT_ACTION_SETUP_STG is referenced by following:
Description: | This table stores information on Event Action Setup for handling Events. It holds information like Equipment, Event Type and Reason. |
---|
MTH.MTH_EVENT_SETUP does not reference any database object
MTH.MTH_EVENT_SETUP is referenced by following:
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 |
---|
MTH.MTH_EXT_ATTR_ERR does not reference any database object
MTH.MTH_EXT_ATTR_ERR is referenced by following:
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 |
---|
MTH.MTH_EXT_ATTR_I_STG does not reference any database object
MTH.MTH_EXT_ATTR_I_STG is referenced by following:
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 |
---|
MTH.MTH_EXT_ATTR_T_STG does not reference any database object
MTH.MTH_EXT_ATTR_T_STG is referenced by following:
Description: | This table stores gregorian calendar |
---|
MTH.MTH_GREGORIAN_CALENDAR does not reference any database object
MTH.MTH_GREGORIAN_CALENDAR is referenced by following:
Description: | MTH_HOUR_D will store the hourly time buckets for each day generated in the calendar. |
---|
MTH.MTH_HOUR_D does not reference any database object
MTH.MTH_HOUR_D is referenced by following:
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. |
---|
MTH.MTH_ITEMS_D does not reference any database object
MTH.MTH_ITEMS_D is referenced by following:
Description: | Error table for MTH_ITEMS_D |
---|
MTH.MTH_ITEMS_ERR does not reference any database object
MTH.MTH_ITEMS_ERR is referenced by following:
Description: | This table stores the extensible attributes for items |
---|
MTH.MTH_ITEMS_EXT_B does not reference any database object
MTH.MTH_ITEMS_EXT_B is referenced by following:
Description: | This table stores the translatable extensible attributes for Items |
---|
MTH.MTH_ITEMS_EXT_TL does not reference any database object
MTH.MTH_ITEMS_EXT_TL is referenced by following:
Description: | Interface table for MTH_ITEMS_D |
---|
MTH.MTH_ITEMS_I_STG does not reference any database object
MTH.MTH_ITEMS_I_STG is referenced by following:
Description: |
---|
MTH.MTH_ITEMS_STG does not reference any database object
MTH.MTH_ITEMS_STG is referenced by following:
Description: | This table stores information on Item Categories. |
---|
MTH.MTH_ITEM_CATEGORIES_D does not reference any database object
MTH.MTH_ITEM_CATEGORIES_D is referenced by following:
Description: | Interface table for MTH_ITEM_CATEGORIES_D |
---|
MTH.MTH_ITEM_CATEGORIES_I_STG does not reference any database object
MTH.MTH_ITEM_CATEGORIES_I_STG is referenced by following:
Description: | Staging table for MTH_ITEM_CATEGORIES_D |
---|
MTH.MTH_ITEM_CATEGORIES_STG does not reference any database object
MTH.MTH_ITEM_CATEGORIES_STG is referenced by following:
Description: | This table stores the information about item cost history. It holds information on item cost for every cost element of the item. |
---|
MTH.MTH_ITEM_COST does not reference any database object
MTH.MTH_ITEM_COST is referenced by following:
Description: | Error table for MTH_ITEMS_COST |
---|
MTH.MTH_ITEM_COST_ERR does not reference any database object
MTH.MTH_ITEM_COST_ERR is referenced by following:
Description: | Interface table for MTH_ITEM_COST |
---|
MTH.MTH_ITEM_COST_I_STG does not reference any database object
MTH.MTH_ITEM_COST_I_STG is referenced by following:
Description: |
---|
MTH.MTH_ITEM_COST_STG does not reference any database object
MTH.MTH_ITEM_COST_STG is referenced by following:
Description: | This table stores denormalized data for item hierarchy. |
---|
MTH.MTH_ITEM_DENORM_D does not reference any database object
MTH.MTH_ITEM_DENORM_D is referenced by following:
Description: |
---|
MTH.MTH_ITEM_DENORM_D_TMP does not reference any database object
MTH.MTH_ITEM_DENORM_D_TMP is referenced by following:
Description: | This table stores the latest parent - child relationship for item hierarchy. |
---|
MTH.MTH_ITEM_HIERARCHY does not reference any database object
MTH.MTH_ITEM_HIERARCHY is referenced by following:
Description: | Error table for MTH_ITEM_HIERARCHY |
---|
MTH.MTH_ITEM_HIERARCHY_ERR does not reference any database object
MTH.MTH_ITEM_HIERARCHY_ERR is referenced by following:
Description: | Interface table for MTH_ITEM_HIERARCHY |
---|
MTH.MTH_ITEM_HIERARCHY_I_STG does not reference any database object
MTH.MTH_ITEM_HIERARCHY_I_STG is referenced by following:
Description: |
---|
MTH.MTH_ITEM_HIERARCHY_STG does not reference any database object
MTH.MTH_ITEM_HIERARCHY_STG is referenced by following:
Description: | This table stores the lookup code along with the context. |
---|
MTH.MTH_LOOKUPS_D does not reference any database object
MTH.MTH_LOOKUPS_D is referenced by following:
Description: | This table stores information related to Manufacturing Operations Center instance and its attributes . |
---|
MTH.MTH_MASTER_SETUP does not reference any database object
MTH.MTH_MASTER_SETUP is referenced by following:
Description: | This table defines actual and virtual meter definition |
---|
MTH.MTH_METERS does not reference any database object
MTH.MTH_METERS is referenced by following:
Description: | This table defines the association between entities and meter. |
---|
MTH.MTH_METER_ENTITIES does not reference any database object
MTH.MTH_METER_ENTITIES is referenced by following:
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 |
---|
MTH.MTH_METER_READINGS does not reference any database object
MTH.MTH_METER_READINGS is referenced by following:
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. |
---|
MTH.MTH_METER_READINGS_ERR does not reference any database object
MTH.MTH_METER_READINGS_ERR is referenced by following:
Description: |
---|
MTH.MTH_METER_READINGS_STG does not reference any database object
MTH.MTH_METER_READINGS_STG is referenced by following:
Description: | Error table for MTH_MTL_CONSUMED_TXN_LOT_F |
---|
MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_ERR is referenced by following:
Description: | This table stores the lot, sub-lot and serial number level information for both the product and components used |
---|
MTH.MTH_MTL_CONSUMED_TXN_LOT_F does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_F is referenced by following:
Description: |
---|
MTH.MTH_MTL_CONSUMED_TXN_LOT_STG does not reference any database object
MTH.MTH_MTL_CONSUMED_TXN_LOT_STG is referenced by following:
Description: | Error table for MTH_MTL_PRODUCED_TXN_LOT_F |
---|
MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_ERR is referenced by following:
Description: | This table stores the lot, sub-lot and serial number level information for the products manufactured |
---|
MTH.MTH_MTL_PRODUCED_TXN_LOT_F does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_F is referenced by following:
Description: |
---|
MTH.MTH_MTL_PRODUCED_TXN_LOT_STG does not reference any database object
MTH.MTH_MTL_PRODUCED_TXN_LOT_STG is referenced by following:
Description: |
---|
MTH.MTH_OPEN_SALES_ORDERS_F does not reference any database object
MTH.MTH_OPEN_SALES_ORDERS_F is referenced by following:
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. |
---|
MTH.MTH_ORGANIZATIONS_L does not reference any database object
MTH.MTH_ORGANIZATIONS_L is referenced by following:
Description: | This table stores classifications for "Others" entity |
---|
MTH.MTH_OTHERS_D does not reference any database object
MTH.MTH_OTHERS_D is referenced by following:
Description: | This table stores the extensible attributes for OTHERS entity |
---|
MTH.MTH_OTHERS_EXT_B does not reference any database object
MTH.MTH_OTHERS_EXT_B is referenced by following:
Description: | This table stores the translatable extensible attributes for OTHERS entity |
---|
MTH.MTH_OTHERS_EXT_TL does not reference any database object
MTH.MTH_OTHERS_EXT_TL is referenced by following:
Description: | This table stores information on period level definition for time dimension hierarchies. |
---|
MTH.MTH_PERIOD_D does not reference any database object
MTH.MTH_PERIOD_D is referenced by following:
Description: | Error table for MTH_PERIOD_D |
---|
MTH.MTH_PERIOD_ERR does not reference any database object
MTH.MTH_PERIOD_ERR is referenced by following:
Description: |
---|
MTH.MTH_PERIOD_STG does not reference any database object
MTH.MTH_PERIOD_STG is referenced by following:
Description: | This table stores information about personnel. It holds information like First name, Last name, Resource and Organization. |
---|
MTH.MTH_PERSONNEL_D does not reference any database object
MTH.MTH_PERSONNEL_D is referenced by following:
Description: | Error table for MTH_PERSONNEL_D |
---|
MTH.MTH_PERSONNEL_ERR does not reference any database object
MTH.MTH_PERSONNEL_ERR is referenced by following:
Description: |
---|
MTH.MTH_PERSONNEL_STG does not reference any database object
MTH.MTH_PERSONNEL_STG is referenced by following:
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. |
---|
MTH.MTH_PLANTS_D does not reference any database object
MTH.MTH_PLANTS_D is referenced by following:
Description: | This table will be used to store the error rows when loading data from the staging table to MTH_PLANTS_D table. |
---|
MTH.MTH_PLANTS_ERR does not reference any database object
MTH.MTH_PLANTS_ERR is referenced by following:
Description: | This table will be used to as staging table to load the plants data from CSV |
---|
MTH.MTH_PLANTS_STG does not reference any database object
MTH.MTH_PLANTS_STG is referenced by following:
Description: | This table will store time-series attributes for Site. |
---|
MTH.MTH_PLANT_ATTRIBUTES does not reference any database object
MTH.MTH_PLANT_ATTRIBUTES is referenced by following:
Description: | Error table for MTH_PRODUCTION_SCHEDULES_F |
---|
MTH.MTH_PRODUCTION_SCHEDULES_ERR does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_ERR is referenced by following:
Description: | This table stores the extensible attributes for Work Orders |
---|
MTH.MTH_PRODUCTION_SCHEDULES_EXT_B does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_EXT_B is referenced by following:
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 |
---|
MTH.MTH_PRODUCTION_SCHEDULES_F does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_F is referenced by following:
Description: | Interface table for MTH_PRODUCTION_SCHEDULES_F |
---|
MTH.MTH_PRODUCTION_SCHEDULES_I_STG does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_I_STG is referenced by following:
Description: |
---|
MTH.MTH_PRODUCTION_SCHEDULES_STG does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULES_STG is referenced by following:
Description: | This table stores the translatable extensible attributes for Work Orders |
---|
MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL does not reference any database object
MTH.MTH_PRODUCTION_SCHEDULE_EXT_TL is referenced by following:
Description: | Error Table for MTH_PRODUCTION_SEGMENTS_F |
---|
MTH.MTH_PRODUCTION_SEGMENTS_ERR does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_ERR is referenced by following:
Description: | This table stores external attributes data for Workorder Segments |
---|
MTH.MTH_PRODUCTION_SEGMENTS_EXT_B does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_EXT_B is referenced by following:
Description: | This table stores the translatable extensible attributes for Workorder Segments |
---|
MTH.MTH_PRODUCTION_SEGMENTS_EXT_TL does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_EXT_TL is referenced by following:
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. |
---|
MTH.MTH_PRODUCTION_SEGMENTS_F does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_F is referenced by following:
Description: |
---|
MTH.MTH_PRODUCTION_SEGMENTS_STG does not reference any database object
MTH.MTH_PRODUCTION_SEGMENTS_STG is referenced by following:
Description: | Error table for MTH_PROD_MTL_CONSUMED_F |
---|
MTH.MTH_PROD_MTL_CONSUMED_ERR does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_ERR is referenced by following:
Description: | This table stores the information on planned and actual usage quantities for components |
---|
MTH.MTH_PROD_MTL_CONSUMED_F does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_F is referenced by following:
Description: |
---|
MTH.MTH_PROD_MTL_CONSUMED_STG does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_STG is referenced by following:
Description: | Error table for MTH_PROD_MTL_CONSUMED_TXN_F |
---|
MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_ERR is referenced by following:
Description: | This table stores the information on transactions that consume the component material at the operation level of the work orders |
---|
MTH.MTH_PROD_MTL_CONSUMED_TXN_F does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_F is referenced by following:
Description: |
---|
MTH.MTH_PROD_MTL_CONSUMED_TXN_STG does not reference any database object
MTH.MTH_PROD_MTL_CONSUMED_TXN_STG is referenced by following:
Description: | Error table for MTH_PROD_MTL_PRODUCED_F |
---|
MTH.MTH_PROD_MTL_PRODUCED_ERR does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_ERR is referenced by following:
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 |
---|
MTH.MTH_PROD_MTL_PRODUCED_F does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_F is referenced by following:
Description: | Interface table for MTH_PROD_MTL_PRODUCED_F |
---|
MTH.MTH_PROD_MTL_PRODUCED_I_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_I_STG is referenced by following:
Description: |
---|
MTH.MTH_PROD_MTL_PRODUCED_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_STG is referenced by following:
Description: | Error table for MTH_PROD_MTL_PRODUCED_TXN_F |
---|
MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_ERR is referenced by following:
Description: | This table stores information on assembly completion transactions at the operation level of the work orders |
---|
MTH.MTH_PROD_MTL_PRODUCED_TXN_F does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_F is referenced by following:
Description: |
---|
MTH.MTH_PROD_MTL_PRODUCED_TXN_STG does not reference any database object
MTH.MTH_PROD_MTL_PRODUCED_TXN_STG is referenced by following:
Description: | Error table for MTH_PROD_SEGMENTS_TXN_F |
---|
MTH.MTH_PROD_SEGMENTS_TXN_ERR does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_ERR is referenced by following:
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 |
---|
MTH.MTH_PROD_SEGMENTS_TXN_F does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_F is referenced by following:
Description: |
---|
MTH.MTH_PROD_SEGMENTS_TXN_STG does not reference any database object
MTH.MTH_PROD_SEGMENTS_TXN_STG is referenced by following:
Description: | Error table for MTH_PROD_SUB_SEGMENTS_STG |
---|
MTH.MTH_PROD_SUB_SEGMENTS_ERR does not reference any database object
MTH.MTH_PROD_SUB_SEGMENTS_ERR is referenced by following:
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. |
---|
MTH.MTH_PROD_SUB_SEGMENTS_F does not reference any database object
MTH.MTH_PROD_SUB_SEGMENTS_F is referenced by following:
Description: |
---|
MTH.MTH_PROD_SUB_SEGMENTS_STG does not reference any database object
MTH.MTH_PROD_SUB_SEGMENTS_STG is referenced by following:
Description: | This table stores information on quarter level definition for time dimension hierarchies. |
---|
MTH.MTH_QUARTER_D does not reference any database object
MTH.MTH_QUARTER_D is referenced by following:
Description: | Error table for MTH_QUARTER_D |
---|
MTH.MTH_QUARTER_ERR does not reference any database object
MTH.MTH_QUARTER_ERR is referenced by following:
Description: |
---|
MTH.MTH_QUARTER_STG does not reference any database object
MTH.MTH_QUARTER_STG is referenced by following:
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 |
---|
MTH.MTH_RESOURCES_D does not reference any database object
MTH.MTH_RESOURCES_D is referenced by following:
Description: | Error table for MTH_RESOURCES_D |
---|
MTH.MTH_RESOURCES_ERR does not reference any database object
MTH.MTH_RESOURCES_ERR is referenced by following:
Description: | Interface table for MTH_RESOURCES_D |
---|
MTH.MTH_RESOURCES_I_STG does not reference any database object
MTH.MTH_RESOURCES_I_STG is referenced by following:
Description: |
---|
MTH.MTH_RESOURCES_STG does not reference any database object
MTH.MTH_RESOURCES_STG is referenced by following:
Description: | This table stores the information about resource cost history. It holds information on resource cost for every cost element of the resource. |
---|
MTH.MTH_RESOURCE_COST does not reference any database object
MTH.MTH_RESOURCE_COST is referenced by following:
Description: | Error table for MTH_RESOURCE_COST |
---|
MTH.MTH_RESOURCE_COST_ERR does not reference any database object
MTH.MTH_RESOURCE_COST_ERR is referenced by following:
Description: | Interface table for MTH_RESOURCE_COST |
---|
MTH.MTH_RESOURCE_COST_I_STG does not reference any database object
MTH.MTH_RESOURCE_COST_I_STG is referenced by following:
Description: |
---|
MTH.MTH_RESOURCE_COST_STG does not reference any database object
MTH.MTH_RESOURCE_COST_STG is referenced by following:
Description: | Error table for MTH_RESOURCE_REQUIREMENTS_F |
---|
MTH.MTH_RESOURCE_REQUIREMENTS_ERR does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_ERR is referenced by following:
Description: | This table stores information on planned resource usages at each operation level on the work order |
---|
MTH.MTH_RESOURCE_REQUIREMENTS_F does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_F is referenced by following:
Description: |
---|
MTH.MTH_RESOURCE_REQUIREMENTS_STG does not reference any database object
MTH.MTH_RESOURCE_REQUIREMENTS_STG is referenced by following:
Description: | Error table for MTH_RESOURCE_TXN_F |
---|
MTH.MTH_RESOURCE_TXN_ERR does not reference any database object
MTH.MTH_RESOURCE_TXN_ERR is referenced by following:
Description: | This table stores information on actual resource usages at each operation level on the work order |
---|
MTH.MTH_RESOURCE_TXN_F does not reference any database object
MTH.MTH_RESOURCE_TXN_F is referenced by following:
Description: |
---|
MTH.MTH_RESOURCE_TXN_STG does not reference any database object
MTH.MTH_RESOURCE_TXN_STG is referenced by following:
Description: | Interface table for MTH_EQUIP_ENTITIES_MST |
---|
MTH.MTH_RES_GRP_ENTITIES_I_STG does not reference any database object
MTH.MTH_RES_GRP_ENTITIES_I_STG is referenced by following:
Description: | MTH_RUNTIME_ERR stores errors happened during run time. |
---|
MTH.MTH_RUNTIME_ERR does not reference any database object
MTH.MTH_RUNTIME_ERR is referenced by following:
Description: | Log table for internal processing |
---|
MTH.MTH_RUN_LOG does not reference any database object
MTH.MTH_RUN_LOG is referenced by following:
Description: |
---|
APPS.MTH_SHIFT_REFERENCE_MV does not reference any database object
APPS.MTH_SHIFT_REFERENCE_MV is referenced by following:
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 |
---|
MTH.MTH_SITE_SHIFT_DEFINITIONS does not reference any database object
MTH.MTH_SITE_SHIFT_DEFINITIONS is referenced by following:
Description: | MTH_SITE_SUSTAINABILITIES stores the sustainability aspect setup information for each site. |
---|
MTH.MTH_SITE_SUSTAINABILITIES does not reference any database object
MTH.MTH_SITE_SUSTAINABILITIES is referenced by following:
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. |
---|
MTH.MTH_SITE_SUSTAIN_SOURCES does not reference any database object
MTH.MTH_SITE_SUSTAIN_SOURCES is referenced by following:
Description: | MTH_SOURCE_EMISSION_FACTORS is a child table of MTH_SITE_SUSTAIN_SOURCES. |
---|
MTH.MTH_SOURCE_EMISSION_FACTORS does not reference any database object
MTH.MTH_SOURCE_EMISSION_FACTORS is referenced by following:
Description: | This table stores the information for Sustainability Aspects. |
---|
MTH.MTH_SUSTAIN_ASPECTS does not reference any database object
MTH.MTH_SUSTAIN_ASPECTS is referenced by following:
Description: | MTH_SUSTAIN_EMISSION is a child table of MTH_SUSTAIN_ASPECTS |
---|
MTH.MTH_SUSTAIN_EMISSIONS does not reference any database object
MTH.MTH_SUSTAIN_EMISSIONS is referenced by following:
Description: | MTH_SUSTAIN_USAGE is a child table of MTH_SUSTAIN_ASPECTS |
---|
MTH.MTH_SUSTAIN_USAGES does not reference any database object
MTH.MTH_SUSTAIN_USAGES is referenced by following:
Description: | This table stores information related to MOC source systems and their attributes. |
---|
MTH.MTH_SYSTEMS_SETUP does not reference any database object
MTH.MTH_SYSTEMS_SETUP is referenced by following:
Description: | This table defines the sources for tag |
---|
MTH.MTH_TAG_DATA_SOURCES does not reference any database object
MTH.MTH_TAG_DATA_SOURCES is referenced by following:
Description: | This is error table for MTH_TAG_DATA_SOURCES table |
---|
MTH.MTH_TAG_DATA_SOURCES_ERR does not reference any database object
MTH.MTH_TAG_DATA_SOURCES_ERR is referenced by following:
Description: |
---|
MTH.MTH_TAG_DATA_SOURCES_STG does not reference any database object
MTH.MTH_TAG_DATA_SOURCES_STG is referenced by following:
Description: | This table stores details on tag target entities |
---|
MTH.MTH_TAG_DESTINATION_MAP does not reference any database object
MTH.MTH_TAG_DESTINATION_MAP is referenced by following:
Description: | This table stores tag master information |
---|
MTH.MTH_TAG_MASTER does not reference any database object
MTH.MTH_TAG_MASTER is referenced by following:
Description: | This table stores tag master information |
---|
MTH.MTH_TAG_MASTER_ERR does not reference any database object
MTH.MTH_TAG_MASTER_ERR is referenced by following:
Description: |
---|
MTH.MTH_TAG_MASTER_STG does not reference any database object
MTH.MTH_TAG_MASTER_STG is referenced by following:
Description: | This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_METER_READINGS_RAW |
---|
MTH.MTH_TAG_METER_READINGS_LATEST does not reference any database object
MTH.MTH_TAG_METER_READINGS_LATEST is referenced by following:
Description: |
---|
MTH.MTH_TAG_METER_READINGS_RAW does not reference any database object
MTH.MTH_TAG_METER_READINGS_RAW is referenced by following:
Description: | This table contains the Manufacturing Operations Center processed tag data |
---|
MTH.MTH_TAG_READINGS does not reference any database object
MTH.MTH_TAG_READINGS is referenced by following:
Description: | Error table for MTH_TAG_READINGS |
---|
MTH.MTH_TAG_READINGS_ERR does not reference any database object
MTH.MTH_TAG_READINGS_ERR is referenced by following:
Description: | This table is used internally to keep the latest cumulative values for tags appeared in MTH_TAG_READINGS_RAW |
---|
MTH.MTH_TAG_READINGS_LATEST does not reference any database object
MTH.MTH_TAG_READINGS_LATEST is referenced by following:
Description: | This table contains the unprocessed tag data collected from PLCs |
---|
MTH.MTH_TAG_READINGS_RAW does not reference any database object
MTH.MTH_TAG_READINGS_RAW is referenced by following:
Description: | Error table for MTH_TAG_READINGS_RAW |
---|
MTH.MTH_TAG_READINGS_RAW_ERR does not reference any database object
MTH.MTH_TAG_READINGS_RAW_ERR is referenced by following:
Description: | This table contains the tag data collected from PLCs after applying cumulative logic |
---|
MTH.MTH_TAG_READINGS_RAW_PROCESSED does not reference any database object
MTH.MTH_TAG_READINGS_RAW_PROCESSED is referenced by following:
Description: | Staging table for MTH_TAG_READINGS |
---|
MTH.MTH_TAG_READINGS_STG does not reference any database object
MTH.MTH_TAG_READINGS_STG is referenced by following:
Description: | Error table for MTH_TAG_READINGS_STG |
---|
MTH.MTH_TAG_READINGS_STG_ERR does not reference any database object
MTH.MTH_TAG_READINGS_STG_ERR is referenced by following:
Description: | Staging table to move device data in MTH_EQUIPMENTS_EXT_B |
---|
MTH.MTH_TAG_READINGS_T_STG does not reference any database object
MTH.MTH_TAG_READINGS_T_STG is referenced by following:
Description: | Error table for MTH_TAG_READINGS_RAW |
---|
MTH.MTH_TAG_READINGS_UNPROCESS_ERR does not reference any database object
MTH.MTH_TAG_READINGS_UNPROCESS_ERR is referenced by following:
Description: | This table stores reasons for downtime and scrap |
---|
MTH.MTH_TAG_REASON_READINGS does not reference any database object
MTH.MTH_TAG_REASON_READINGS is referenced by following:
Description: | This table stores the latest parent - child relationship for time hierarchy. |
---|
MTH.MTH_TIME_HIERARCHY does not reference any database object
MTH.MTH_TIME_HIERARCHY is referenced by following:
Description: | Error table for MTH_TIME_HIERARCHY |
---|
MTH.MTH_TIME_HIERARCHY_ERR does not reference any database object
MTH.MTH_TIME_HIERARCHY_ERR is referenced by following:
Description: |
---|
MTH.MTH_TIME_HIERARCHY_STG does not reference any database object
MTH.MTH_TIME_HIERARCHY_STG is referenced by following:
Description: | This table is using to store seeding data for translation |
---|
MTH.MTH_TRANSLATED_MESSAGE does not reference any database object
MTH.MTH_TRANSLATED_MESSAGE is referenced by following:
Description: | Error table for MTH_USER_DIM_ENTITIES |
---|
MTH.MTH_USER_DIM_ENTITIES_ERR does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_ERR is referenced by following:
Description: | This table stores the entity definitions for user-defined dimensions. It holds information on Entity name and Entity type. |
---|
MTH.MTH_USER_DIM_ENTITIES_MST does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_MST is referenced by following:
Description: |
---|
MTH.MTH_USER_DIM_ENTITIES_STG does not reference any database object
MTH.MTH_USER_DIM_ENTITIES_STG is referenced by following:
Description: | This table stores the latest parent-child hierarchy relationship for user-defined hierarchies. |
---|
MTH.MTH_USER_DIM_HIERARCHY does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY is referenced by following:
Description: | Error table for MTH_USER_DIM_HIERARCHY |
---|
MTH.MTH_USER_DIM_HIERARCHY_ERR does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY_ERR is referenced by following:
Description: |
---|
MTH.MTH_USER_DIM_HIERARCHY_STG does not reference any database object
MTH.MTH_USER_DIM_HIERARCHY_STG is referenced by following:
Description: | This table stores the extensible attributes for User-Defined Entities,Resource and Site |
---|
MTH.MTH_USER_ENTITIES_EXT_B does not reference any database object
MTH.MTH_USER_ENTITIES_EXT_B is referenced by following:
Description: | This table stores the translatable extensible attributes for User-Defined Entities,Resource and Site |
---|
MTH.MTH_USER_ENTITIES_EXT_TL does not reference any database object
MTH.MTH_USER_ENTITIES_EXT_TL is referenced by following:
Description: | This table defines required componets for formula in order to calculate the energy consumption. |
---|
MTH.MTH_VIRTUAL_METER_COMPONENTS does not reference any database object
MTH.MTH_VIRTUAL_METER_COMPONENTS is referenced by following:
Description: | This table stores information on week level definition for time dimension hierarchies. |
---|
MTH.MTH_WEEK_D does not reference any database object
MTH.MTH_WEEK_D is referenced by following:
Description: | Error table for MTH_WEEK_D |
---|
MTH.MTH_WEEK_ERR does not reference any database object
MTH.MTH_WEEK_ERR is referenced by following:
Description: |
---|
MTH.MTH_WEEK_STG does not reference any database object
MTH.MTH_WEEK_STG is referenced by following:
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. |
---|
MTH.MTH_WORKDAY_SHIFTS_D does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_D is referenced by following:
Description: | Interface table for MTH_WORKDAY_SHIFTS_D |
---|
MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_DIS_I_STG is referenced by following:
Description: | Error table for MTH_WORKDAY_SHIFTS_D |
---|
MTH.MTH_WORKDAY_SHIFTS_ERR does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_ERR is referenced by following:
Description: |
---|
MTH.MTH_WORKDAY_SHIFTS_STG does not reference any database object
MTH.MTH_WORKDAY_SHIFTS_STG is referenced by following:
Description: | Error table for MTH_WO_SALES_ORDERS_F |
---|
MTH.MTH_WO_SALES_ORDERS_ERR does not reference any database object
MTH.MTH_WO_SALES_ORDERS_ERR is referenced by following:
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 |
---|
MTH.MTH_WO_SALES_ORDERS_F does not reference any database object
MTH.MTH_WO_SALES_ORDERS_F is referenced by following:
Description: | Interface table for MTH_WO_SALES_ORDERS_F |
---|
MTH.MTH_WO_SALES_ORDERS_I_STG does not reference any database object
MTH.MTH_WO_SALES_ORDERS_I_STG is referenced by following:
Description: |
---|
MTH.MTH_WO_SALES_ORDERS_STG does not reference any database object
MTH.MTH_WO_SALES_ORDERS_STG is referenced by following:
Description: | This table stores information on year level definition for time dimension hierarchies. |
---|
MTH.MTH_YEAR_D does not reference any database object
MTH.MTH_YEAR_D is referenced by following:
Description: | Error table for MTH_YEAR_D |
---|
MTH.MTH_YEAR_ERR does not reference any database object
MTH.MTH_YEAR_ERR is referenced by following:
Description: |
---|
MTH.MTH_YEAR_STG does not reference any database object
MTH.MTH_YEAR_STG is referenced by following:
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |