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 - EAM Tables and Views

TABLE - EAM.EAM_ASSET_EXPLOSION_TEMP
TABLE - EAM.EAM_ASSET_FAILURES
TABLE - EAM.EAM_ASSET_FAILURE_CODES
TABLE - EAM.EAM_ASSET_LOG
TABLE - EAM.EAM_ASSET_METERS
TABLE - EAM.EAM_ASSET_MOVE_TEMP
TABLE - EAM.EAM_ASSET_OPERATION_TXN
TABLE - EAM.EAM_ASSET_RESULTS_GTT
TABLE - EAM.EAM_ASSET_SAFETY_TYPES
TABLE - EAM.EAM_ASSET_STATUS_HISTORY
TABLE - EAM.EAM_ASSET_TEXT
TABLE - EAM.EAM_CAUSE_CODES
TABLE - EAM.EAM_CE_WORK_ORDER_LINES
TABLE - EAM.EAM_CONSTRUCTION_ESTIMATES
TABLE - EAM.EAM_CONSTRUCTION_UNITS
TABLE - EAM.EAM_CONSTRUCTION_UNIT_DETAILS
TABLE - EAM.EAM_CONTROL_EVENT
TABLE - EAM.EAM_DIFFICULTY_CODES
TABLE - EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL
TABLE - EAM.EAM_EMP_SEARCH_RESULT_TBL
TABLE - EAM.EAM_ENABLE_WORKFLOW
TABLE - EAM.EAM_ESTABLISHMENT_DETAILS
TABLE - EAM.EAM_ESTIMATE_ASSOCIATIONS
TABLE - EAM.EAM_FAILURE_CODES
TABLE - EAM.EAM_FAILURE_COMBINATIONS
TABLE - EAM.EAM_FAILURE_HISTORY_TEMP
TABLE - EAM.EAM_FAILURE_SETS
TABLE - EAM.EAM_FAILURE_SET_ASSOCIATIONS
TABLE - EAM.EAM_FORECASTED_WORK_ORDERS
TABLE - EAM.EAM_FORECASTS
TABLE - EAM.EAM_FORECAST_CEBBA
TABLE - EAM.EAM_FORECAST_WDJ
TABLE - EAM.EAM_FORECAST_WEDI
TABLE - EAM.EAM_FORECAST_WO
TABLE - EAM.EAM_FORECAST_WOR
TABLE - EAM.EAM_FORECAST_WRO
TABLE - EAM.EAM_ISOLATIONS
TABLE - EAM.EAM_JOB_COMPLETION_TXNS
TABLE - EAM.EAM_LINEAR_LOCATIONS
TABLE - EAM.EAM_MATERIAL_IMPORT
TABLE - EAM.EAM_METERS
TABLE - EAM.EAM_METER_READINGS
TABLE - EAM.EAM_METER_READINGS_INTERFACE
TABLE - EAM.EAM_OPERATION_IMPORT
TABLE - EAM.EAM_OP_COMPLETION_TXNS
TABLE - EAM.EAM_ORG_MAINT_DEFAULTS
TABLE - EAM.EAM_PM_ACTIVITIES
TABLE - EAM.EAM_PM_LAST_SERVICE
TABLE - EAM.EAM_PM_SCHEDULINGS
TABLE - EAM.EAM_PM_SCHEDULING_RULES
TABLE - EAM.EAM_PM_SET_NAMES
TABLE - EAM.EAM_RESOLUTION_CODES
TABLE - EAM.EAM_RESOURCE_IMPORT
TABLE - EAM.EAM_RESOURCE_INSTANCE_IMPORT
TABLE - EAM.EAM_RESOURCE_USAGE_IMPORT
TABLE - EAM.EAM_SAFETY_ASSOCIATIONS
TABLE - EAM.EAM_SAFETY_HISTORY
TABLE - EAM.EAM_SAFETY_USR_DEF_STATUSES_B
TABLE - EAM.EAM_SAFETY_USR_DEF_STATUSES_TL
TABLE - EAM.EAM_SAFETY_WORKFLOWS
TABLE - EAM.EAM_SUPPRESSION_RELATIONS
TABLE - EAM.EAM_WOREP_LONG_ATTACH_TEMP
TABLE - EAM.EAM_WORK_CLEARANCES
TABLE - EAM.EAM_WORK_ORDER_BILLS
TABLE - EAM.EAM_WORK_ORDER_DETAILS
TABLE - EAM.EAM_WORK_ORDER_IMPORT
TABLE - EAM.EAM_WORK_ORDER_IMPORT_ERRORS
TABLE - EAM.EAM_WORK_ORDER_ROUTE
TABLE - EAM.EAM_WORK_ORDER_TEXT
TABLE - EAM.EAM_WORK_PERMITS
TABLE - EAM.EAM_WO_RELATIONSHIPS
TABLE - EAM.EAM_WO_SERVICE_ASSOCIATION
TABLE - EAM.EAM_WO_STATUSES_B
TABLE - EAM.EAM_WO_STATUSES_TL
TABLE - EAM.EAM_WO_WORKFLOWS
VIEW - APPS.EAM_ASSET_METERS_V
VIEW - APPS.EAM_BILL_BY_ACTIVITIES_V
VIEW - APPS.EAM_BILL_BY_REQUIREMENTS_V
VIEW - APPS.EAM_CAPT_BILL_BY_REQ_V
VIEW - APPS.EAM_CFR_COUNTER_READINGS_V
VIEW - APPS.EAM_CFR_ISSUED_SERIALS_V
VIEW - APPS.EAM_CFR_MATERIALS_V
VIEW - APPS.EAM_CFR_OPERATIONS_V
VIEW - APPS.EAM_CFR_QA_PLANS_V
VIEW - APPS.EAM_CFR_RESOURCES_V
VIEW - APPS.EAM_CFR_WORK_COMPLETION_V
VIEW - APPS.EAM_CFR_WORK_ORDER_V
VIEW - APPS.EAM_CHECKED_OUT_ASSETS_V
VIEW - APPS.EAM_CONTROL_EVENT_V
VIEW - APPS.EAM_COUNTERS_V
VIEW - APPS.EAM_DIRECT_ITEMS_RECS_LITE_V
VIEW - APPS.EAM_DIRECT_ITEMS_V
VIEW - APPS.EAM_DIRECT_ITEM_RECS_V
VIEW - APPS.EAM_FAILUREINFO_V
VIEW - APPS.EAM_FAILURE_CODES_V
VIEW - APPS.EAM_FAILURE_COMBINATIONS_V
VIEW - APPS.EAM_FAILURE_SET_ASSOCIATIONS_V
VIEW - APPS.EAM_FORECAST_WORK_ORDER_V
VIEW - APPS.EAM_INSTANCES
VIEW - APPS.EAM_ISOLATION_STATUSES_VL
VIEW - APPS.EAM_MANAGE_REQS_V
VIEW - APPS.EAM_MATERIALS_V
VIEW - APPS.EAM_METER_READINGS_INTERFACE_V
VIEW - APPS.EAM_METER_READINGS_V
VIEW - APPS.EAM_NEXT_OPERATIONS_V
VIEW - APPS.EAM_OPERATIONS_DETAILS_V
VIEW - APPS.EAM_OP_COMPLETION_TXNS_V
VIEW - APPS.EAM_OUTSTANDING_WORK_ORDERS_V
VIEW - APPS.EAM_PERMIT_STATUSES_VL
VIEW - APPS.EAM_PM_ACTIVITYGROUP_V
VIEW - APPS.EAM_PM_ASSET_ACTIVITY_V
VIEW - APPS.EAM_PM_LAST_SERVICE_V
VIEW - APPS.EAM_PM_SCHEDULINGS_V
VIEW - APPS.EAM_PRIOR_OPERATIONS_V
VIEW - APPS.EAM_REBUILD_COMPLETION_JOBS_V
VIEW - APPS.EAM_REQUIREMENT_OPERATIONS_V
VIEW - APPS.EAM_RESOURCES_V
VIEW - APPS.EAM_RUNTIME_INTERVAL_V
VIEW - APPS.EAM_SAF_WO_CONCAT_STATUSES_VL
VIEW - APPS.EAM_SERVICE_REQUEST_DETAILS_V
VIEW - APPS.EAM_SUPPRESSION_RELATIONS_V
VIEW - APPS.EAM_WORKORDER_DOWNTIME_V
VIEW - APPS.EAM_WORK_ASSET_ROUTE_V
VIEW - APPS.EAM_WORK_CLEARANCE_STATUSES_VL
VIEW - APPS.EAM_WORK_ORDERS_V
VIEW - APPS.EAM_WORK_ORDER_BILL_DETAILS_V
VIEW - APPS.EAM_WORK_ORDER_DETAILS_V
VIEW - APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V
VIEW - APPS.EAM_WORK_ORDER_REQ_PO_V
VIEW - APPS.EAM_WORK_REQUEST_ASSOC_V
VIEW - APPS.EAM_WO_DIRECT_ITEMS_LITE_V
VIEW - APPS.EAM_WO_REQ_PO_LITE_V
VIEW - APPS.EAM_WO_STATUSES_VL

Table: EAM_ASSET_EXPLOSION_TEMP

Description: Asset Explosion Temp

[top of page]

EAM.EAM_ASSET_EXPLOSION_TEMP does not reference any database object

EAM.EAM_ASSET_EXPLOSION_TEMP is referenced by following:

EAM
VIEW - EAM_ASSET_EXPLOSION_TEMP#

[top of page]

Table: EAM_ASSET_FAILURES

Description: Stores Information about failure events against the asset.
Primary Key: EAM_ASSET_FAILURES_PK
  1. FAILURE_ID
Primary Key: EAM_ASSET_FAILURES_UK
  1. SOURCE_ID

[top of page]

EAM.EAM_ASSET_FAILURES does not reference any database object

EAM.EAM_ASSET_FAILURES is referenced by following:

EAM
VIEW - EAM_ASSET_FAILURES#

[top of page]

Table: EAM_ASSET_FAILURE_CODES

Description: Stores detailed information captured for a failure event.
Primary Key: EAM_ASSET_FAILURE_CODES_PK
  1. FAILURE_ENTRY_ID
Primary Key: EAM_ASSET_FAILURE_CODES_UK
  1. FAILURE_ID
  2. FAILURE_CODE
  3. CAUSE_CODE
  4. RESOLUTION_CODE

[top of page]

EAM.EAM_ASSET_FAILURE_CODES does not reference any database object

EAM.EAM_ASSET_FAILURE_CODES is referenced by following:

EAM
VIEW - EAM_ASSET_FAILURE_CODES#

[top of page]

Table: EAM_ASSET_LOG

Description: This table stores log information of operational status of assets which will be used to analyse the assets.

[top of page]

EAM.EAM_ASSET_LOG does not reference any database object

EAM.EAM_ASSET_LOG is referenced by following:

EAM
VIEW - EAM_ASSET_LOG#

[top of page]

Table: EAM_ASSET_METERS

Description: Asset Meter Association
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_ASSET_METERS.METER_ID EAM_METERS
EAM_ASSET_METERS.ASSET_NUMBER
EAM_ASSET_METERS.ASSET_GROUP_ID
EAM_ASSET_METERS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
EAM_ASSET_METERS.ASSET_GROUP_ID
EAM_ASSET_METERS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B

[top of page]

EAM.EAM_ASSET_METERS does not reference any database object

EAM.EAM_ASSET_METERS is referenced by following:

EAM
VIEW - EAM_ASSET_METERS#

[top of page]

Table: EAM_ASSET_MOVE_TEMP

Description:

[top of page]

EAM.EAM_ASSET_MOVE_TEMP does not reference any database object

EAM.EAM_ASSET_MOVE_TEMP is referenced by following:

APPS
SYNONYM - EAM_ASSET_MOVE_TEMP

[top of page]

Table: EAM_ASSET_OPERATION_TXN

Description: This table stores Asset Operational Transactions, Check-In and Check Out Operations on Assets.

[top of page]

EAM.EAM_ASSET_OPERATION_TXN does not reference any database object

EAM.EAM_ASSET_OPERATION_TXN is referenced by following:

EAM
VIEW - EAM_ASSET_OPERATION_TXN#

[top of page]

Table: EAM_ASSET_RESULTS_GTT

Description:

[top of page]

EAM.EAM_ASSET_RESULTS_GTT does not reference any database object

EAM.EAM_ASSET_RESULTS_GTT is referenced by following:

APPS
SYNONYM - EAM_ASSET_RESULTS_GTT

[top of page]

Table: EAM_ASSET_SAFETY_TYPES

Description: Table to Store EAM Asset's Safety Type (Positional Asset or Lockout Device)

[top of page]

EAM.EAM_ASSET_SAFETY_TYPES does not reference any database object

EAM.EAM_ASSET_SAFETY_TYPES is referenced by following:

EAM
VIEW - EAM_ASSET_SAFETY_TYPES#

[top of page]

Table: EAM_ASSET_STATUS_HISTORY

Description: Table for Asset Status History
Primary Key: EAM_ASSET_STATUS_HISTORY_PK
  1. ASSET_STATUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID MTL_PARAMETERS
EAM_ASSET_STATUS_HISTORY.ASSET_NUMBER
EAM_ASSET_STATUS_HISTORY.ASSET_GROUP_ID
EAM_ASSET_STATUS_HISTORY.ORGANIZATION_ID
MTL_SERIAL_NUMBERS

[top of page]

EAM.EAM_ASSET_STATUS_HISTORY does not reference any database object

EAM.EAM_ASSET_STATUS_HISTORY is referenced by following:

EAM
VIEW - EAM_ASSET_STATUS_HISTORY#

[top of page]

Table: EAM_ASSET_TEXT

Description: This table stores instance_id of all valid eAM asset defined in csi_item_instances. A text (intermedia) index will be created on the column 'TEXT' with the help of a concurrent program and the same is used in Asset text search page

[top of page]

EAM.EAM_ASSET_TEXT does not reference any database object

EAM.EAM_ASSET_TEXT is referenced by following:

EAM
VIEW - EAM_ASSET_TEXT#

[top of page]

Table: EAM_CAUSE_CODES

Description: Table to store the Cause Codes defined in the system
Primary Key: EAM_CAUSE_CODES_PK
  1. CAUSE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_FAILURE_COMBINATIONS.CAUSE_CODE EAM_CAUSE_CODES

[top of page]

EAM.EAM_CAUSE_CODES does not reference any database object

EAM.EAM_CAUSE_CODES is referenced by following:

EAM
VIEW - EAM_CAUSE_CODES#

[top of page]

Table: EAM_CE_WORK_ORDER_LINES

Description: This table contains consolidated work order lines for the estimate. The work order line can be a resource or material line depending upon the values populated in res_id or mat_inventory_item_id.
Primary Key: ECWOL_PK
  1. ESTIMATE_WORK_ORDER_LINE_ID

[top of page]

EAM.EAM_CE_WORK_ORDER_LINES does not reference any database object

EAM.EAM_CE_WORK_ORDER_LINES is referenced by following:

EAM
VIEW - EAM_CE_WORK_ORDER_LINES#

[top of page]

Table: EAM_CONSTRUCTION_ESTIMATES

Description: This table contains all the estimates header information. The header information include- Estimate name- Grouping option for the estimate- Parent work order for the estimate (if any)- Organization in which the estimate was created- Flexfiel
Primary Key: ECE_PK
  1. ESTIMATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_WORK_ORDER_DETAILS.ESTIMATE_ID EAM_CONSTRUCTION_ESTIMATES
EAM_ESTIMATE_ASSOCIATIONS.ESTIMATE_ID EAM_CONSTRUCTION_ESTIMATES

[top of page]

EAM.EAM_CONSTRUCTION_ESTIMATES does not reference any database object

EAM.EAM_CONSTRUCTION_ESTIMATES is referenced by following:

EAM
VIEW - EAM_CONSTRUCTION_ESTIMATES#

[top of page]

Table: EAM_CONSTRUCTION_UNITS

Description: This table contains all the construction units defined in the system. The construction unit information include the following:- Construction unit name- Effectivity period- Organization in which the unit was created- Flexfields information
Primary Key: CU_ID_PK
  1. CU_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_CONSTRUCTION_UNIT_DETAILS.CU_ID EAM_CONSTRUCTION_UNITS
EAM_ESTIMATE_ASSOCIATIONS.CU_ID EAM_CONSTRUCTION_UNITS

[top of page]

EAM.EAM_CONSTRUCTION_UNITS does not reference any database object

EAM.EAM_CONSTRUCTION_UNITS is referenced by following:

EAM
VIEW - EAM_CONSTRUCTION_UNITS#

[top of page]

Table: EAM_CONSTRUCTION_UNIT_DETAILS

Description: This contains all the activities and activity related details which are part of the construction unit. The information include - Activity - Activity effectivity period- Activity qty - Accouting class code
Primary Key: ECL_PK
  1. CU_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_CONSTRUCTION_UNIT_DETAILS.CU_ID EAM_CONSTRUCTION_UNITS

[top of page]

EAM.EAM_CONSTRUCTION_UNIT_DETAILS does not reference any database object

EAM.EAM_CONSTRUCTION_UNIT_DETAILS is referenced by following:

EAM
VIEW - EAM_CONSTRUCTION_UNIT_DETAILS#

[top of page]

Table: EAM_CONTROL_EVENT

Description: This table is used to store the information regarding the events which needs to be tracked for all Assets in each maintenance organization.

[top of page]

EAM.EAM_CONTROL_EVENT does not reference any database object

EAM.EAM_CONTROL_EVENT is referenced by following:

EAM
VIEW - EAM_CONTROL_EVENT#

[top of page]

Table: EAM_DIFFICULTY_CODES

Description: This table contains difficulty code mapping with resource multipliers. It also includes the effectivity period for defined resource multiplier
Primary Key: EDE_PK
  1. DIFFICULTY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_ESTIMATE_ASSOCIATIONS.DIFFICULTY_ID EAM_DIFFICULTY_CODES

[top of page]

EAM.EAM_DIFFICULTY_CODES does not reference any database object

EAM.EAM_DIFFICULTY_CODES is referenced by following:

EAM
VIEW - EAM_DIFFICULTY_CODES#

[top of page]

Table: EAM_EMP_ASSIGNMENT_DETAILS_TBL

Description:

[top of page]

EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL does not reference any database object

EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL is referenced by following:

APPS
SYNONYM - EAM_EMP_ASSIGNMENT_DETAILS_TBL

[top of page]

Table: EAM_EMP_SEARCH_RESULT_TBL

Description:

[top of page]

EAM.EAM_EMP_SEARCH_RESULT_TBL does not reference any database object

EAM.EAM_EMP_SEARCH_RESULT_TBL is referenced by following:

APPS
SYNONYM - EAM_EMP_SEARCH_RESULT_TBL

[top of page]

Table: EAM_ENABLE_WORKFLOW

Description: This table stores the various maintenance object source values for which workflow is enabled/disabled
Primary Key: MAINTENANCE_OBJECT_SOURCE_PK
  1. MAINTENANCE_OBJECT_SOURCE

[top of page]

EAM.EAM_ENABLE_WORKFLOW does not reference any database object

EAM.EAM_ENABLE_WORKFLOW is referenced by following:

EAM
VIEW - EAM_ENABLE_WORKFLOW#

[top of page]

Table: EAM_ESTABLISHMENT_DETAILS

Description: This table stores safety Establishment details.
Primary Key: EAM_ESTABLISHMENT_DETAILS_PK
  1. ESTABLISHMENT_ID

[top of page]

EAM.EAM_ESTABLISHMENT_DETAILS does not reference any database object

EAM.EAM_ESTABLISHMENT_DETAILS is referenced by following:

EAM
VIEW - EAM_ESTABLISHMENT_DETAILS#

[top of page]

Table: EAM_ESTIMATE_ASSOCIATIONS

Description: This table contains all the association data for an estimate. The association data include the following
Primary Key: EEN_PK
  1. ESTIMATE_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_ESTIMATE_ASSOCIATIONS.ESTIMATE_ID EAM_CONSTRUCTION_ESTIMATES
EAM_ESTIMATE_ASSOCIATIONS.CU_ID EAM_CONSTRUCTION_UNITS
EAM_ESTIMATE_ASSOCIATIONS.DIFFICULTY_ID EAM_DIFFICULTY_CODES

[top of page]

EAM.EAM_ESTIMATE_ASSOCIATIONS does not reference any database object

EAM.EAM_ESTIMATE_ASSOCIATIONS is referenced by following:

EAM
VIEW - EAM_ESTIMATE_ASSOCIATIONS#

[top of page]

Table: EAM_FAILURE_CODES

Description: Table to store the Failure Codes defined in the system
Primary Key: EAM_FAILURE_CODES_PK
  1. FAILURE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_FAILURE_COMBINATIONS.FAILURE_CODE EAM_FAILURE_CODES

[top of page]

EAM.EAM_FAILURE_CODES does not reference any database object

EAM.EAM_FAILURE_CODES is referenced by following:

EAM
VIEW - EAM_FAILURE_CODES#

[top of page]

Table: EAM_FAILURE_COMBINATIONS

Description: Stores the unique Failure/Cause/Resolution Code Combinations
Primary Key: EAM_FAILURE_COMBINATIONS_PK
  1. COMBINATION_ID
Primary Key: EAM_FAILURE_COMBINATIONS_UK
  1. CAUSE_CODE
  2. SET_ID
  3. RESOLUTION_CODE
  4. FAILURE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_FAILURE_COMBINATIONS.SET_ID EAM_FAILURE_SETS
EAM_FAILURE_COMBINATIONS.FAILURE_CODE EAM_FAILURE_CODES
EAM_FAILURE_COMBINATIONS.CAUSE_CODE EAM_CAUSE_CODES
EAM_FAILURE_COMBINATIONS.RESOLUTION_CODE EAM_RESOLUTION_CODES

[top of page]

EAM.EAM_FAILURE_COMBINATIONS does not reference any database object

EAM.EAM_FAILURE_COMBINATIONS is referenced by following:

EAM
VIEW - EAM_FAILURE_COMBINATIONS#

[top of page]

Table: EAM_FAILURE_HISTORY_TEMP

Description: Temporary table used by eAM to hold data about Failure History/Analysis

[top of page]

EAM.EAM_FAILURE_HISTORY_TEMP does not reference any database object

EAM.EAM_FAILURE_HISTORY_TEMP is referenced by following:

EAM
VIEW - EAM_FAILURE_HISTORY_TEMP#

[top of page]

Table: EAM_FAILURE_SETS

Description: All the failure set definitions are stored in this table.
Primary Key: EAM_FAILURE_SETS_PK
  1. SET_ID
Primary Key: EAM_FAILURE_SETS_UK
  1. SET_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_FAILURE_COMBINATIONS.SET_ID EAM_FAILURE_SETS
EAM_FAILURE_SET_ASSOCIATIONS.SET_ID EAM_FAILURE_SETS

[top of page]

EAM.EAM_FAILURE_SETS does not reference any database object

EAM.EAM_FAILURE_SETS is referenced by following:

EAM
VIEW - EAM_FAILURE_SETS#

[top of page]

Table: EAM_FAILURE_SET_ASSOCIATIONS

Description: Stores the associations between an Item and an Failure Set.
Primary Key: EAM_FAILURE_SET_ASSOCIATION_PK
  1. SET_ID
  2. INVENTORY_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_FAILURE_SET_ASSOCIATIONS.SET_ID EAM_FAILURE_SETS

[top of page]

EAM.EAM_FAILURE_SET_ASSOCIATIONS does not reference any database object

EAM.EAM_FAILURE_SET_ASSOCIATIONS is referenced by following:

EAM
VIEW - EAM_FAILURE_SET_ASSOCIATIONS#

[top of page]

Table: EAM_FORECASTED_WORK_ORDERS

Description: Forecasted Work Orders
Primary Key: EAM_FORECASTED_WORK_ORDERS_PK
  1. PM_FORECAST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_FORECASTED_WORK_ORDERS.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS
EAM_FORECASTED_WORK_ORDERS.ACTIVITY_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES

[top of page]

EAM.EAM_FORECASTED_WORK_ORDERS does not reference any database object

EAM.EAM_FORECASTED_WORK_ORDERS is referenced by following:

EAM
VIEW - EAM_FORECASTED_WORK_ORDERS#

[top of page]

Table: EAM_FORECASTS

Description: This table stores the criteria for forecasts and templates used in EAM maintenance budgeting and forecasting. It also stores the request id for the concurrent request for a forecast.
Primary Key: EAM_FORECASTS_PK
  1. FORECAST_ID

[top of page]

EAM.EAM_FORECASTS does not reference any database object

EAM.EAM_FORECASTS is referenced by following:

EAM
VIEW - EAM_FORECASTS#

[top of page]

Table: EAM_FORECAST_CEBBA

Description: This table stores all of the costs associated with a forecasted work order for eAM maintenance budgeting and forecasting. This mirrors the structure of cst_eam_balance_by_accounts.

[top of page]

EAM.EAM_FORECAST_CEBBA does not reference any database object

EAM.EAM_FORECAST_CEBBA is referenced by following:

EAM
VIEW - EAM_FORECAST_CEBBA#

[top of page]

Table: EAM_FORECAST_WDJ

Description: This table stores all of the work order information for a forecasted work order for eAM maintenance budgeting and forecasting.
Primary Key: EAM_FORECAST_WDJ_PK
  1. WIP_ENTITY_ID
  2. FORECAST_ID

[top of page]

EAM.EAM_FORECAST_WDJ does not reference any database object

EAM.EAM_FORECAST_WDJ is referenced by following:

EAM
VIEW - EAM_FORECAST_WDJ#

[top of page]

Table: EAM_FORECAST_WEDI

Description: This table stores the direct item information for forecasted work orders in eAM maintenance budgeting and forecasting. This mirrors the structure of wip_eam_direct_items.

[top of page]

EAM.EAM_FORECAST_WEDI does not reference any database object

EAM.EAM_FORECAST_WEDI is referenced by following:

EAM
VIEW - EAM_FORECAST_WEDI#

[top of page]

Table: EAM_FORECAST_WO

Description: This table stores the operation level information for forecasted work orders for eAM maintenance budgeting and forecasting.

[top of page]

EAM.EAM_FORECAST_WO does not reference any database object

EAM.EAM_FORECAST_WO is referenced by following:

EAM
VIEW - EAM_FORECAST_WO#

[top of page]

Table: EAM_FORECAST_WOR

Description: This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting.

[top of page]

EAM.EAM_FORECAST_WOR does not reference any database object

EAM.EAM_FORECAST_WOR is referenced by following:

EAM
VIEW - EAM_FORECAST_WOR#

[top of page]

Table: EAM_FORECAST_WRO

Description: This table stores the material requirements of forecasted work orders for eaM maintenance budgeting and forecasting.

[top of page]

EAM.EAM_FORECAST_WRO does not reference any database object

EAM.EAM_FORECAST_WRO is referenced by following:

EAM
VIEW - EAM_FORECAST_WRO#

[top of page]

Table: EAM_ISOLATIONS

Description: This table stores safety Isolation Definition.
Primary Key: EAM_ISOLATIONS_PK
  1. ISOLATION_ID

[top of page]

EAM.EAM_ISOLATIONS does not reference any database object

EAM.EAM_ISOLATIONS is referenced by following:

EAM
VIEW - EAM_ISOLATIONS#

[top of page]

Table: EAM_JOB_COMPLETION_TXNS

Description: Work Order Completion Transaction History
Primary Key: EAM_JOB_COMPLETION_TXNS_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_JOB_COMPLETION_TXNS.ASSET_NUMBER
EAM_JOB_COMPLETION_TXNS.ASSET_GROUP_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
EAM_JOB_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
EAM_JOB_COMPLETION_TXNS.ACCT_PERIOD_ID
EAM_JOB_COMPLETION_TXNS.ORGANIZATION_ID
ORG_ACCT_PERIODS
EAM_JOB_COMPLETION_TXNS.TRANSACTION_TYPE MTL_TRANSACTION_TYPES

[top of page]

EAM.EAM_JOB_COMPLETION_TXNS does not reference any database object

EAM.EAM_JOB_COMPLETION_TXNS is referenced by following:

EAM
VIEW - EAM_JOB_COMPLETION_TXNS#

[top of page]

Table: EAM_LINEAR_LOCATIONS

Description: This table is for linear location ids pushed into EAM from external sources.

[top of page]

EAM.EAM_LINEAR_LOCATIONS does not reference any database object

EAM.EAM_LINEAR_LOCATIONS is referenced by following:

EAM
VIEW - EAM_LINEAR_LOCATIONS#

[top of page]

Table: EAM_MATERIAL_IMPORT

Description: Material Import Table

[top of page]

EAM.EAM_MATERIAL_IMPORT does not reference any database object

EAM.EAM_MATERIAL_IMPORT is referenced by following:

EAM
VIEW - EAM_MATERIAL_IMPORT#

[top of page]

Table: EAM_METERS

Description: Table for asset meter definition
Primary Key: EAM_METERS_PK
  1. METER_ID
Primary Key: EAM_METERS_UK
  1. METER_NAME
Primary Key: PK_EAM_METERS
  1. METER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_ASSET_METERS.METER_ID EAM_METERS
EAM_METER_READINGS.METER_ID EAM_METERS

[top of page]

EAM.EAM_METERS does not reference any database object

EAM.EAM_METERS is referenced by following:

EAM
VIEW - EAM_METERS#

[top of page]

Table: EAM_METER_READINGS

Description: Table to store asset meter readings
Primary Key: EAM_METER_READINGS_PK
  1. METER_READING_ID
Primary Key: PK_EAM_METER_READINGS
  1. METER_READING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_METER_READINGS.METER_ID EAM_METERS
EAM_METER_READINGS.WIP_ENTITY_ID WIP_DISCRETE_JOBS

[top of page]

EAM.EAM_METER_READINGS does not reference any database object

EAM.EAM_METER_READINGS is referenced by following:

EAM
VIEW - EAM_METER_READINGS#

[top of page]

Table: EAM_METER_READINGS_INTERFACE

Description: Asset Meter Readings Interface table

[top of page]

EAM.EAM_METER_READINGS_INTERFACE does not reference any database object

EAM.EAM_METER_READINGS_INTERFACE is referenced by following:

EAM
VIEW - EAM_METER_READINGS_INTERFACE#

[top of page]

Table: EAM_OPERATION_IMPORT

Description: Work Order Operations Import

[top of page]

EAM.EAM_OPERATION_IMPORT does not reference any database object

EAM.EAM_OPERATION_IMPORT is referenced by following:

EAM
VIEW - EAM_OPERATION_IMPORT#

[top of page]

Table: EAM_OP_COMPLETION_TXNS

Description: Work Order Operation Completion Transaction History
Primary Key: EAM_OP_COMPLETION_TXNS_PK
  1. TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_OP_COMPLETION_TXNS.ASSET_NUMBER
EAM_OP_COMPLETION_TXNS.ASSET_GROUP_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
MTL_SERIAL_NUMBERS
EAM_OP_COMPLETION_TXNS.ASSET_ACTIVITY_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B
EAM_OP_COMPLETION_TXNS.ACCT_PERIOD_ID
EAM_OP_COMPLETION_TXNS.ORGANIZATION_ID
ORG_ACCT_PERIODS
EAM_OP_COMPLETION_TXNS.TRANSACTION_TYPE MTL_TRANSACTION_TYPES
EAM_OP_COMPLETION_TXNS.REASON_ID MTL_TRANSACTION_REASONS

[top of page]

EAM.EAM_OP_COMPLETION_TXNS does not reference any database object

EAM.EAM_OP_COMPLETION_TXNS is referenced by following:

EAM
VIEW - EAM_OP_COMPLETION_TXNS#

[top of page]

Table: EAM_ORG_MAINT_DEFAULTS

Description: Maintenance Organization Specific Defaults For Several Type of Objects

[top of page]

EAM.EAM_ORG_MAINT_DEFAULTS does not reference any database object

EAM.EAM_ORG_MAINT_DEFAULTS is referenced by following:

EAM
VIEW - EAM_ORG_MAINT_DEFAULTS#

[top of page]

Table: EAM_PM_ACTIVITIES

Description: This table stores the PM Schedule activities and their associated attributes
Primary Key: EAM_PM_ACTIVITIES_PK
  1. PM_SCHEDULE_ID
  2. ACTIVITY_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_PM_ACTIVITIES.ACTIVITY_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES
EAM_PM_ACTIVITIES.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS

[top of page]

EAM.EAM_PM_ACTIVITIES does not reference any database object

EAM.EAM_PM_ACTIVITIES is referenced by following:

EAM
VIEW - EAM_PM_ACTIVITIES#

[top of page]

Table: EAM_PM_LAST_SERVICE

Description: PM Last Service Information
Primary Key: EAM_PM_LAST_SERVICE_PK
  1. METER_ID
  2. ACTIVITY_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_PM_LAST_SERVICE.ACTIVITY_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES
EAM_PM_LAST_SERVICE.METER_ID CSI_COUNTERS_B
EAM_PM_LAST_SERVICE.WIP_ENTITY_ID WIP_DISCRETE_JOBS

[top of page]

EAM.EAM_PM_LAST_SERVICE does not reference any database object

EAM.EAM_PM_LAST_SERVICE is referenced by following:

EAM
VIEW - EAM_PM_LAST_SERVICE#

[top of page]

Table: EAM_PM_SCHEDULINGS

Description: PM Scheduling Definition
Primary Key: EAM_PM_SCHEDULINGS_PK
  1. PM_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_PM_SCHEDULINGS.ACTIVITY_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES
EAM_PM_SCHEDULINGS.SET_NAME_ID EAM_PM_SET_NAMES
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_FORECASTED_WORK_ORDERS.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS
EAM_PM_ACTIVITIES.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS
EAM_PM_SCHEDULING_RULES.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS

[top of page]

EAM.EAM_PM_SCHEDULINGS does not reference any database object

EAM.EAM_PM_SCHEDULINGS is referenced by following:

EAM
VIEW - EAM_PM_SCHEDULINGS#

[top of page]

Table: EAM_PM_SCHEDULING_RULES

Description: Table to store PM scheduling rules
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_PM_SCHEDULING_RULES.PM_SCHEDULE_ID EAM_PM_SCHEDULINGS
EAM_PM_SCHEDULING_RULES.METER_ID CSI_COUNTERS_B

[top of page]

EAM.EAM_PM_SCHEDULING_RULES does not reference any database object

EAM.EAM_PM_SCHEDULING_RULES is referenced by following:

EAM
VIEW - EAM_PM_SCHEDULING_RULES#

[top of page]

Table: EAM_PM_SET_NAMES

Description: PM Set Names
Primary Key: EAM_PM_SET_NAMES_PK
  1. SET_NAME_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_PM_SCHEDULINGS.SET_NAME_ID EAM_PM_SET_NAMES

[top of page]

EAM.EAM_PM_SET_NAMES does not reference any database object

EAM.EAM_PM_SET_NAMES is referenced by following:

EAM
VIEW - EAM_PM_SET_NAMES#

[top of page]

Table: EAM_RESOLUTION_CODES

Description: Table to store the Resolution Codes defined in the system
Primary Key: EAM_RESOLUTION_CODES_PK
  1. RESOLUTION_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_FAILURE_COMBINATIONS.RESOLUTION_CODE EAM_RESOLUTION_CODES

[top of page]

EAM.EAM_RESOLUTION_CODES does not reference any database object

EAM.EAM_RESOLUTION_CODES is referenced by following:

EAM
VIEW - EAM_RESOLUTION_CODES#

[top of page]

Table: EAM_RESOURCE_IMPORT

Description: Work Order Resource

[top of page]

EAM.EAM_RESOURCE_IMPORT does not reference any database object

EAM.EAM_RESOURCE_IMPORT is referenced by following:

EAM
VIEW - EAM_RESOURCE_IMPORT#

[top of page]

Table: EAM_RESOURCE_INSTANCE_IMPORT

Description: Work Order Resource Instances

[top of page]

EAM.EAM_RESOURCE_INSTANCE_IMPORT does not reference any database object

EAM.EAM_RESOURCE_INSTANCE_IMPORT is referenced by following:

EAM
VIEW - EAM_RESOURCE_INSTANCE_IMPORT#

[top of page]

Table: EAM_RESOURCE_USAGE_IMPORT

Description: Work Order Resource Usage

[top of page]

EAM.EAM_RESOURCE_USAGE_IMPORT does not reference any database object

EAM.EAM_RESOURCE_USAGE_IMPORT is referenced by following:

EAM
VIEW - EAM_RESOURCE_USAGE_IMPORT#

[top of page]

Table: EAM_SAFETY_ASSOCIATIONS

Description: This table stores work order and safety association information
Primary Key: EAM_SAFETY_ASSOCIATION_PK
  1. SAFETY_ASSOCIATION_ID

[top of page]

EAM.EAM_SAFETY_ASSOCIATIONS does not reference any database object

EAM.EAM_SAFETY_ASSOCIATIONS is referenced by following:

EAM
VIEW - EAM_SAFETY_ASSOCIATIONS#

[top of page]

Table: EAM_SAFETY_HISTORY

Description: Table for storing safety history
Primary Key: EAM_SAFETY_HISTORY_PK
  1. OBJECT_ID
  2. OBJECT_TYPE

[top of page]

EAM.EAM_SAFETY_HISTORY does not reference any database object

EAM.EAM_SAFETY_HISTORY is referenced by following:

EAM
VIEW - EAM_SAFETY_HISTORY#

[top of page]

Table: EAM_SAFETY_USR_DEF_STATUSES_B

Description: Table for storing safety user defined statuses
Primary Key: EAM_SAFETY_USR_DEF_STATUS_B_PK
  1. STATUS_ID

[top of page]

EAM.EAM_SAFETY_USR_DEF_STATUSES_B does not reference any database object

EAM.EAM_SAFETY_USR_DEF_STATUSES_B is referenced by following:

EAM
VIEW - EAM_SAFETY_USR_DEF_STATUSES_B#

[top of page]

Table: EAM_SAFETY_USR_DEF_STATUSES_TL

Description: This table contains translation information for Safety Entity Statuses.
Primary Key: EAM_SAFETY_USR_DEF_STAT_TL_PK
  1. STATUS_ID
  2. LANGUAGE
Primary Key: EAM_SAFETY_USR_DEF_STA_TL_PK
  1. STATUS_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_SAFETY_USR_DEF_STATUSES_TL.STATUS_ID EAM_WO_STATUSES_B

[top of page]

EAM.EAM_SAFETY_USR_DEF_STATUSES_TL does not reference any database object

EAM.EAM_SAFETY_USR_DEF_STATUSES_TL is referenced by following:

EAM
VIEW - EAM_SAFETY_USR_DEF_STATUSES_T#

[top of page]

Table: EAM_SAFETY_WORKFLOWS

Description: Table for storing workflow item type and keys corresponding to safety objects
Primary Key: EAM_SAFETY_WORKFLOWS_PK
  1. TRANSACTION_ID

[top of page]

EAM.EAM_SAFETY_WORKFLOWS does not reference any database object

EAM.EAM_SAFETY_WORKFLOWS is referenced by following:

EAM
VIEW - EAM_SAFETY_WORKFLOWS#

[top of page]

Table: EAM_SUPPRESSION_RELATIONS

Description: Table to store PM suppression relations
Primary Key: EAM_SUPPRESSION_RELATIONS_PK
  1. PARENT_ASSOCIATION_ID
  2. CHILD_ASSOCIATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_SUPPRESSION_RELATIONS.CHILD_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES
EAM_SUPPRESSION_RELATIONS.PARENT_ASSOCIATION_ID MTL_EAM_ASSET_ACTIVITIES

[top of page]

EAM.EAM_SUPPRESSION_RELATIONS does not reference any database object

EAM.EAM_SUPPRESSION_RELATIONS is referenced by following:

EAM
VIEW - EAM_SUPPRESSION_RELATIONS#

[top of page]

Table: EAM_WOREP_LONG_ATTACH_TEMP

Description:

[top of page]

EAM.EAM_WOREP_LONG_ATTACH_TEMP does not reference any database object

EAM.EAM_WOREP_LONG_ATTACH_TEMP is referenced by following:

APPS
SYNONYM - EAM_WOREP_LONG_ATTACH_TEMP

[top of page]

Table: EAM_WORK_CLEARANCES

Description: This table stores Safety Work Clearance definition. It would be attached to Establishment & Re-Establishment sequences, Work Orders and Work Permits
Primary Key: EAM_WORK_CLEARANCES_PK
  1. WORK_CLEARANCE_ID

[top of page]

EAM.EAM_WORK_CLEARANCES does not reference any database object

EAM.EAM_WORK_CLEARANCES is referenced by following:

EAM
VIEW - EAM_WORK_CLEARANCES#

[top of page]

Table: EAM_WORK_ORDER_BILLS

Description: Work Order Billing Information.
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_WORK_ORDER_BILLS.BILLED_INVENTORY_ITEM_ID
EAM_WORK_ORDER_BILLS.ORGANIZATION_ID
MTL_SYSTEM_ITEMS_B

[top of page]

EAM.EAM_WORK_ORDER_BILLS does not reference any database object

EAM.EAM_WORK_ORDER_BILLS is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_BILLS#

[top of page]

Table: EAM_WORK_ORDER_DETAILS

Description: eAM Work Order Details
Primary Key: EAM_WORK_ORDER_DETAILS_PK
  1. WIP_ENTITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_WORK_ORDER_DETAILS.ESTIMATE_ID EAM_CONSTRUCTION_ESTIMATES

[top of page]

EAM.EAM_WORK_ORDER_DETAILS does not reference any database object

EAM.EAM_WORK_ORDER_DETAILS is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_DETAILS#

[top of page]

Table: EAM_WORK_ORDER_IMPORT

Description: Work Order Import

[top of page]

EAM.EAM_WORK_ORDER_IMPORT does not reference any database object

EAM.EAM_WORK_ORDER_IMPORT is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_IMPORT#

[top of page]

Table: EAM_WORK_ORDER_IMPORT_ERRORS

Description: Work Order Import Errors

[top of page]

EAM.EAM_WORK_ORDER_IMPORT_ERRORS does not reference any database object

EAM.EAM_WORK_ORDER_IMPORT_ERRORS is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_IMPORT_ERRORS#

[top of page]

Table: EAM_WORK_ORDER_ROUTE

Description: Route Asset History Table

[top of page]

EAM.EAM_WORK_ORDER_ROUTE does not reference any database object

EAM.EAM_WORK_ORDER_ROUTE is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_ROUTE#

[top of page]

Table: EAM_WORK_ORDER_TEXT

Description: This table stores all the EAM workorders.This is used in Intermedia search for workorders

[top of page]

EAM.EAM_WORK_ORDER_TEXT does not reference any database object

EAM.EAM_WORK_ORDER_TEXT is referenced by following:

EAM
VIEW - EAM_WORK_ORDER_TEXT#

[top of page]

Table: EAM_WORK_PERMITS

Description: This table stores safety work permit definition. Once permits are defined, they need to be associated to Work Orders.
Primary Key: EAM_PERMIT_PK
  1. PERMIT_ID

[top of page]

EAM.EAM_WORK_PERMITS does not reference any database object

EAM.EAM_WORK_PERMITS is referenced by following:

EAM
VIEW - EAM_WORK_PERMITS#

[top of page]

Table: EAM_WO_RELATIONSHIPS

Description: Eam Work Order Relationships
Primary Key: EAM_WO_RELATIONSHIP_ID_PK
  1. WO_RELATIONSHIP_ID

[top of page]

EAM.EAM_WO_RELATIONSHIPS does not reference any database object

EAM.EAM_WO_RELATIONSHIPS is referenced by following:

EAM
VIEW - EAM_WO_RELATIONSHIPS#

[top of page]

Table: EAM_WO_SERVICE_ASSOCIATION

Description: Work Order Service Request Association

[top of page]

EAM.EAM_WO_SERVICE_ASSOCIATION does not reference any database object

EAM.EAM_WO_SERVICE_ASSOCIATION is referenced by following:

EAM
VIEW - EAM_WO_SERVICE_ASSOCIATION#

[top of page]

Table: EAM_WO_STATUSES_B

Description: Table for storing user defined statuses
Primary Key: EAM_WO_STATUSES_B_PK
  1. STATUS_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
EAM_SAFETY_USR_DEF_STATUSES_TL.STATUS_ID EAM_WO_STATUSES_B
EAM_WO_STATUSES_TL.STATUS_ID EAM_WO_STATUSES_B

[top of page]

EAM.EAM_WO_STATUSES_B does not reference any database object

EAM.EAM_WO_STATUSES_B is referenced by following:

EAM
VIEW - EAM_WO_STATUSES_B#

[top of page]

Table: EAM_WO_STATUSES_TL

Description: This table contains translation information for Work Order Statuses.
Primary Key: EAM_WO_STATUSES_TL_PK
  1. STATUS_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
EAM_WO_STATUSES_TL.STATUS_ID EAM_WO_STATUSES_B

[top of page]

EAM.EAM_WO_STATUSES_TL does not reference any database object

EAM.EAM_WO_STATUSES_TL is referenced by following:

EAM
VIEW - EAM_WO_STATUSES_TL#

[top of page]

Table: EAM_WO_WORKFLOWS

Description: Table for storing workflow item type and keys corresponding to a work order

[top of page]

EAM.EAM_WO_WORKFLOWS does not reference any database object

EAM.EAM_WO_WORKFLOWS is referenced by following:

EAM
VIEW - EAM_WO_WORKFLOWS#

[top of page]

View: EAM_ASSET_METERS_V

[top of page]

APPS.EAM_ASSET_METERS_V references the following:

APPS
SYNONYM - CSI_COUNTERS_B
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_COUNTER_ASSOCIATIONS
SYNONYM - CSI_COUNTER_RELATIONSHIPS
SYNONYM - CSI_COUNTER_TEMPLATE_B
SYNONYM - CSI_COUNTER_TEMPLATE_TL
SYNONYM - CSI_CTR_ITEM_ASSOCIATIONS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - MTL_PARAMETERS
- MTL_SYSTEM_ITEMS_B_KFV
APPS.EAM_ASSET_METERS_V is referenced by following:

APPS
VIEW - EAM_PM_ASSET_ACTIVITY_V

[top of page]

View: EAM_BILL_BY_ACTIVITIES_V

[top of page]

APPS.EAM_BILL_BY_ACTIVITIES_V references the following:

APPS
SYNONYM - EAM_WORK_ORDER_BILLS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_EAM_PARAMETERS
- MFG_LOOKUPS

APPS.EAM_BILL_BY_ACTIVITIES_V is not referenced by any database object

[top of page]

View: EAM_BILL_BY_REQUIREMENTS_V

[top of page]

APPS.EAM_BILL_BY_REQUIREMENTS_V references the following:

APPS
SYNONYM - BOM_RESOURCES
SYNONYM - EAM_WORK_ORDER_BILLS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WIP_EAM_PARAMETERS
SYNONYM - WIP_OPERATION_RESOURCES
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_BILL_BY_REQUIREMENTS_V is not referenced by any database object

[top of page]

View: EAM_CAPT_BILL_BY_REQ_V

[top of page]

APPS.EAM_CAPT_BILL_BY_REQ_V references the following:

APPS
SYNONYM - BOM_RESOURCES
VIEW - EAM_DIRECT_ITEM_RECS_V
SYNONYM - EAM_WORK_ORDER_BILLS
PACKAGE - FND_GLOBAL
SYNONYM - WIP_EAM_PARAMETERS
SYNONYM - WIP_OPERATION_RESOURCES
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_CAPT_BILL_BY_REQ_V is not referenced by any database object

[top of page]

View: EAM_CFR_COUNTER_READINGS_V

[top of page]

APPS.EAM_CFR_COUNTER_READINGS_V references the following:

APPS
PACKAGE - CSI_COUNTER_READINGS_PVT
VIEW - CSI_COUNTER_READINGS_V
VIEW - CSI_LOOKUPS

APPS.EAM_CFR_COUNTER_READINGS_V is not referenced by any database object

[top of page]

View: EAM_CFR_ISSUED_SERIALS_V

[top of page]

APPS.EAM_CFR_ISSUED_SERIALS_V references the following:

APPS
SYNONYM - CSI_COUNTER_ASSOCIATIONS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - MTL_UNIT_TRANSACTIONS
- EAM_COUNTERS_V
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_CFR_ISSUED_SERIALS_V is not referenced by any database object

[top of page]

View: EAM_CFR_MATERIALS_V

[top of page]

APPS.EAM_CFR_MATERIALS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
PACKAGE - EAM_MATERIAL_ALLOCQTY_PKG
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MFG_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_CFR_MATERIALS_V is not referenced by any database object

[top of page]

View: EAM_CFR_OPERATIONS_V

[top of page]

APPS.EAM_CFR_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_STANDARD_OPERATIONS
SYNONYM - WIP_OPERATIONS
- MFG_LOOKUPS

APPS.EAM_CFR_OPERATIONS_V is not referenced by any database object

[top of page]

View: EAM_CFR_QA_PLANS_V

[top of page]

APPS.EAM_CFR_QA_PLANS_V references the following:

APPS
SYNONYM - QA_PLANS
SYNONYM - QA_RESULTS

APPS.EAM_CFR_QA_PLANS_V is not referenced by any database object

[top of page]

View: EAM_CFR_RESOURCES_V

[top of page]

APPS.EAM_CFR_RESOURCES_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_RESOURCES
SYNONYM - WIP_OPERATION_RESOURCES
- MFG_LOOKUPS

APPS.EAM_CFR_RESOURCES_V is not referenced by any database object

[top of page]

View: EAM_CFR_WORK_COMPLETION_V

[top of page]

APPS.EAM_CFR_WORK_COMPLETION_V references the following:

APPS
SYNONYM - EAM_JOB_COMPLETION_TXNS
SYNONYM - MTL_PARAMETERS
- MTL_ITEM_LOCATIONS_KFV
- MFG_LOOKUPS

APPS.EAM_CFR_WORK_COMPLETION_V is not referenced by any database object

[top of page]

View: EAM_CFR_WORK_ORDER_V

[top of page]

APPS.EAM_CFR_WORK_ORDER_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - EAM_ASSET_STATUS_HISTORY
PACKAGE - EAM_COMMON_UTILITIES_PVT
SYNONYM - EAM_WORK_ORDER_DETAILS
SYNONYM - EAM_WO_STATUSES_V
PACKAGE - FND_MESSAGE
SYNONYM - MTL_PARAMETERS
PACKAGE - PJM_PROJECT
SYNONYM - PN_LOCATIONS_ALL
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_SCHEDULE_GROUPS
- MTL_SYSTEM_ITEMS_KFV
- MFG_LOOKUPS

APPS.EAM_CFR_WORK_ORDER_V is not referenced by any database object

[top of page]

View: EAM_CHECKED_OUT_ASSETS_V

[top of page]

APPS.EAM_CHECKED_OUT_ASSETS_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - EAM_ASSET_OPERATION_TXN
SYNONYM - MTL_PARAMETERS

APPS.EAM_CHECKED_OUT_ASSETS_V is not referenced by any database object

[top of page]

View: EAM_CONTROL_EVENT_V

[top of page]

APPS.EAM_CONTROL_EVENT_V references the following:

APPS
SYNONYM - EAM_CONTROL_EVENT
- MFG_LOOKUPS

APPS.EAM_CONTROL_EVENT_V is not referenced by any database object

[top of page]

View: EAM_COUNTERS_V

[top of page]

APPS.EAM_COUNTERS_V references the following:

APPS
SYNONYM - CSI_COUNTERS_B
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_COUNTER_RELATIONSHIPS
SYNONYM - CSI_COUNTER_TEMPLATE_B
SYNONYM - CSI_COUNTER_TEMPLATE_TL

APPS.EAM_COUNTERS_V is not referenced by any database object

[top of page]

View: EAM_DIRECT_ITEMS_RECS_LITE_V

[top of page]

APPS.EAM_DIRECT_ITEMS_RECS_LITE_V references the following:

APPS
VIEW - EAM_WO_DIRECT_ITEMS_LITE_V
VIEW - EAM_WO_REQ_PO_LITE_V
SYNONYM - WIP_EAM_DIRECT_ITEMS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MFG_LOOKUPS
- MTL_CATEGORIES_KFV
- MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_DIRECT_ITEMS_RECS_LITE_V is not referenced by any database object

[top of page]

View: EAM_DIRECT_ITEMS_V

[top of page]

APPS.EAM_DIRECT_ITEMS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CST_EAM_WO_ESTIMATE_DETAILS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_DIRECT_ITEMS_V is not referenced by any database object

[top of page]

View: EAM_DIRECT_ITEM_RECS_V

[top of page]

APPS.EAM_DIRECT_ITEM_RECS_V references the following:

APPS
VIEW - EAM_WORK_ORDER_DIRECT_ITEMS_V
VIEW - EAM_WORK_ORDER_REQ_PO_V
PACKAGE - FND_GLOBAL
VIEW - GL_SETS_OF_BOOKS
SYNONYM - HR_ORGANIZATION_INFORMATION
VIEW - MFG_LOOKUPS
SYNONYM - MTL_CATEGORIES_KFV
VIEW - MTL_SYSTEM_ITEMS_B_KFV
SYNONYM - WIP_EAM_DIRECT_ITEMS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
APPS.EAM_DIRECT_ITEM_RECS_V is referenced by following:

APPS
VIEW - EAM_CAPT_BILL_BY_REQ_V
VIEW - WIP_EAM_REQUIREMENTS_ALL_V

[top of page]

View: EAM_FAILUREINFO_V

[top of page]

APPS.EAM_FAILUREINFO_V references the following:

APPS
SYNONYM - EAM_ASSET_FAILURES
SYNONYM - EAM_ASSET_FAILURE_CODES
SYNONYM - EAM_CAUSE_CODES
SYNONYM - EAM_FAILURE_CODES
SYNONYM - EAM_FAILURE_SETS
SYNONYM - EAM_FAILURE_SET_ASSOCIATIONS
SYNONYM - EAM_RESOLUTION_CODES
SYNONYM - EAM_WORK_ORDER_DETAILS
SYNONYM - WIP_DISCRETE_JOBS

APPS.EAM_FAILUREINFO_V is not referenced by any database object

[top of page]

View: EAM_FAILURE_CODES_V

[top of page]

APPS.EAM_FAILURE_CODES_V references the following:

APPS
SYNONYM - EAM_CAUSE_CODES
SYNONYM - EAM_FAILURE_CODES
SYNONYM - EAM_RESOLUTION_CODES
- MFG_LOOKUPS

APPS.EAM_FAILURE_CODES_V is not referenced by any database object

[top of page]

View: EAM_FAILURE_COMBINATIONS_V

[top of page]

APPS.EAM_FAILURE_COMBINATIONS_V references the following:

APPS
SYNONYM - EAM_CAUSE_CODES
SYNONYM - EAM_FAILURE_CODES
SYNONYM - EAM_FAILURE_COMBINATIONS
SYNONYM - EAM_RESOLUTION_CODES

APPS.EAM_FAILURE_COMBINATIONS_V is not referenced by any database object

[top of page]

View: EAM_FAILURE_SET_ASSOCIATIONS_V

[top of page]

APPS.EAM_FAILURE_SET_ASSOCIATIONS_V references the following:

APPS
SYNONYM - EAM_FAILURE_SET_ASSOCIATIONS

APPS.EAM_FAILURE_SET_ASSOCIATIONS_V is not referenced by any database object

[top of page]

View: EAM_FORECAST_WORK_ORDER_V

[top of page]

APPS.EAM_FORECAST_WORK_ORDER_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - EAM_FORECAST_WDJ
SYNONYM - EAM_ORG_MAINT_DEFAULTS
PACKAGE - FND_PROFILE
SYNONYM - MTL_EAM_LOCATIONS
SYNONYM - MTL_PARAMETERS
PACKAGE - PA_TASK_UTILS
SYNONYM - WIP_ENTITIES
- MTL_SYSTEM_ITEMS_KFV
- PJM_TASKS_V
- MFG_LOOKUPS

APPS.EAM_FORECAST_WORK_ORDER_V is not referenced by any database object

[top of page]

View: EAM_INSTANCES

[top of page]

APPS.EAM_INSTANCES references the following:

APPS
SYNONYM - BOM_RESOURCES
SYNONYM - BOM_RESOURCE_EMPLOYEES
SYNONYM - BOM_RESOURCE_EQUIPMENTS
SYNONYM - PER_ALL_PEOPLE_F
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_INSTANCES is not referenced by any database object

[top of page]

View: EAM_ISOLATION_STATUSES_VL

[top of page]

APPS.EAM_ISOLATION_STATUSES_VL references the following:

APPS
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_B
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_TL
- MFG_LOOKUPS

APPS.EAM_ISOLATION_STATUSES_VL is not referenced by any database object

[top of page]

View: EAM_MANAGE_REQS_V

[top of page]

APPS.EAM_MANAGE_REQS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_HZ_SR_CONTACT_POINTS
VIEW - CS_INCIDENTS_B_SEC
VIEW - CS_INCIDENTS_VL_SEC
SYNONYM - CS_INCIDENT_STATUSES_B
SYNONYM - CS_INCIDENT_STATUSES_TL
VIEW - CS_INCIDENT_TYPES_VL_SEC
SYNONYM - FND_USER
SYNONYM - HZ_PARTIES
SYNONYM - WIP_EAM_WORK_REQUESTS
- MTL_SYSTEM_ITEMS_KFV
- MTL_SYSTEM_ITEMS_B_KFV
- MFG_LOOKUPS

APPS.EAM_MANAGE_REQS_V is not referenced by any database object

[top of page]

View: EAM_MATERIALS_V

[top of page]

APPS.EAM_MATERIALS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CST_EAM_WO_ESTIMATE_DETAILS
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_MATERIALS_V is not referenced by any database object

[top of page]

View: EAM_METER_READINGS_INTERFACE_V

[top of page]

APPS.EAM_METER_READINGS_INTERFACE_V references the following:

APPS
SYNONYM - EAM_METERS
SYNONYM - EAM_METER_READINGS_INTERFACE
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - WIP_ENTITIES
- MFG_LOOKUPS
- ORG_ORGANIZATION_DEFINITIONS

APPS.EAM_METER_READINGS_INTERFACE_V is not referenced by any database object

[top of page]

View: EAM_METER_READINGS_V

[top of page]

APPS.EAM_METER_READINGS_V references the following:

APPS
SYNONYM - CSI_COUNTER_READINGS
SYNONYM - CSI_TRANSACTIONS
- EAM_COUNTERS_V

APPS.EAM_METER_READINGS_V is not referenced by any database object

[top of page]

View: EAM_NEXT_OPERATIONS_V

[top of page]

APPS.EAM_NEXT_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - EAM_OP_COMPLETION_TXNS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - WIP_OPERATIONS
SYNONYM - WIP_OPERATION_NETWORKS

APPS.EAM_NEXT_OPERATIONS_V is not referenced by any database object

[top of page]

View: EAM_OPERATIONS_DETAILS_V

[top of page]

APPS.EAM_OPERATIONS_DETAILS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_RESOURCE_EMPLOYEES
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - MTL_SYSTEM_ITEMS_B
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_OPERATIONS
SYNONYM - WIP_OPERATION_RESOURCES
SYNONYM - WIP_OP_RESOURCE_INSTANCES
- MFG_LOOKUPS
- MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_OPERATIONS_DETAILS_V is not referenced by any database object

[top of page]

View: EAM_OP_COMPLETION_TXNS_V

[top of page]

APPS.EAM_OP_COMPLETION_TXNS_V references the following:

APPS
SYNONYM - EAM_OP_COMPLETION_TXNS

APPS.EAM_OP_COMPLETION_TXNS_V is not referenced by any database object

[top of page]

View: EAM_OUTSTANDING_WORK_ORDERS_V

[top of page]

APPS.EAM_OUTSTANDING_WORK_ORDERS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - EAM_FORECASTED_WORK_ORDERS
SYNONYM - EAM_PM_SCHEDULINGS
PACKAGE - FND_MESSAGE
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
- EAM_WO_STATUSES_V
- MTL_EAM_ASSET_ACTIVITIES_V
- EAM_WORK_ORDER_DETAILS_V
- MFG_LOOKUPS

APPS.EAM_OUTSTANDING_WORK_ORDERS_V is not referenced by any database object

[top of page]

View: EAM_PERMIT_STATUSES_VL

[top of page]

APPS.EAM_PERMIT_STATUSES_VL references the following:

APPS
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_B
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_TL
- MFG_LOOKUPS
APPS.EAM_PERMIT_STATUSES_VL is referenced by following:

APPS
VIEW - EAM_SAF_WO_CONCAT_STATUSES_VL

[top of page]

View: EAM_PM_ACTIVITYGROUP_V

[top of page]

APPS.EAM_PM_ACTIVITYGROUP_V references the following:

APPS
SYNONYM - EAM_PM_ACTIVITIES
SYNONYM - EAM_PM_SCHEDULINGS
SYNONYM - MTL_EAM_ASSET_ACTIVITIES
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_PM_ACTIVITYGROUP_V is not referenced by any database object

[top of page]

View: EAM_PM_ASSET_ACTIVITY_V

[top of page]

APPS.EAM_PM_ASSET_ACTIVITY_V references the following:

APPS
VIEW - EAM_ASSET_METERS_V
SYNONYM - MTL_EAM_ASSET_ACTIVITIES
APPS.EAM_PM_ASSET_ACTIVITY_V is referenced by following:

APPS
VIEW - EAM_PM_LAST_SERVICE_V

[top of page]

View: EAM_PM_LAST_SERVICE_V

[top of page]

APPS.EAM_PM_LAST_SERVICE_V references the following:

APPS
VIEW - EAM_PM_ASSET_ACTIVITY_V
SYNONYM - EAM_PM_LAST_SERVICE

APPS.EAM_PM_LAST_SERVICE_V is not referenced by any database object

[top of page]

View: EAM_PM_SCHEDULINGS_V

[top of page]

APPS.EAM_PM_SCHEDULINGS_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - EAM_PM_ACTIVITIES
SYNONYM - EAM_PM_SCHEDULINGS
SYNONYM - EAM_PM_SET_NAMES
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - MTL_EAM_ASSET_ACTIVITIES
SYNONYM - MTL_PARAMETERS
- MTL_SYSTEM_ITEMS_VL
- PER_PEOPLE_F
- MFG_LOOKUPS
- EAM_WO_STATUSES_V

APPS.EAM_PM_SCHEDULINGS_V is not referenced by any database object

[top of page]

View: EAM_PRIOR_OPERATIONS_V

[top of page]

APPS.EAM_PRIOR_OPERATIONS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - EAM_OP_COMPLETION_TXNS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - WIP_OPERATIONS
SYNONYM - WIP_OPERATION_NETWORKS

APPS.EAM_PRIOR_OPERATIONS_V is not referenced by any database object

[top of page]

View: EAM_REBUILD_COMPLETION_JOBS_V

[top of page]

APPS.EAM_REBUILD_COMPLETION_JOBS_V references the following:

APPS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES

APPS.EAM_REBUILD_COMPLETION_JOBS_V is not referenced by any database object

[top of page]

View: EAM_REQUIREMENT_OPERATIONS_V

[top of page]

APPS.EAM_REQUIREMENT_OPERATIONS_V references the following:

APPS
PACKAGE - EAM_MATERIAL_ALLOCQTY_PKG
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- WIP_REQUIREMENT_OPERATIONS_V

APPS.EAM_REQUIREMENT_OPERATIONS_V is not referenced by any database object

[top of page]

View: EAM_RESOURCES_V

[top of page]

APPS.EAM_RESOURCES_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - BOM_RESOURCES
SYNONYM - CST_EAM_WO_ESTIMATE_DETAILS
SYNONYM - WIP_OPERATION_RESOURCES
- MFG_LOOKUPS

APPS.EAM_RESOURCES_V is not referenced by any database object

[top of page]

View: EAM_RUNTIME_INTERVAL_V

[top of page]

APPS.EAM_RUNTIME_INTERVAL_V references the following:

APPS
SYNONYM - CSI_COUNTERS_B
SYNONYM - CSI_COUNTERS_TL
SYNONYM - CSI_COUNTER_TEMPLATE_B
SYNONYM - CSI_COUNTER_TEMPLATE_TL
PACKAGE - EAM_METERS_UTIL
SYNONYM - EAM_PM_LAST_SERVICE
SYNONYM - EAM_PM_SCHEDULINGS
SYNONYM - EAM_PM_SCHEDULING_RULES

APPS.EAM_RUNTIME_INTERVAL_V is not referenced by any database object

[top of page]

View: EAM_SAF_WO_CONCAT_STATUSES_VL

[top of page]

APPS.EAM_SAF_WO_CONCAT_STATUSES_VL references the following:

APPS
VIEW - EAM_PERMIT_STATUSES_VL
VIEW - EAM_WO_STATUSES_VL
- EAM_ISOLATION_STATUSES_VL
- EAM_WORK_CLEARANCE_STATUSES_VL

APPS.EAM_SAF_WO_CONCAT_STATUSES_VL is not referenced by any database object

[top of page]

View: EAM_SERVICE_REQUEST_DETAILS_V

[top of page]

APPS.EAM_SERVICE_REQUEST_DETAILS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
VIEW - CS_INCIDENTS_VL_SEC
SYNONYM - CS_INCIDENT_SEVERITIES_B
SYNONYM - CS_INCIDENT_STATUSES_B
VIEW - CS_INCIDENT_TYPES_VL_SEC
- MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_SERVICE_REQUEST_DETAILS_V is not referenced by any database object

[top of page]

View: EAM_SUPPRESSION_RELATIONS_V

[top of page]

APPS.EAM_SUPPRESSION_RELATIONS_V references the following:

APPS
SYNONYM - EAM_SUPPRESSION_RELATIONS
SYNONYM - MTL_EAM_ASSET_ACTIVITIES
- MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_SUPPRESSION_RELATIONS_V is not referenced by any database object

[top of page]

View: EAM_WORKORDER_DOWNTIME_V

[top of page]

APPS.EAM_WORKORDER_DOWNTIME_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_OPERATIONS

APPS.EAM_WORKORDER_DOWNTIME_V is not referenced by any database object

[top of page]

View: EAM_WORK_ASSET_ROUTE_V

[top of page]

APPS.EAM_WORK_ASSET_ROUTE_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - EAM_WORK_ORDER_ROUTE
SYNONYM - MTL_EAM_NETWORK_ASSETS
SYNONYM - MTL_PARAMETERS
SYNONYM - WIP_DISCRETE_JOBS
- MTL_SYSTEM_ITEMS_KFV

APPS.EAM_WORK_ASSET_ROUTE_V is not referenced by any database object

[top of page]

View: EAM_WORK_CLEARANCE_STATUSES_VL

[top of page]

APPS.EAM_WORK_CLEARANCE_STATUSES_VL references the following:

APPS
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_B
SYNONYM - EAM_SAFETY_USR_DEF_STATUSES_TL
- MFG_LOOKUPS

APPS.EAM_WORK_CLEARANCE_STATUSES_VL is not referenced by any database object

[top of page]

View: EAM_WORK_ORDERS_V

[top of page]

APPS.EAM_WORK_ORDERS_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
VIEW - CS_INCIDENTS_B_SEC
SYNONYM - EAM_ASSET_FAILURES
SYNONYM - EAM_ASSET_FAILURE_CODES
SYNONYM - EAM_JOB_COMPLETION_TXNS
SYNONYM - EAM_WO_RELATIONSHIPS
SYNONYM - EAM_WO_SERVICE_ASSOCIATION
PACKAGE - FND_MESSAGE
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
PACKAGE - PJM_PROJECT
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_SCHEDULE_GROUPS
- MTL_SYSTEM_ITEMS_KFV
- EAM_WORK_ORDER_DETAILS_V
- MFG_LOOKUPS

APPS.EAM_WORK_ORDERS_V is not referenced by any database object

[top of page]

View: EAM_WORK_ORDER_BILL_DETAILS_V

[top of page]

APPS.EAM_WORK_ORDER_BILL_DETAILS_V references the following:

APPS
SYNONYM - EAM_WORK_ORDER_BILLS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - PA_TASKS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL
SYNONYM - WIP_ENTITIES
- PA_PROJECTS_ALL

APPS.EAM_WORK_ORDER_BILL_DETAILS_V is not referenced by any database object

[top of page]

View: EAM_WORK_ORDER_DETAILS_V

[top of page]

APPS.EAM_WORK_ORDER_DETAILS_V references the following:

APPS
SYNONYM - EAM_CONSTRUCTION_ESTIMATES
SYNONYM - EAM_WORK_ORDER_DETAILS
SYNONYM - EAM_WO_STATUSES_V
PACKAGE - FND_MESSAGE
VIEW - MFG_LOOKUPS
APPS.EAM_WORK_ORDER_DETAILS_V is referenced by following:

APPS
VIEW - WIP_EAM_CST_HEADER_V
VIEW - WIP_EAM_ENTITIES_V
VIEW - WIP_EAM_WORK_ORDERS_V
VIEW - WIP_EAM_WO_SRV_ASSOC_V

[top of page]

View: EAM_WORK_ORDER_DIRECT_ITEMS_V

[top of page]

APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - MFG_LOOKUPS
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL
SYNONYM - WIP_EAM_DIRECT_ITEMS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
APPS.EAM_WORK_ORDER_DIRECT_ITEMS_V is referenced by following:

APPS
VIEW - EAM_DIRECT_ITEM_RECS_V

[top of page]

View: EAM_WORK_ORDER_REQ_PO_V

[top of page]

APPS.EAM_WORK_ORDER_REQ_PO_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - PO_VENDOR_SITES_ALL
APPS.EAM_WORK_ORDER_REQ_PO_V is referenced by following:

APPS
VIEW - EAM_DIRECT_ITEM_RECS_V

[top of page]

View: EAM_WORK_REQUEST_ASSOC_V

[top of page]

APPS.EAM_WORK_REQUEST_ASSOC_V references the following:

APPS
SYNONYM - BOM_DEPARTMENTS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_HZ_SR_CONTACT_POINTS
VIEW - CS_INCIDENTS_B_SEC
VIEW - CS_INCIDENTS_VL_SEC
SYNONYM - CS_INCIDENT_STATUSES_B
SYNONYM - CS_INCIDENT_STATUSES_TL
VIEW - CS_INCIDENT_TYPES_VL_SEC
SYNONYM - EAM_WO_SERVICE_ASSOCIATION
SYNONYM - FND_USER
SYNONYM - HZ_PARTIES
SYNONYM - WIP_EAM_WORK_REQUESTS
- MTL_SYSTEM_ITEMS_KFV
- MTL_SYSTEM_ITEMS_B_KFV
- MFG_LOOKUPS

APPS.EAM_WORK_REQUEST_ASSOC_V is not referenced by any database object

[top of page]

View: EAM_WO_DIRECT_ITEMS_LITE_V

[top of page]

APPS.EAM_WO_DIRECT_ITEMS_LITE_V references the following:

APPS
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - WIP_EAM_DIRECT_ITEMS
SYNONYM - WIP_REQUIREMENT_OPERATIONS
- MFG_LOOKUPS
- MTL_SYSTEM_ITEMS_KFV
APPS.EAM_WO_DIRECT_ITEMS_LITE_V is referenced by following:

APPS
VIEW - EAM_DIRECT_ITEMS_RECS_LITE_V

[top of page]

View: EAM_WO_REQ_PO_LITE_V

[top of page]

APPS.EAM_WO_REQ_PO_LITE_V references the following:

APPS
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
- MTL_UNITS_OF_MEASURE
- PO_LINE_TYPES
APPS.EAM_WO_REQ_PO_LITE_V is referenced by following:

APPS
VIEW - EAM_DIRECT_ITEMS_RECS_LITE_V

[top of page]

View: EAM_WO_STATUSES_VL

[top of page]

APPS.EAM_WO_STATUSES_VL references the following:

APPS
SYNONYM - EAM_WO_STATUSES_B
SYNONYM - EAM_WO_STATUSES_TL
VIEW - MFG_LOOKUPS
APPS.EAM_WO_STATUSES_VL is referenced by following:

APPS
VIEW - EAM_SAF_WO_CONCAT_STATUSES_VL
SYNONYM - EAM_WO_STATUSES_V

[top of page]



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