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_STATUS_HISTORY
TABLE - EAM.EAM_ASSET_TEXT
TABLE - EAM.EAM_CAUSE_CODES
TABLE - EAM.EAM_CONSTRUCTION_ESTIMATES
TABLE - EAM.EAM_CONSTRUCTION_UNITS
TABLE - EAM.EAM_CONSTRUCTION_UNIT_DETAILS
TABLE - EAM.EAM_CONTROL_EVENT
TABLE - EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL
TABLE - EAM.EAM_EMP_SEARCH_RESULT_TBL
TABLE - EAM.EAM_ENABLE_WORKFLOW
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_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_SUPPRESSION_RELATIONS
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_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_DIRECT_ITEMS_V
VIEW - APPS.EAM_INSTANCES
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_OP_COMPLETION_TXNS_V
VIEW - APPS.EAM_OUTSTANDING_WORK_ORDERS_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_RESOURCES_V
VIEW - APPS.EAM_RUNTIME_INTERVAL_V
VIEW - APPS.EAM_SERVICE_REQUEST_DETAILS_V
VIEW - APPS.EAM_SUPPRESSION_RELATIONS_V
VIEW - APPS.EAM_WORK_ORDERS_V
VIEW - APPS.EAM_WORK_ORDER_BILL_DETAILS_V

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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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_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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - EAM_CAUSE_CODES

[top of page]

Table: EAM_CONSTRUCTION_ESTIMATES

Description: Estimations based on Construction Units
Primary Key: ECE_PK
  1. ESTIMATE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
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:

APPS
SYNONYM - EAM_CONSTRUCTION_ESTIMATES

[top of page]

Table: EAM_CONSTRUCTION_UNITS

Description: This table stores the template for construction units. Estimates are build for these construction units.
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:

APPS
SYNONYM - EAM_CONSTRUCTION_UNITS

[top of page]

Table: EAM_CONSTRUCTION_UNIT_DETAILS

Description: Table to store the construction unit and activity associations
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:

APPS
SYNONYM - 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:

APPS
SYNONYM - EAM_CONTROL_EVENT

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

APPS
SYNONYM - EAM_ENABLE_WORKFLOW

[top of page]

Table: EAM_ESTIMATE_ASSOCIATIONS

Description: Association table for Estimates and Construction Units
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 %

[top of page]

EAM.EAM_ESTIMATE_ASSOCIATIONS does not reference any database object

EAM.EAM_ESTIMATE_ASSOCIATIONS is referenced by following:

APPS
SYNONYM - 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

[top of page]

EAM.EAM_FAILURE_CODES does not reference any database object

EAM.EAM_FAILURE_CODES is referenced by following:

APPS
SYNONYM - 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_COMBINATIONS.FAILURE_CODE %
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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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

[top of page]

EAM.EAM_FAILURE_SETS does not reference any database object

EAM.EAM_FAILURE_SETS is referenced by following:

APPS
SYNONYM - 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 %

[top of page]

EAM.EAM_FAILURE_SET_ASSOCIATIONS does not reference any database object

EAM.EAM_FAILURE_SET_ASSOCIATIONS is referenced by following:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - EAM_FORECAST_WRO

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

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - EAM_RESOURCE_USAGE_IMPORT

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

APPS
SYNONYM - EAM_SUPPRESSION_RELATIONS

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

APPS
SYNONYM - 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

[top of page]

EAM.EAM_WORK_ORDER_DETAILS does not reference any database object

EAM.EAM_WORK_ORDER_DETAILS is referenced by following:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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:

APPS
SYNONYM - EAM_WORK_ORDER_TEXT

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

APPS
SYNONYM - 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:

APPS
SYNONYM - 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

[top of page]

EAM.EAM_WO_STATUSES_B does not reference any database object

EAM.EAM_WO_STATUSES_B is referenced by following:

APPS
SYNONYM - 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 %

[top of page]

EAM.EAM_WO_STATUSES_TL does not reference any database object

EAM.EAM_WO_STATUSES_TL is referenced by following:

APPS
SYNONYM - 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:

APPS
SYNONYM - 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
VIEW - 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
VIEW - MFG_LOOKUPS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_EAM_PARAMETERS

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 - MTL_SYSTEM_ITEMS_KFV
SYNONYM - WIP_EAM_PARAMETERS
SYNONYM - WIP_OPERATION_RESOURCES
SYNONYM - WIP_REQUIREMENT_OPERATIONS

APPS.EAM_BILL_BY_REQUIREMENTS_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 - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL

APPS.EAM_DIRECT_ITEMS_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 - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PER_ALL_PEOPLE_F

APPS.EAM_INSTANCES 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
SYNONYM - 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
VIEW - MFG_LOOKUPS
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - WIP_ENTITIES

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
VIEW - EAM_COUNTERS_V
APPS.EAM_METER_READINGS_V is referenced by following:

APPS
PACKAGE BODY - EAM_FAILURE_ANALYSIS_PVT
PACKAGE BODY - EAM_METERS_UTIL

[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 referenced by following:

APPS
PACKAGE BODY - EAM_OPERATIONS_JSP

[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 referenced by following:

APPS
PACKAGE BODY - EAM_WORKORDERREP_PVT

[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
VIEW - EAM_WORK_ORDER_DETAILS_V
SYNONYM - EAM_WO_STATUSES_V
PACKAGE - FND_MESSAGE
VIEW - MFG_LOOKUPS
VIEW - MTL_EAM_ASSET_ACTIVITIES_V
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES

APPS.EAM_OUTSTANDING_WORK_ORDERS_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_SCHEDULINGS
SYNONYM - EAM_PM_SET_NAMES
SYNONYM - EAM_WO_STATUSES_V
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_B_KFV
VIEW - PER_PEOPLE_F

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 referenced by following:

APPS
PACKAGE BODY - EAM_OPERATIONS_JSP

[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_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
VIEW - MFG_LOOKUPS
SYNONYM - WIP_OPERATION_RESOURCES

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_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
VIEW - 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
VIEW - MTL_SYSTEM_ITEMS_B_KFV

APPS.EAM_SUPPRESSION_RELATIONS_V 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
SYNONYM - CS_INCIDENTS_B_SEC
SYNONYM - EAM_ASSET_FAILURES
SYNONYM - EAM_ASSET_FAILURE_CODES
SYNONYM - EAM_JOB_COMPLETION_TXNS
VIEW - EAM_WORK_ORDER_DETAILS_V
SYNONYM - EAM_WO_RELATIONSHIPS
SYNONYM - EAM_WO_SERVICE_ASSOCIATION
PACKAGE - FND_MESSAGE
VIEW - MFG_LOOKUPS
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - PJM_PROJECT
SYNONYM - WIP_DISCRETE_JOBS
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_SCHEDULE_GROUPS
APPS.EAM_WORK_ORDERS_V is referenced by following:

APPS
PACKAGE BODY - EAM_WORKORDERREP_PVT

[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_PROJECTS_ALL
SYNONYM - PA_TASKS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL
SYNONYM - WIP_ENTITIES

APPS.EAM_WORK_ORDER_BILL_DETAILS_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract