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
Comments

This is a temporary table used to explode asset hierarchy information.

Indexes
Index Type Tablespace Column
EAM_ASSET_EXPLOSION_TEMP_N1 NONUNIQUE APPS_TS_NOLOGGING GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Exploder Process Group Identifier
ASSET_GROUP_ID NUMBER

Asset Group Identifier
ASSET_NUMBER VARCHAR2 (30) Y Asset Number Identifier
LOW_LEVEL_CODE NUMBER

Explosion Level Code

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

This table stores failure events reported against an Asset in the context of a business flow. Eg. Failure can be reported against an Asset during the lifecycle of a Work Order. The failure table stores the denormalized information about an Asset, the source object in context of which the Failure was logged and other key information about an Asset at the time of the failure reporting.

For every failure on an asset an entry goes in to this table if the Failure Entry is required at the work order level. Also for this release restricted source_type to always 1 (Work Order) which means that the failure entry is at the Work Order level.

Indexes
Index Type Tablespace Column
EAM_ASSET_FAILURES_U1 UNIQUE APPS_TS_TX_IDX FAILURE_ID
EAM_ASSET_FAILURES_U2 UNIQUE APPS_TS_TX_IDX SOURCE_ID
EAM_ASSET_FAILURES_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
FAILURE_ID NUMBER
Y Unique failure identifier
FAILURE_DATE DATE

Failure date
SOURCE_TYPE NUMBER
Y Source type of the failure record. Source Type value 1 corresponds to Work Order.
SOURCE_ID NUMBER
Y Source identifier for the failure record. Source id maps to wip entity id for source type 1.
OBJECT_TYPE NUMBER
Y Object type identifier indicates table where asset is stored. MSN for 11i10.
OBJECT_ID NUMBER
Y Asset or rebuildable serial identifier. Gen object id from mtl_serial_numbers.
MAINT_ORGANIZATION_ID NUMBER
Y Maintenance organization identifier
DEPARTMENT_ID NUMBER

Department identifier at work order level or asset level.
AREA_ID NUMBER

Area Identifier. Same as EAM_LOCATION_ID
CURRENT_ORGANIZATION_ID NUMBER

Identifier of asset owning organization at the time of failure.
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This table stores the detail information captured for a failure event i.e. failure code, cause code, resolution code and the comments entered by the user in the context of an Workorder (E.g. Work Order). This is a child table of its parent EAM_ASSET_FAILURES table.
As per the design, one failure reported for an Asset can have one failure code combinations(combination_id). Currently the Oracle Enterprise Asset Management application UIs restricts only one set of codes to be reported against an Asset.

Indexes
Index Type Tablespace Column
EAM_ASSET_FAILURE_CODES_U1 UNIQUE APPS_TS_TX_IDX FAILURE_ENTRY_ID
EAM_ASSET_FAILURE_CODES_U2 UNIQUE APPS_TS_TX_IDX FAILURE_ID
FAILURE_CODE
CAUSE_CODE
RESOLUTION_CODE
Columns
Name Datatype Length Mandatory Comments
FAILURE_ID NUMBER
Y Failure identifier
FAILURE_ENTRY_ID NUMBER
Y Failure Entry Id
COMBINATION_ID NUMBER

Identifier for failure combination.
FAILURE_CODE VARCHAR2 (80)
Identifier for failure code
CAUSE_CODE VARCHAR2 (80)
Identifier for cause code
RESOLUTION_CODE VARCHAR2 (80)
Identifier for resolution code
COMMENTS VARCHAR2 (2000)
Failure comment
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[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.
Comments

This Table stores information of Assets for various events whose Operational
Logs are intented to be capture by enabling selective events at organization
level and at the Asset level. The events are classified as System Events such
as Create Work Requests, Work Order Events, Geneology Changes such as
Add/Remove Child or Parent Events, Activate or De-Activate Asset Events,
Meter Readings Entry, Collection Plan Entry during Work Order Completion and
Asset Operational events such as Check-In or Check-Out. This table also
captures inventory events like Location Transfer of Assets.
Other than System Events, Operational Events such as Resource Up, Down and
Acknowledge Down are supported part of OSFM events. User Defined Events are
supported.
This table holds details of the instance, event type and event id, reference
of the event date at which the event happened with the reference of the
transaction and the user who performed the event with user enterable comments
and the organization information. It also holds resource and resource
instance information and reason for the event and operational status of the
asset during the event optionally.

Indexes
Index Type Tablespace Column
EAM_ASSET_LOG_N1 NONUNIQUE APPS_TS_TX_IDX INSTANCE_ID
EAM_ASSET_LOG_N2 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
DEPARTMENT_ID
EVENT_DATE
EQUIPMENT_GEN_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Y Entity identifier
EVENT_DATE DATE
Y Event date
EVENT_TYPE VARCHAR2 (30)
Event Type Code ('EAM_SYSTEM_EVENTS', 'EAM_USER_EVENTS','EAM_OPERATIONAL_EVENTS')
EVENT_ID NUMBER

Event Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
INSTANCE_ID NUMBER

Asset Number Identifier
REFERENCE VARCHAR2 (80)
Additional information associated with the event
REF_ID NUMBER

Depending on event_type, it will store primary key to identify the event.
OPERABLE NUMBER

Operable Status Identifier (1- Operable2 - Non operable)
REASON_CODE NUMBER

Reason Code
RESOURCE_ID NUMBER

Resource Identifier
COMMENTS VARCHAR2 (2000)
Comments regarding the event
DOWN_CODE NUMBER

Down Code
RESOURCE_SERIAL_NUMBER VARCHAR2 (30)
Asset Number of the instance
EXPECTED_UP_DATE DATE

Expected operational date of the Resource
SOURCE_LOG_ID NUMBER

Source Transaction Id (OSFM requirement)
EMPLOYEE_ID NUMBER

Employee identifier who performed the transaction
DEPARTMENT_ID NUMBER

Department identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure identifier
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
EQUIPMENT_GEN_OBJECT_ID NUMBER

Genealogy object identifier

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

This table stores association information between Assets and Meters. It stores asset information as well as meter attributes.

Indexes
Index Type Tablespace Column
EAM_ASSET_METERS_N1 NONUNIQUE APPS_TS_TX_IDX METER_ID
EAM_ASSET_METERS_N2 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
ASSET_GROUP_ID
ASSET_NUMBER
EAM_ASSET_METERS_N3 NONUNIQUE APPS_TS_TX_IDX MAINTENANCE_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
METER_ID NUMBER
Y Unique identifier of the meter
ORGANIZATION_ID NUMBER
Y Organization Identifier
ASSET_GROUP_ID NUMBER
Y Asset Group Identifier
ASSET_NUMBER VARCHAR2 (30)
Asset Number identifier
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
MAINTENANCE_OBJECT_ID NUMBER

Object ID
CREATION_ORGANIZATION_ID NUMBER

Creation Organization identifier
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag
PRIMARY_FAILURE_METER VARCHAR2 (1)
Flag indicating whether the meter is the primary failure analysis meter for the asset

[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:
Comments
Primary Key: EAM_ASSET_MOVE_TEMP_PK
  1. INSTANCE_ID
Indexes
Index Type Tablespace Column
EAM_ASSET_MOVE_TEMP_PK UNIQUE INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER
Y
SERIAL_NUMBER VARCHAR2 (30) Y
GEN_OBJECT_ID NUMBER
Y
INVENTORY_ITEM_ID NUMBER
Y
CURRENT_ORG_ID NUMBER
Y
CURRENT_SUBINVENTORY_CODE VARCHAR2 (10)
EAM_ITEM_TYPE NUMBER
Y
MAINT_ORG_ID NUMBER
Y
PREPARE_STATUS VARCHAR2 (240)
PREPARE_MSG VARCHAR2 (4000)
TRANSACTION_STATUS VARCHAR2 (240)
TRANSACTION_MSG VARCHAR2 (4000)
TRANSACTION_HEADER_ID NUMBER

TRANSACTION_INTERFACE_ID NUMBER

[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.
Comments

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

An asset can be either in Checked In status or Checked Out status at any
point in time. The next Operation allowed omn the asset is strictly based on
the current status of the asset.

Assets can be either Checked In by the User who Checked Out or by other user
as well. This table contains informations such as Asset Number, Date of
transaction, Operable status, Check Out For and Checked Out By, Comments,
References of Meter Readings, Collection Plan and Work Requests.

Indexes
Index Type Tablespace Column
EAM_ASSET_OPERATION_TXN_N1 NONUNIQUE APPS_TS_TX_IDX INSTANCE_ID
TXN_DATE
EAM_ASSET_OPERATION_TXN_N2 NONUNIQUE APPS_TS_TX_IDX USER_ID
TXN_TYPE
Columns
Name Datatype Length Mandatory Comments
TXN_ID NUMBER
Y Entity identifier
TXN_DATE DATE
Y Transaction date
TXN_TYPE NUMBER
Y Transaction Type Identifier (1 - Check In 2 - Check Out)
INSTANCE_ID NUMBER
Y Asset Number Identifier
COMMENTS VARCHAR2 (2000)
Comments about the transaction
USER_ID NUMBER
Y Employee identifier carrying out the transaction
OPERABLE NUMBER
Y Operable Status Identifier (1- Operable2 - Non operable)
QA_COLLECTION_ID NUMBER

Quality collection results identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure identifier
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[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:
Comments
Indexes
Index Type Tablespace Column
EAM_ASSET_RESULTS_GTT_U1 UNIQUE GEN_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
GEN_OBJECT_ID NUMBER

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

This table stores history of assets being shutdown. It stores the asset information, the date when the shutdown started, the date when the shutdown ended, and the information of the work order which caused the shutdown.

Indexes
Index Type Tablespace Column
EAM_ASSET_STATUS_HISTORY_U1 UNIQUE APPS_TS_TX_IDX ASSET_STATUS_ID
EAM_ASSET_STATUS_HISTORY_N2 NONUNIQUE APPS_TS_TX_IDX MAINTENANCE_OBJECT_ID
MAINTENANCE_OBJECT_TYPE
START_DATE
END_DATE
EAM_ASSET_STATUS_HISTORY_N3 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
ASSET_STATUS_ID NUMBER
Y Asset status identifier
ORGANIZATION_ID NUMBER
Y Organization identifier
ASSET_GROUP_ID NUMBER
Y Asset group identifier
ASSET_NUMBER VARCHAR2 (30) Y Asset number identifier
START_DATE DATE
Y Shutdown start date
END_DATE DATE
Y Shutdown end date
WIP_ENTITY_ID NUMBER

Work order identifier
OPERATION_SEQ_NUM NUMBER

Operation identifier
DESCRIPTION VARCHAR2 (240)
Shutdown description
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
MAINTENANCE_OBJECT_ID NUMBER

Object ID
ENABLE_FLAG VARCHAR2 (1)
Enable Flag

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

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

Indexes
Index Type Tablespace Column
EAM_ASSET_TEXT_U1 UNIQUE APPS_TS_TX_IDX INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER

Instance Id of the Asset defined in csi_item_instances
TEXT VARCHAR2 (1)
Column (dummy) for creating the text (intermedia) index
CREATED_BY NUMBER

Keeps track of which user created each row
CREATION_DATE DATE

Stores the date on which each row was created
LAST_UPDATED_BY NUMBER

Keeps track of who last updated each row
LAST_UPDATE_DATE DATE

Stores the date on which each row was last updated
LAST_UPDATE_LOGIN NUMBER

Provides access to information about the operating system login of the user who last updated each row

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

This table stores cause code definition. As a failure cause is identified, Cause code is typically the second code reported by the user for a failure. As an example for a printer jam failure, Cause Code could be BADBELT and it's description could be Bad Printer Belt.

Indexes
Index Type Tablespace Column
EAM_CAUSE_CODES_U1 UNIQUE APPS_TS_TX_IDX CAUSE_CODE
Columns
Name Datatype Length Mandatory Comments
CAUSE_CODE VARCHAR2 (80) Y Unique identifier for cause code
DESCRIPTION VARCHAR2 (2000)
Cause code description
EFFECTIVE_END_DATE DATE

End date beyond which cause code is inactive
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

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

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
- Flexfields information

Columns
Name Datatype Length Mandatory Comments
ESTIMATE_ID NUMBER
Y Unique Identifier for a Construction Estimate
ORGANIZATION_ID NUMBER
Y Associated organization ID
ESTIMATE_NUMBER VARCHAR2 (30) Y A unique number to identify the construction estimate
ESTIMATE_DESCRIPTION VARCHAR2 (240)
Description of the Construction Estimate
GROUPING_OPTION NUMBER (1)
Grouping option for creating work orders
PARENT_WO_ID NUMBER

Parent work order ID, can be an existing WIP entity ID or an estimate work order ID
CREATE_PARENT_WO_FLAG VARCHAR2 (1)
Flag indicate whether to create a parent work order or using an existing work order
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column

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

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

Indexes
Index Type Tablespace Column
EAM_CU_ORG_ID_N01 NONUNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
CU_ID NUMBER
Y Unique Identifier for Construction Unit
CU_NAME VARCHAR2 (50) Y Name of the Construction uni
DESCRIPTION VARCHAR2 (240)
Description of the Construction Unit
ORGANIZATION_ID NUMBER
Y ID of organization the construction unit belongs to
CU_EFFECTIVE_FROM DATE

Effective from date of the construction unit
CU_EFFECTIVE_TO DATE

Effective to date of the construction unit
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column

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

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

Indexes
Index Type Tablespace Column
EAM_CU_DTL_ID_N01 NONUNIQUE APPS_TS_TX_IDX CU_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
CU_DETAIL_ID NUMBER
Y Unique Identifier to construction unit detail
CU_ID NUMBER
Y Construction unit ID
ACCT_CLASS_CODE VARCHAR2 (10)
Accounting Class Code
ACTIVITY_ID NUMBER
Y Activity Identifier.
CU_ACTIVITY_QTY NUMBER

Quantity associated with that activity to build the defined CU
CU_ACTIVITY_EFFECTIVE_FROM DATE

Date the activity associated to the CU started
CU_ACTIVITY_EFFECTIVE_TO DATE

Date the activity associated to the CU terminated
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY VARCHAR2 (240) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column

[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.
Comments

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

Indexes
Index Type Tablespace Column
EAM_ASSET_LOG_CONTROLS_U1 UNIQUE APPS_TS_TX_IDX ORGANIZATION_ID
EVENT_ID
EVENT_TYPE
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y Organization Identifier
EVENT_TYPE VARCHAR2 (30)
Event Type Code
EVENT_ID NUMBER

Event Identifier
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[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:
Comments
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

WO_END_DT DATE

WO_ST_DT DATE

WORKORDERNAME VARCHAR2 (240)
RESOURCE_CODE VARCHAR2 (10)
UPDATE_SWITCHER VARCHAR2 (30)
USAGE NUMBER

OPERATION_SEQ_NUM NUMBER

RESOURCE_SEQ_NUM NUMBER

PERSON_ID NUMBER

WO_ASSIGN_CHECK CHAR (1)
ASSIGN_SWITCHER VARCHAR2 (30)
INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

EMPLOYEE_NAME VARCHAR2 (240)
FIRM_STATUS NUMBER

[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:
Comments
Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER

EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
INSTANCE_ID NUMBER

RESOURCE_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_CODE VARCHAR2 (10)
DEPARTMENT_CODE VARCHAR2 (10)
ASSIGN_UNASSIGN_ENABLE VARCHAR2 (30)
AVAILABLE_HOURS NUMBER

ASSIGNED_HOURS NUMBER

UNASSIGNED_HOURS NUMBER

ASSIGNED_PERCENTAGE NUMBER

START_DATE DATE

COMPLETION_DATE DATE

DURATION NUMBER

WO_FIRM_STATUS VARCHAR2 (1)
UOM VARCHAR2 (3)

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

This table stores the various maintenance object source values for which workflow is enabled/disabled. There will be a seeded row for Maintenance Object Source of value 1 for EAM. Other product teams will have to populate this table to extend work order workflow functionality of EAM.

Columns
Name Datatype Length Mandatory Comments
MAINTENANCE_OBJECT_SOURCE NUMBER
Y Maintenance object source value for which workflow is enabled/disabled
ENABLE_WORKFLOW VARCHAR2 (1)
Enable Workflow
CREATION_DATE DATE

Standard Who Columns
LAST_UPDATE_DATE DATE

Standard Who Columns
CREATED_BY NUMBER

Standard Who Columns
LAST_UPDATED_BY NUMBER

Standard Who Columns
LAST_UPDATE_LOGIN NUMBER

Standard Who Columns

[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 %
Comments

This table contains all the association data for an estimate. The association data include the following
- Construction unit
- Construction unit Qty
- Activity
- Activity Qty
- Difficulty Code and Resource Multiplier
Note: The association data is not retained after creating work order lines.

Columns
Name Datatype Length Mandatory Comments
ESTIMATE_ASSOCIATION_ID NUMBER
Y Unique Identifier for a construction estimate association
ORGANIZATION_ID NUMBER
Y Associated organization ID
ESTIMATE_ID NUMBER
Y Construction estimate ID
CU_ID NUMBER

Construction unit ID
CU_QTY NUMBER

Construction unit quantity
ACCT_CLASS_CODE VARCHAR2 (10)
Accouting Class code of Activity or CU based on the association line
ACTIVITY_ID NUMBER
Y Unique Identifier for an activity
ACTIVITY_QTY NUMBER
Y Activity quantity
DIFFICULTY_ID NUMBER

Difficulty Identifier
RESOURCE_MULTIPLIER NUMBER
Y Resource Multiplier
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column

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

This table stores failure code definition. Failure code is the first code reported by the user when any failure occurs. As an example for a printer jam failure, Failure Code could be PRNTRJAM and its description could be Printer Jam.
Practically, Failure Codes needs to be defined before we go ahead and make Failure Combinations to be used during capturing Failure Information

Indexes
Index Type Tablespace Column
EAM_FAILURE_CODES_U1 UNIQUE APPS_TS_TX_IDX FAILURE_CODE
Columns
Name Datatype Length Mandatory Comments
FAILURE_CODE VARCHAR2 (80) Y Unique identifier for failure code
DESCRIPTION VARCHAR2 (2000)
Failure code description
EFFECTIVE_END_DATE DATE

End date beyond which failure code is inactive
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column

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

This table stores unique combinations of failure code, cause code and resolution code in the context of a failure set. This table is the library of Failure, Cause and Resolution codes put together in a logical combination by a user who manages failure sets to be further used for failure reporting against Assets of a specific type.

Indexes
Index Type Tablespace Column
EAM_FAILURE_COMBINATIONS_U1 UNIQUE APPS_TS_TX_IDX COMBINATION_ID
EAM_FAILURE_COMBINATIONS_U2 UNIQUE APPS_TS_TX_IDX SET_ID
FAILURE_CODE
CAUSE_CODE
RESOLUTION_CODE
Columns
Name Datatype Length Mandatory Comments
COMBINATION_ID NUMBER
Y Sequence generated unique identifier for failure combination.
SET_ID NUMBER
Y Identifier for failure set
FAILURE_CODE VARCHAR2 (80) Y Identifier for failure code
CAUSE_CODE VARCHAR2 (80) Y Identifier for cause code
RESOLUTION_CODE VARCHAR2 (80) Y Identifier for resolution code
EFFECTIVE_END_DATE DATE

End date beyond which combination is inactive
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

Temporary Table used to hold data for displaying Failure History of an Asset in Oracle Applications. Data does not persist in this table and is only used when a user tries to view the Failure History of an Asset.

Indexes
Index Type Tablespace Column
EAM_FAILURE_HISTORY_TEMP_N1 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Y Identifier for performed Search
ASSET_TYPE NUMBER

Asset or Rebuild Item
MAINTENANCE_OBJECT_ID NUMBER

Identifier for Maintenance Object
MAINTAINED_NUMBER VARCHAR2 (30)
Maintained Serial Number
DESCRIPTIVE_TEXT VARCHAR2 (240)
Serial Number Descriptive Text
MAINTAINED_GROUP VARCHAR2 (40)
Concatenated Segments of the Maintained Item
MAINTAINED_GROUP_ID NUMBER

Identifier for the Maintained Item
WIP_ENTITY_ID NUMBER

Identifier for the Work Order
WIP_ENTITY_NAME VARCHAR2 (240)
Work Order Name
ASSET_CATEGORY VARCHAR2 (163)
Concatenated Segments of the Category Asset Number belongs to
ASSET_CATEGORY_ID NUMBER

Identifier for the Category Asset Number belongs to
ASSET_LOCATION VARCHAR2 (30)
Asset Number Location
ORGANIZATION_CODE VARCHAR2 (3)
Maintenance Organization Code
MAINT_ORGANIZATION_ID NUMBER

Identifier for Maintenance Organization
OWNING_DEPARTMENT VARCHAR2 (10)
Maintenance Department Code
FAILURE_CODE VARCHAR2 (80) Y Identifier for failure code
CAUSE_CODE VARCHAR2 (80) Y Identifier for cause code
FAILURE_DATE DATE

Failure Date
RESOLUTION_CODE VARCHAR2 (80)
Identifier for resolution code
DAYS_BETWEEN_FAILURES NUMBER

Days Since Last Failure
TIME_TO_REPAIR NUMBER

Time (Hours) taken to Complete the Work Order since the time Failure was reported
COMMENTS VARCHAR2 (2000)
Failure Comments
METER_NAME VARCHAR2 (50)
Failure Meter Name
METER_UOM VARCHAR2 (3)
Failure Meter UOM
READING_BETWEEN_FAILURES NUMBER

Meter Reading since last Failure
COST_TO_REPAIR NUMBER

Repair Costs of the Failure Work Order
INCLUDE_FOR_READING_AGGR VARCHAR2 (1)
Flag to indicate if the record needs to be considered for the Meter Reading Aggregation
INCLUDE_FOR_COST_AGGR VARCHAR2 (1)
Flag to indicate if the record needs to be considered for the Meter Reading Aggregation

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

This table stores failure set definition. Failure Sets are like a library of Failure, Cause and Resolution codes. Once the failure sets are defined, they need to be associated to Asset Groups for capuring the failure information at the work order level.

Indexes
Index Type Tablespace Column
EAM_FAILURE_SETS_U1 UNIQUE APPS_TS_TX_IDX SET_ID
EAM_FAILURE_SETS_U2 UNIQUE APPS_TS_TX_IDX SET_NAME
Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER
Y Unique identifier for failure set
SET_NAME VARCHAR2 (80) Y Failure set name
DESCRIPTION VARCHAR2 (240)
Failure set description
EFFECTIVE_END_DATE DATE

End date beyond which the failure set is inactive
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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 %
Comments

This table stores association of failure set with asset groups. Failure entry required flag set at the association level would default at the work order level. Whenever a failure is reported against an Asset, a Failure Set library can be used to report the Failure, Cause and Resolution codes.
The associations to Asset Groups established and stored in this table restrict the failure set libraries that can be used for failure reporting.

Indexes
Index Type Tablespace Column
EAM_FAILURESET_ASSOCIATION_U1 UNIQUE APPS_TS_TX_IDX SET_ID
INVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
SET_ID NUMBER
Y Identifier for failure set
INVENTORY_ITEM_ID NUMBER
Y Asset Group or Rebuildable Identifier
FAILURE_CODE_REQUIRED VARCHAR2 (1)
Flag to signify mandatory failure capture
EFFECTIVE_END_DATE DATE

Effective End date indicates deletion of association.
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column

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

This table stores all the forecasted work orders that can be converted into actual work orders. Records in this table are created by the preventive maintenance scheduler. Records are removed when user exits the process.

Indexes
Index Type Tablespace Column
EAM_FORECASTED_WORK_ORDERS_U1 UNIQUE APPS_TS_TX_IDX PM_FORECAST_ID
EAM_FORECASTED_WORK_ORDERS_N1 NONUNIQUE APPS_TS_TX_IDX GROUP_ID
ACTIVITY_ASSOCIATION_ID
Columns
Name Datatype Length Mandatory Comments
PM_FORECAST_ID NUMBER
Y The forecast unique identifier
GROUP_ID NUMBER
Y Group ID
PM_SCHEDULE_ID NUMBER
Y The Preventive Maintenance Schedule ID which generates the forecast
ACTIVITY_ASSOCIATION_ID NUMBER
Y The asset number/asset activity association identifier
SCHEDULED_START_DATE DATE

Scheduled start date of the work order
SCHEDULED_COMPLETION_DATE DATE

Scheduled completion date of the work order
WIP_ENTITY_ID NUMBER

Work Order Identifier, populated only if work order is assigned
ACTION_TYPE NUMBER
Y Suggests the type of action for this work order
PROCESS_FLAG VARCHAR2 (1)
Flag to indicate if the work order will be processed
CREATED_BY NUMBER
Y Standard WHO Column
CREATION_DATE DATE
Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER
Y Standard WHO Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
CYCLE_ID NUMBER

This indicates the maintenance cycle under which the suggested work order is created
SEQ_ID NUMBER

This indicates the maintenance sequence of the suggested work order within a cycle
WO_STATUS NUMBER

System Work Order Status
PM_BASE_METER_READING NUMBER

Base meter reading at which PM engine has generated the work order
ORGANIZATION_ID NUMBER

The maintenance organization of the work oder

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

This table stores the criteria for forecasts and templates used in EAM maintenance budgeting and forecasting. Forecasts are created as a set of criteria used to extract historical work orders or predict future work orders that match that criteria.

Columns
Name Datatype Length Mandatory Comments
FORECAST_ID NUMBER
Y Unique identifier of the forecast
ORGANIZATION_ID NUMBER
Y Organization that created this forecast
TEMPLATE_FLAG VARCHAR2 (1)
Flag indicating a forecast template
REQUEST_ID NUMBER

The concurrent request id created when the forecast is generated
FORECAST_NAME VARCHAR2 (50) Y Forecast name
DESCRIPTION VARCHAR2 (240) Y Forecast description
PERIOD_FROM VARCHAR2 (15) Y The lower bound of the time frame, by accounting period, the forecast is applied to.
PERIOD_TO VARCHAR2 (15) Y The upper bound of the time frame, by accounting period, the forecast is applied to.
PERIOD_SET_NAME_FROM VARCHAR2 (15) Y Period set name for GL_PERIODS for "Period From"
FORECAST_TYPE NUMBER (1) Y Forecast type. 1 indicates historical planned work. 2 indicates historical non-planned work. 3 indicates all historical work. 4 indicates forecasted work.
ACCOUNT_FROM VARCHAR2 (50)
GL account to consider. Lower bound alphabetically.
ACCOUNT_TO VARCHAR2 (50)
GL account to consider. Upper bound alphabetically.
WIP_ACCT_CLASS_FROM VARCHAR2 (50)
WIP accounting class to consider. Lower bound alphabetically.
WIP_ACCT_CLASS_TO VARCHAR2 (50)
WIP accounting class to consider. Upper bound alphabetically.
ACTIVITY_FROM VARCHAR2 (50)
Activity to consider. Lower bound alphabetically
ACTIVITY_TO VARCHAR2 (50)
Activity to consider. Upper bound alphabetically
DEPARTMENT_FROM VARCHAR2 (50)
Owning department to consider. Lower bound alphabetically.
DEPARTMENT_TO VARCHAR2 (50)
Owning department to consider. Upper bound alphabetically
PROJECT_FROM VARCHAR2 (50)
Project to consider. Lower bound alphabetically
PROJECT_TO VARCHAR2 (50)
Project to consider. Upper bound alphabetically
ASSET_NUM_FROM VARCHAR2 (50)
Asset number to consider. Lower bound alphabetically
ASSET_NUM_TO VARCHAR2 (50)
Asset number to consider. upper bound alphabetically
ASSET_SERIAL_NUM_FROM VARCHAR2 (50)
Asset serial number to consider. Lower bound alphabetically
ASSET_SERIAL_NUM_TO VARCHAR2 (50)
Asset serial number to consider. Upper bound alphabetically
ASSET_GROUP_FROM VARCHAR2 (50)
Asset group to consider. Lower bound alphabetically
ASSET_GROUP_TO VARCHAR2 (50)
Asset group to consider. Upper bound alphabetically
WORK_ORDER_FROM VARCHAR2 (50)
Work order to consider. Lower bound alphabetically
WORK_ORDER_TO VARCHAR2 (50)
Work order to consider. Upper bound alphabetically
WORK_ORDER_TYPE_FROM VARCHAR2 (50)
Work order type to consider. Lower bound alphabetically
WORK_ORDER_TYPE_TO VARCHAR2 (50)
Work order type to consider. Upper bound alphabetically
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
AREA_FROM VARCHAR2 (30)
Asset area
AREA_TO VARCHAR2 (30)
Asset area
SOURCE_TEMPLATE_ID NUMBER

Parent template if this forecast was generated from a template
PERIOD_SET_NAME_TO VARCHAR2 (15) Y Period set name for the "Period To"
INCLUDE_TRANSACTED VARCHAR2 (1) Y Flag indicating a forecast should include work orders from other orgs for which the current organization is now responsible.
COMPLETION_DATE DATE

Date forecast was last generated

[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.
Comments

This table stores all of the costs associated with a forecasted work order for eAM maintenance budgeting and forecasting. Costs are striped by work order, operation, account, and the period forwhich the cost was incurred. This mirrors the structure of cst_eam_balance_by_accounts.

Indexes
Index Type Tablespace Column
EAM_FORECAST_CEBBA_N1 NONUNIQUE APPS_TS_TX_IDX FORECAST_ID
WIP_ENTITY_ID
PERIOD_NAME
CCID
EAM_FORECAST_CEBBA_N2 NONUNIQUE APPS_TS_TX_IDX FORECAST_ID
CCID
Columns
Name Datatype Length Mandatory Comments
PERIOD_SET_NAME VARCHAR2 (15) Y Period Set Name
PERIOD_NAME VARCHAR2 (15) Y Period Name
ACCT_PERIOD_ID NUMBER

Account Period Id
WIP_ENTITY_ID NUMBER
Y Wip Entity Id
ORGANIZATION_ID NUMBER
Y Organization id
OPERATIONS_DEPT_ID NUMBER

Operations Department Id
OPERATION_SEQ_NUM NUMBER

Operations Department Id
MAINT_COST_CATEGORY NUMBER

Maintenance cost category
OWNING_DEPT_ID NUMBER
Y Owning department id
ACCT_VALUE NUMBER

Amount charged to the account
PERIOD_START_DATE DATE
Y Period start date
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
FORECAST_ID NUMBER
Y Forecast Id
CCID NUMBER
Y WAC acct id
MFG_COST_ELEMENT_ID NUMBER

Mfg Cost Element Id
PERIOD_YEAR NUMBER (15) Y Year of the Period Costed
PERIOD_NUM NUMBER (15) Y Period Index of the Forecast
TXN_TYPE NUMBER

Material, Labor or Equipment

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

This table stores all of the work order information for a forecasted work order for eAM maintenance budgeting and forecasting. Work orders are extracted according to the criteria of a budget forecast, which is stored in EAM_FORECASTS. This table mirrors the structure of wip_discrete_jobs.
WIP_DISCRETE_JOBS stores discrete job information. Each row
represents a discrete job, and contains information about the assembly
being built, the revision of the assembly, the job quantity, the
status of the job, the material control method, accounting
information, and job schedule dates. Oracle Work in Process uses this
information to control discrete production.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y WIP Job Identifier
ORGANIZATION_ID NUMBER
Y Organization Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
SOURCE_LINE_ID NUMBER

Identifier of the source system that generated the job record
SOURCE_CODE VARCHAR2 (30)
Code of the process that generated the job record(null if created by Oracle Work In Process)
DESCRIPTION VARCHAR2 (240)
Descriptive text
STATUS_TYPE NUMBER
Y Status of job
PRIMARY_ITEM_ID NUMBER

nventory item Identifier for the assembly the job creates
FIRM_PLANNED_FLAG NUMBER
Y Control for MRP rescheduling
JOB_TYPE NUMBER
Y Type of discrete job
WIP_SUPPLY_TYPE NUMBER
Y Method of material consumption within WIP
CLASS_CODE VARCHAR2 (10) Y Accounting class associated with job
MATERIAL_ACCOUNT NUMBER

General Ledger account to accumulate material charges for a job
MATERIAL_OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate material overhead charges for a job
RESOURCE_ACCOUNT NUMBER

General Ledger account to accumulate resource charges for a job
OUTSIDE_PROCESSING_ACCOUNT NUMBER

General Ledger account to accumulate outside processing charges for a job
MATERIAL_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate material variances for a job
RESOURCE_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate resource variances for a job
OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate resource variances for a job
STD_COST_ADJUSTMENT_ACCOUNT NUMBER

General Ledger account to accumulate standard cost variances for a job
OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate overhead charges for a job
OVERHEAD_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate overhead variances for a job
SCHEDULED_START_DATE DATE
Y Date on which job is scheduled to start
DATE_RELEASED DATE

Date on which job is released
SCHEDULED_COMPLETION_DATE DATE
Y Last unit scheduled completion date
DATE_COMPLETED DATE

Last unit actual completion date
DATE_CLOSED DATE

Date on which job was closed
START_QUANTITY NUMBER
Y Job start quantity
QUANTITY_COMPLETED NUMBER
Y Current job quantity completed
QUANTITY_SCRAPPED NUMBER
Y Number of units scrapped on the current job
NET_QUANTITY NUMBER
Y Number of assemblies netted to supply by MRP
BOM_REFERENCE_ID NUMBER

Assembly identifier used as bill of material reference for explosions of nonstandard job
ROUTING_REFERENCE_ID NUMBER

Assembly identifier used as routing reference for explosions of nonstandard job
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
LOT_NUMBER VARCHAR2 (80)
Default lot number to assign to assemblies completed from the job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a job
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Default completion subinventory for assemblies completed by the job
COMPLETION_LOCATOR_ID NUMBER

Default completion locator identifier for assemblies completed by the job
MPS_SCHEDULED_COMPLETION_DATE DATE

Date used by MRP to relieve the MPS for the job (used by MRP only)
MPS_NET_QUANTITY NUMBER

Quantity used by MRP to relieve MPS for the job (used by MRP only)
DEMAND_CLASS VARCHAR2 (30)
Type of demand the job satisfies
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SCHEDULE_GROUP_ID NUMBER

Identifier for the job schedule group
BUILD_SEQUENCE NUMBER

Build sequence
LINE_ID NUMBER

Production line Identifier
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Project task Identifier
KANBAN_CARD_ID NUMBER

Identifier for production kanban replentished by the job
OVERCOMPLETION_TOLERANCE_TYPE NUMBER

Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount)
OVERCOMPLETION_TOLERANCE_VALUE NUMBER

Percent or amount above start quantity that this job is allowed to complete
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
PO_CREATION_TIME NUMBER

PO Creation Time for Outside Processing
PRIORITY NUMBER

Priority of this job
DUE_DATE DATE

Due date of this job
EST_SCRAP_ACCOUNT NUMBER

Estimated Scrap account
EST_SCRAP_VAR_ACCOUNT NUMBER

Estimated Scrap variance account
EST_SCRAP_PRIOR_QTY NUMBER

Estimated quantity completed for calculation of operation yield
DUE_DATE_PENALTY NUMBER

Penalty incurred if job is late (in days)
DUE_DATE_TOLERANCE NUMBER

Number of days a job can be late
COPRODUCTS_SUPPLY NUMBER

Flag indicating if this job forms supply for co-products also
PARENT_WIP_ENTITY_ID NUMBER

Parent Job Identifier
ASSET_NUMBER VARCHAR2 (30)
Asset Number
ASSET_GROUP_ID NUMBER

Asset Group Identifer
REBUILD_ITEM_ID NUMBER

Rebuild Item Identifier
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Serial Number
MANUAL_REBUILD_FLAG VARCHAR2 (1)
The flag indicating whether this rebuild work order is created manually.
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
ESTIMATION_STATUS NUMBER

Costing Estimation Status
REQUESTED_START_DATE DATE

Requested Start Date
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Requried Flag
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
OWNING_DEPARTMENT NUMBER

Work order owning department
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Planned Maintenance Flag
PM_SCHEDULE_ID NUMBER

The preventive maintenance schedule that generates this work order.
LAST_ESTIMATION_DATE DATE

last estimation date
LAST_ESTIMATION_REQ_ID NUMBER

last estimation ID
ACTIVITY_SOURCE VARCHAR2 (30)
Activity source
SERIALIZATION_START_OP NUMBER

first operation under serialized control
MAINTENANCE_OBJECT_ID NUMBER

maintenance object id
MAINTENANCE_OBJECT_TYPE NUMBER

maintenance object type
MAINTENANCE_OBJECT_SOURCE NUMBER

maintenance object source
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Enable Material Issue Requests
SCHEDULING_REQUEST_ID NUMBER

Constraint Based Scheduling Request Identifier
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
Issue asset items from Expense subinventory at Zero cost
EAM_LINEAR_LOCATION_ID NUMBER

Linear Asset Location Identifier
WSM_CURRENT_RTG_OP_SEQ_NUM NUMBER

Not Used
ACTUAL_START_DATE DATE

An actual job start time calculated based on info collected.
ACTUAL_COMPLETION_DATE DATE

Not Used
FORECAST_ID NUMBER
Y Forecast Id
EXPEDITED VARCHAR2 (1)
Expedited flag
EXPECTED_HOLD_RELEASE_DATE DATE

An expected time to release job from on hold.

[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.
Comments

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.
This table stores the description based direct items associated with an EAM work order.

Columns
Name Datatype Length Mandatory Comments
DESCRIPTION VARCHAR2 (240) Y The description for the direct item.
PURCHASING_CATEGORY_ID NUMBER
Y The purchasing category ID associated with the direct item.
DIRECT_ITEM_SEQUENCE_ID NUMBER
Y The primary key of the WIP_EAM_DIRECT_ITEMS table.
OPERATION_SEQ_NUM NUMBER
Y The operation sequence number to which the direct item is associated with.
DEPARTMENT_ID NUMBER

The department ID of the operation.
WIP_ENTITY_ID NUMBER
Y WIPEntity ID for the work order.
ORGANIZATION_ID NUMBER
Y Organization ID for the work order.
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested vendor name for the direct item.
SUGGESTED_VENDOR_ID NUMBER

Suggested vendor ID for the direct item.
SUGGESTED_VENDOR_SITE VARCHAR2 (15)
Suggested vendor site name for the direct item.
SUGGESTED_VENDOR_SITE_ID NUMBER

Suggested vendor site ID for the direct item.
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested vendor contact for the direct item.
SUGGESTED_VENDOR_CONTACT_ID NUMBER

Suggested vendor contact ID for the direct item.
SUGGESTED_VENDOR_PHONE VARCHAR2 (20)
Suggested vendor phone number for the direct item.
SUGGESTED_VENDOR_ITEM_NUM VARCHAR2 (25)
Suggested vendor item number for the direct item.
UNIT_PRICE NUMBER

Unit price for the direct item.
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
The auto request material flag for the direct item.
REQUIRED_QUANTITY NUMBER
Y Required quantity for the direct item.
UOM VARCHAR2 (3) Y Unit of measure.
NEED_BY_DATE DATE

The date by which the item is expected to be delivered.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard flexfield column.
ATTRIBUTE1 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Standard flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Standard flexfield column.
CREATED_BY NUMBER

Standard column.
CREATION_DATE DATE

Standard column.
LAST_UPDATE_DATE DATE

Standard column.
LAST_UPDATE_LOGIN NUMBER

Standard column.
LAST_UPDATED_BY NUMBER

Standard column.
PROGRAM_APPLICATION_ID NUMBER

Standard column.
PROGRAM_ID NUMBER

Standard column.
PROGRAM_UPDATE_DATE DATE

Standard column.
REQUEST_ID NUMBER

Standard column.
FORECAST_ID NUMBER
Y Forecast Id

[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.
Comments

This table stores the operation level information for forecasted work orders for eAM maintenance budgeting and forecasting. It mirrors the structure of wip_operations.
WIP_OPERATIONS stores information about job and repetitive schedule
operations. Each row represents a specific operation and includes
an operation sequence number, which orders the operations for the job or
repetitive schedule. Each row also includes the assembly quantity
completed at an operation, the quantity at each intraoperation step,
the department associated with an operation, the scheduled start and
completion dates for an operation, the operation's countpoint and
backflush types and other operation attributes. In general, Oracle
Work in Process uses this information to control and monitor assembly
production on the shop floor.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y WIP job or schedule Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number within a routing
ORGANIZATION_ID NUMBER
Y Organization Identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
OPERATION_SEQUENCE_ID NUMBER

Operation sequence Identifier
STANDARD_OPERATION_ID NUMBER

Standard operation Identifier
DEPARTMENT_ID NUMBER
Y Department Identifier
DESCRIPTION VARCHAR2 (240)
Descriptive text
SCHEDULED_QUANTITY NUMBER
Y Number of units scheduled for the operation
QUANTITY_IN_QUEUE NUMBER
Y Number of units in Queue of the operation
QUANTITY_RUNNING NUMBER
Y Number of units in To Run of the operation
QUANTITY_WAITING_TO_MOVE NUMBER
Y Number of units waiting To Move in the operation
QUANTITY_REJECTED NUMBER
Y Number of units rejected from the operation
QUANTITY_SCRAPPED NUMBER
Y Number of units scrapped from the operation
QUANTITY_COMPLETED NUMBER
Y Number of units completed by the operation
FIRST_UNIT_START_DATE DATE
Y First unit scheduled receipt date
FIRST_UNIT_COMPLETION_DATE DATE
Y First unit scheduled completion date
LAST_UNIT_START_DATE DATE
Y Last unit scheduled receipt date
LAST_UNIT_COMPLETION_DATE DATE
Y Last unit scheduled completion date
PREVIOUS_OPERATION_SEQ_NUM NUMBER

Previous operation sequence number
NEXT_OPERATION_SEQ_NUM NUMBER

Next operation sequence number
COUNT_POINT_TYPE NUMBER
Y Operation move type
BACKFLUSH_FLAG NUMBER
Y Backflush control code
MINIMUM_TRANSFER_QUANTITY NUMBER
Y Minimum operation transfer quantity
DATE_LAST_MOVED DATE

Operation last move date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
WF_ITEMTYPE VARCHAR2 (8)
Workflow Item Type
WF_ITEMKEY VARCHAR2 (240)
Workflow Item Key
OPERATION_YIELD NUMBER

Operation yield for an operation
OPERATION_YIELD_ENABLED NUMBER

Indicates whether operation yield is to be considered by the cost processor
PRE_SPLIT_QUANTITY NUMBER

Start Quantity of Parent job in case of split transaction
OPERATION_COMPLETED VARCHAR2 (1)
To indicated if the operation has been completed
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
X_POS NUMBER

X Coordinate position for the operation.
Y_POS NUMBER

Y Coordinate position for the operation.
PREVIOUS_OPERATION_SEQ_ID NUMBER

Previous operation sequence identification
SKIP_FLAG NUMBER

This flag used to determine whether material and resource should be charged or not
LONG_DESCRIPTION VARCHAR2 (4000)
long description
DISABLE_DATE DATE

Disable date
CUMULATIVE_SCRAP_QUANTITY NUMBER

Total number of assemblies scrapped in previous operations
RECOMMENDED VARCHAR2 (1)
This column determine whether this operation is on recommended path or not
PROGRESS_PERCENTAGE NUMBER

This column stores the progress percentage for the current operation
WSM_OP_SEQ_NUM NUMBER

This column stores operation sequence number used by OSFM team only.
ACTUAL_START_DATE DATE

An actual operation start date.
ACTUAL_COMPLETION_DATE DATE

An actual operation completion date.
FORECAST_ID NUMBER
Y Forecast Id
WSM_BONUS_QUANTITY NUMBER

Bonus quantity
EMPLOYEE_ID NUMBER

Employee ID.
PROJECT_COMPLETION_DATE DATE

Projected completion date.
WSM_UPDATE_QUANTITY_TXN_ID NUMBER

An ID of WSM update quantity transaction.
WSM_UPDATE_QUANTITY_COMPLETED NUMBER

A quantity that has been costed.
LOWEST_ACCEPTABLE_YIELD NUMBER

A lowest acceptable yield.
LOW_YIELD_TRIGGER_LIMIT NUMBER

Not Used

[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.
Comments

This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting. This mirrors the structure of wip_operation_resources.
WIP_OPERATION_RESOURCES stores information about the resource requirements associated with job and repetitive schedule operations. Each
row represents a resource requirement and contains a sequence number,
the resource's unit of measure, its usage rate or amount, and several
other attributes that control how it is scheduled and costed.
Oracle Work in Process uses this information to schedule jobs and
repetitive schedules and to charge resources to jobs and schedules.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER
Y Resource sequence number
ORGANIZATION_ID NUMBER
Y Organization Identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
RESOURCE_ID NUMBER
Y Resource Identifier
UOM_CODE VARCHAR2 (3)
Unit of measure code
BASIS_TYPE NUMBER
Y Basis for scheduling and charging resource
USAGE_RATE_OR_AMOUNT NUMBER
Y Rate per assembly or amount per job/schedule
ACTIVITY_ID NUMBER

Activity Identifier
SCHEDULED_FLAG NUMBER
Y Method of scheduling the resource
ASSIGNED_UNITS NUMBER

Number of resources assigned to do work
AUTOCHARGE_TYPE NUMBER
Y Method of charging the resource
STANDARD_RATE_FLAG NUMBER
Y Indicates whether the resource is charged at the standard rate
APPLIED_RESOURCE_UNITS NUMBER
Y Amount of resource units charged
APPLIED_RESOURCE_VALUE NUMBER
Y Value of resource units charged
START_DATE DATE
Y Scheduled start date of the resource
COMPLETION_DATE DATE
Y Scheduled completion date of the resource
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RELIEVED_RES_COMPLETION_UNITS NUMBER

Units of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_UNITS NUMBER

Units of resource relieved due to WIP scrap
RELIEVED_RES_COMPLETION_VALUE NUMBER

Value of resource relieved due to WIP completion
RELIEVED_RES_SCRAP_VALUE NUMBER

Value of resource relieved due to WIP scrap
RELIEVED_VARIANCE_VALUE NUMBER

Value of variance relieved
TEMP_RELIEVED_VALUE NUMBER

Temporary column used in completion cost implementation
RELIEVED_RES_FINAL_COMP_UNITS NUMBER

Units of resource relieved due to negative final completion
DEPARTMENT_ID NUMBER

Department of this resource, if different from that of parent operation
PHANTOM_FLAG NUMBER

Indicates whether or not this is a phantom routing resource (1 for yes, 2 for no)
PHANTOM_OP_SEQ_NUM NUMBER

Operation sequence number, if part of a phantom routing
PHANTOM_ITEM_ID NUMBER

Item, if part of a phantom routing
SCHEDULE_SEQ_NUM NUMBER

schedule sequence number
SUBSTITUTE_GROUP_NUM NUMBER

substitution group number
REPLACEMENT_GROUP_NUM NUMBER

replacement group number
PRINCIPLE_FLAG NUMBER

principle flag, for aps
SETUP_ID NUMBER

Setup Identifier
PARENT_RESOURCE_SEQ NUMBER

Parent Resource Sequence
BATCH_ID NUMBER

Batch Id used in grouping operation resources across jobs
RELIEVED_RES_UNITS NUMBER

Relieved Resource Units
RELIEVED_RES_VALUE NUMBER

Relieved Resource Value
MAXIMUM_ASSIGNED_UNITS NUMBER

maximum allowed assigned_units, inserted during job creation
FIRM_FLAG NUMBER

NOT FIRM - 0, FIRM_START - 1,FIRM_END - 2, FIRM_RESOURCE -3 ,FIRM_START_END- 4, FIRM_START_RESOURCE - 5, FIRM_END_RESOURCE - 6, FIRM_ALL 7
GROUP_SEQUENCE_ID NUMBER

Identifies the firmed fixed sequence for resource req
GROUP_SEQUENCE_NUMBER NUMBER

Sequence in firmed sequence for resource requirement
ACTUAL_START_DATE DATE

An actual resource start date.
ACTUAL_COMPLETION_DATE DATE

An actual resource completion date.
PROJECTED_COMPLETION_DATE DATE

Projected Completion Date
FORECAST_ID NUMBER
Y Forecast Identifier

[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.
Comments

This table stores the material requirements of forecasted work orders for eaM maintenance budgeting and forecasting. This mirrors the structure of wip_requirement_operations.
WIP_REQUIREMENT_OPERATIONS stores information about the material
requirements of jobs and schedules. Each row represents a
material requirement and contains information about the component
item, its usage quantities, the using department, requirement date,
and the material control method. Oracle Work in Process uses this
information to track the material usage of jobs and schedules.

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Y Item Identifier
ORGANIZATION_ID NUMBER
Y Organization Identifier
WIP_ENTITY_ID NUMBER
Y WIP job or repetitive assembly Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation sequence number within a routing
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
COMPONENT_SEQUENCE_ID NUMBER

Bill of materials component sequence Identifier
DEPARTMENT_ID NUMBER

Department Identifier
WIP_SUPPLY_TYPE NUMBER
Y Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER
Y Part quantity required
QUANTITY_ISSUED NUMBER
Y Part quantity issued
QUANTITY_PER_ASSEMBLY NUMBER
Y Part usage quantity
COMMENTS VARCHAR2 (240)
Component comment descriptive text
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Subinventory used to supply component to WIP
SUPPLY_LOCATOR_ID NUMBER

Locator used to supply component to WIP
MRP_NET_FLAG NUMBER
Y Determines whether or not MRP should consider the component requirement in its netting process
MPS_REQUIRED_QUANTITY NUMBER

Quantity used by MPS relief process
MPS_DATE_REQUIRED DATE

Date used by MPS relief process
SEGMENT1 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT2 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT3 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT4 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT5 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT6 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT7 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT8 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT9 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT10 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT11 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT12 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT13 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT14 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT15 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT16 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT17 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT18 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT19 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
SEGMENT20 VARCHAR2 (40)
Item flexfield segment, copied from Inventory
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
RELIEVED_MATL_COMPLETION_QTY NUMBER

Material quantity relieved due to WIP completion
RELIEVED_MATL_SCRAP_QUANTITY NUMBER

Material quantity relieved due to WIP scrap
RELIEVED_MATL_FINAL_COMP_QTY NUMBER

Material quantity relieved due to negative final completion
QUANTITY_ALLOCATED NUMBER

Quantity allocated
QUANTITY_BACKORDERED NUMBER

Quantity backordered
QUANTITY_RELIEVED NUMBER

Quantity Relieved
COSTED_QUANTITY_ISSUED NUMBER

Costed Quantity Issued
COSTED_QUANTITY_RELIEVED NUMBER

Costed Quantity Relieved
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
auto request material, used by EAM
RELEASED_QUANTITY NUMBER

This column stores material requirement at released time.
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested Vendor Name
VENDOR_ID NUMBER

Vendor identifier
UNIT_PRICE NUMBER

Unit price
BASIS_TYPE NUMBER

material basis type (either lot or item)
FORECAST_ID NUMBER
Y Forecast Identifier
COMPONENT_YIELD_FACTOR NUMBER

component yield factor
PRIMARY_COMPONENT_ID NUMBER

An ID of original component.

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

This is a history table that keeps a record of details of all maintenance work orders completed or uncompleted.

Indexes
Index Type Tablespace Column
EAM_JOB_COMPLETION_TXNS_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
EAM_JOB_COMPLETION_TXNS_N1 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
ORGANIZATION_ID
EAM_JOB_COMPLETION_TXNS_N2 NONUNIQUE APPS_TS_TX_IDX ASSET_ACTIVITY_ID
ASSET_NUMBER
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Transaction identifier for the complete/uncomplete transaction
TRANSACTION_DATE DATE
Y Date of the complete or uncomplete transaction
TRANSACTION_TYPE NUMBER
Y Type of transaction (complete or uncomplete)
WIP_ENTITY_ID NUMBER
Y Work order identifier
ORGANIZATION_ID NUMBER
Y Organization identifier
PARENT_WIP_ENTITY_ID NUMBER

Parent work order identifier
REFERENCE VARCHAR2 (240)
Reference
RECONCILIATION_CODE VARCHAR2 (30)
Reconciliation code used to store the result of a performed maintenance task
ACCT_PERIOD_ID NUMBER

Accounting Period Identifier
QA_COLLECTION_ID NUMBER

Quality Collection Plan Identifier
ASSET_GROUP_ID NUMBER

Obsolete
ASSET_NUMBER VARCHAR2 (30)
Obsolete
ASSET_ACTIVITY_ID NUMBER

Obsolete
ACTUAL_START_DATE DATE

Actual Start Date of the work order
ACTUAL_END_DATE DATE

Actual End Date of the work order
ACTUAL_DURATION NUMBER

Actual duration of the work order
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Subinventory Code
COMPLETION_LOCATOR_ID NUMBER

Completion Locator identifier
LOT_NUMBER VARCHAR2 (80)
Lot Number

[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.
Comments

This table stores linear location ids pushed into EAM from external sources. An internal EAM id is generated for an external linear id and that id will be used across EAM codes.
This table stores the association between the external linear location id and the internal EAM masking id generated.

Columns
Name Datatype Length Mandatory Comments
EXTERNAL_LINEAR_ID NUMBER
Y External linear location id
EXTERNAL_LINEAR_NAME VARCHAR2 (240)
External linear location name
EAM_LINEAR_ID NUMBER
Y EAM internal masking id
EXTERNAL_SOURCE_NAME VARCHAR2 (240)
External source name
EXTERNAL_LINEAR_TYPE VARCHAR2 (240)
External Linear Type

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_MATERIAL_IMPORT_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
INVENTORY_ITEM_ID NUMBER

Item Identifier
QUANTITY_PER_ASSEMBLY NUMBER

Part usage quantity
DEPARTMENT_ID NUMBER

Department Identifier
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
DATE_REQUIRED DATE

Operation requirement start date
REQUIRED_QUANTITY NUMBER

Part quantity required
REQUESTED_QUANTITY NUMBER

Part quantity requested
RELEASED_QUANTITY NUMBER

This column stores material requirement at released time
QUANTITY_ISSUED NUMBER

Part quantity issued
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Subinventory used to supply component to WIP
SUPPLY_LOCATOR_ID NUMBER

Locator used to supply component to WIP
MRP_NET_FLAG NUMBER

Determines whether or not MRP should consider the component requirement in its netting process
MPS_REQUIRED_QUANTITY NUMBER

Quantity used by MPS relief process
MPS_DATE_REQUIRED DATE

Date used by MPS relief process
COMPONENT_SEQUENCE_ID NUMBER

Bill of materials component sequence Identifier
COMMENTS VARCHAR2 (240)
Component comment descriptive text
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
auto request material, used by EAM
SUGGESTED_VENDOR_NAME VARCHAR2 (240)
Suggested Vendor Name
VENDOR_ID NUMBER

Vendor identifier
UNIT_PRICE NUMBER

Unit price
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This table stores meter templates and meter definitions used in EAM preventive maintenance. When tmpl_flag='Y', the row is a meter template. When tmpl_flag='N' or is null, the row is a meter definition.

Indexes
Index Type Tablespace Column
EAM_METERS_U1 UNIQUE APPS_TS_TX_IDX METER_ID
EAM_METERS_U2 UNIQUE APPS_TS_TX_IDX METER_NAME
Columns
Name Datatype Length Mandatory Comments
METER_ID NUMBER
Y Meter identifier
METER_NAME VARCHAR2 (50) Y Meter Name
METER_UOM VARCHAR2 (3) Y Meter's Unit of measure
VALUE_CHANGE_DIR NUMBER

Value Change Direction
USED_IN_SCHEDULING VARCHAR2 (1)
Used in Scheduling Flag
USER_DEFINED_RATE NUMBER

Usage Rate
USE_PAST_READING NUMBER

Indicator of how many past reading should be used to compute rate
DESCRIPTION VARCHAR2 (240)
Meter description
FROM_EFFECTIVE_DATE DATE

Effective start date
TO_EFFECTIVE_DATE DATE

Effective end date
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
TMPL_FLAG VARCHAR2 (1)
Flag indicating a meter template
SOURCE_TMPL_ID NUMBER

The meter template that the meter is created from
INITIAL_READING NUMBER

The first meter reading upon meter creation
METER_TYPE NUMBER (1)
Meter type. 1 indicates absolute meter, 2 indicates change meter
MIGRATED_FLAG VARCHAR2 (1)
Flag indicating whether the record has been migrated
REQUIRED_FLAG VARCHAR2 (1)
Flag indicating whether the meter reading entry is required during work order completion

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

This table stores actual meter reading values for asset meters. Each row in the table stores the meter id, reading date, the reading value, and the life to date reading. For absolute meters, the reading value is the absolute reading value; for change meters, the reading value indicates the change in reading from the previous reading. If the meter reading is disabled, disabled_flag is set to 'Y'.

Indexes
Index Type Tablespace Column
EAM_METER_READINGS_U1 UNIQUE APPS_TS_TX_IDX METER_READING_ID
EAM_METER_READINGS_N1 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
EAM_METER_READINGS_N2 NONUNIQUE APPS_TS_TX_IDX METER_ID
CURRENT_READING_DATE
Columns
Name Datatype Length Mandatory Comments
METER_READING_ID NUMBER
Y Meter Reading Identifier
METER_ID NUMBER
Y Meter Identifier
CURRENT_READING NUMBER
Y Current Reading
CURRENT_READING_DATE DATE
Y Current Reading Date
RESET_FLAG VARCHAR2 (1)
Reset Flag
LIFE_TO_DATE_READING NUMBER
Y Life to Date Reading
WIP_ENTITY_ID NUMBER

Work Order Identifier
DESCRIPTION VARCHAR2 (240)
Reading Description
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
SOURCE_LINE_ID NUMBER

Not used
SOURCE_CODE VARCHAR2 (30)
Not used
WO_ENTRY_FAKE_FLAG VARCHAR2 (1)
Not used
DISABLE_FLAG VARCHAR2 (1)
Flag indicating if it is a disabled meter reading
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag

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

This table stores records that are to be imported as meter readings into Oracle Applications.
Users enter data into the table from their legacy system. When the Asset Meter Import concurrent program runs, it processes the table, validates the data, and imports those data into eam_meter_readings table in the EAM system.
This table is used to populate data before executing EAM_MET_RD_INTERFACE concurrent program.
Scope: public
Product: EAM
Lifecycle: active
Display Name: EAM_METER_READINGS_INTERFACE
Category: OPEN_INTERFACE EAM_MET_RD_INTERFACE 1
Category: BUSINESS_ENTITY EAM_METER_READING

Indexes
Index Type Tablespace Column
EAM_MRS_INTERFACE_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Y Interface Process Group Identifier
PROCESS_STATUS NUMBER
Y Process Status
PROCESS_PHASE NUMBER
Y Process Phase
METER_ID NUMBER

Meter Identifier
METER_NAME VARCHAR2 (30)
Meter Name
READING_VALUE NUMBER

Reading Value
READING_DATE DATE
Y Date when the reading was taken
RESET_FLAG VARCHAR2 (1)
Reset Flag
LIFE_TO_DATE_READING NUMBER

Life to Date Reading
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
WIP_ENTITY_ID NUMBER

Work Order Identifier
WORK_ORDER_NAME VARCHAR2 (240)
Work Order Name
DESCRIPTION VARCHAR2 (240)
Description for reading value
SOURCE_CODE VARCHAR2 (30)
Source Code
SOURCE_LINE_ID NUMBER

Source Line ID
INTERFACE_ID NUMBER

Interface identifier
CREATED_BY NUMBER

Standard Who Column
CREATED_BY_NAME VARCHAR2 (100)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
READING_CHANGE NUMBER

Reading Change
DISABLE_FLAG VARCHAR2 (1)
Flag to disable meter reading value

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_OPERATION_IMPORT_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
STANDARD_OPERATION_ID NUMBER

Standard operation Identifier
DEPARTMENT_ID NUMBER

Department Identifier
OPERATION_SEQUENCE_ID NUMBER

Operation sequence Identifier
DESCRIPTION VARCHAR2 (240)
Descriptive text
MINIMUM_TRANSFER_QUANTITY NUMBER

Minimum operation transfer quantity
COUNT_POINT_TYPE NUMBER

Operation move type
BACKFLUSH_FLAG NUMBER

Backflush control code
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
START_DATE DATE

First unit scheduled start date
COMPLETION_DATE DATE

Last unit scheduled completion date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
LONG_DESCRIPTION VARCHAR2 (4000)
long description
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This is a history table that keeps a record of all work orders' operations complete and uncomplete events.

Indexes
Index Type Tablespace Column
EAM_OP_COMPLETION_TXNS_U1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
EAM_OP_COMPLETION_TXNS_N1 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
ACTUAL_END_DATE
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Transaction identifier of the complete or uncomplete transaction
TRANSACTION_DATE DATE
Y Transaction Date
TRANSACTION_TYPE NUMBER
Y Transaction Type
WIP_ENTITY_ID NUMBER
Y Work Order Identifier
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation Sequence Number
DEPARTMENT_ID NUMBER
Y Department Identifier
REFERENCE VARCHAR2 (240)
Reference
RECONCILIATION_CODE VARCHAR2 (30)
Reconciliate code used to store the results of the performed maintenance task
ACCT_PERIOD_ID NUMBER

accounting period identifier
QA_COLLECTION_ID NUMBER

Quality Collection Plan Identifier
ASSET_GROUP_ID NUMBER

Obsolete
ASSET_NUMBER VARCHAR2 (30)
Obsolete
ASSET_ACTIVITY_ID NUMBER

Obsolete
ACTUAL_START_DATE DATE

Actual Start Date of the Operation
ACTUAL_END_DATE DATE

Actual End Date of the Operation
ACTUAL_DURATION NUMBER

Actual duration of the operation
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
HANDOVER_OPERATION_SEQ_NUM NUMBER

Operation Sequence Number to which an operation is handed over to
REASON_ID NUMBER

Reason Id
VENDOR_CONTACT_ID NUMBER

Vendor Contact Id
VENDOR_ID NUMBER

Supplier Id
VENDOR_SITE_ID NUMBER

Vendor Site Id
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction Reference

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

This table is used to store organization specific maintenance attributes for several type of maintenance objects. These attributes are defaulted into a newly created Work Order for the object. The maintenance objects for which these attributes could be stored are Maintenance Organization, Asset Category, Asset Group, Asset Group Activity Association, Asset Number and Asset Number Activity Association.

Indexes
Index Type Tablespace Column
EAM_ORG_MAINT_DEFAULTS_U1 UNIQUE APPS_TS_SEED OBJECT_ID
OBJECT_TYPE
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE NUMBER
Y Object Type
OBJECT_ID NUMBER
Y Object Identifier
ORGANIZATION_ID NUMBER
Y Organization Identifier
OWNING_DEPARTMENT_ID NUMBER

Owning Department
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Maintenance Accounting Class Code
AREA_ID NUMBER

Area
ACTIVITY_CAUSE_CODE VARCHAR2 (30)
Activity Cause Code
ACTIVITY_TYPE_CODE VARCHAR2 (30)
Activity Type Code
ACTIVITY_SOURCE_CODE VARCHAR2 (30)
Activity Source Code
SHUTDOWN_TYPE_CODE VARCHAR2 (30)
Shutdown Type
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
TAGGING_REQUIRED_FLAG VARCHAR2 (1)
Tagging Required
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login

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

Since one PM Schedule can have multiple activities from R12,the activities for a PM Schdeule are stored in this table,This table stores the PM Schedule activities for a PM Schedule and their associated attributes like next service start date,next service end date.

Indexes
Index Type Tablespace Column
EAM_PM_ACTIVITIES_U1 NONUNIQUE APPS_TS_TX_IDX PM_SCHEDULE_ID
ACTIVITY_ASSOCIATION_ID
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ASSOCIATION_ID NUMBER
Y Primary Key, sequence
PM_SCHEDULE_ID NUMBER
Y Preventive Maintenance Schedule Identifier
INTERVAL_MULTIPLE NUMBER
Y This will indicate the interval multiple or occurrence of the maintenance activity in the cycle.
ALLOW_REPEAT_IN_CYCLE VARCHAR2 (1) Y This indicates whether the activity can be repeated in the cycle.
DAY_TOLERANCE NUMBER

How many days can the planned activity be delayed? This information is used in suppression
NEXT_SERVICE_START_DATE DATE

Next service start date of the activity predicted by PM
NEXT_SERVICE_END_DATE DATE

Next service end date of the activity predicted by PM
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This table stores the last service information for the combination of a meter and asset activity association. It stores the meter reading values during last service and the previous service, and the work order ID (wip_entity_id) of the services.

Indexes
Index Type Tablespace Column
EAM_PM_LAST_SERVICE_U1 UNIQUE APPS_TS_TX_IDX ACTIVITY_ASSOCIATION_ID
METER_ID
EAM_PM_LAST_SERVICE_N1 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
METER_ID NUMBER
Y Meter Identifier
ACTIVITY_ASSOCIATION_ID NUMBER
Y Asset Activitiy Association Identifier
LAST_SERVICE_READING NUMBER

Last service meter reading
PREV_SERVICE_READING NUMBER

Last service reading value is copied over here when a work order is completed
WIP_ENTITY_ID NUMBER

Work order identifier
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag

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

This tables stores the details of all user defined Preventive Maintenance schedules.

Indexes
Index Type Tablespace Column
EAM_PM_SCHEDULINGS_U1 UNIQUE APPS_TS_TX_IDX PM_SCHEDULE_ID
EAM_PM_SCHEDULINGS_U2 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
PM_SCHEDULE_ID NUMBER
Y Preventive Maintenance Schedule Identifier
ACTIVITY_ASSOCIATION_ID NUMBER

No longer used
NON_SCHEDULED_FLAG VARCHAR2 (1)
Run to Failure
FROM_EFFECTIVE_DATE DATE

Effective start date
TO_EFFECTIVE_DATE DATE

Effective end date
RESCHEDULING_POINT NUMBER
Y Rescheduling Point
LEAD_TIME NUMBER

Lead Time
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
NAME VARCHAR2 (50)
Name of a PM schedule
TMPL_FLAG VARCHAR2 (1)
Flag indicating a PM template or PM instance
SOURCE_TMPL_ID NUMBER

PM template that the PM instance is created from
AUTO_INSTANTIATION_FLAG VARCHAR2 (1)
Flag indicating whether a PM template will be automatically instantiated
SOURCE_CODE VARCHAR2 (30)
Application that the PM is created in
SOURCE_LINE VARCHAR2 (30)
Source that PM is created from.
NEXT_SERVICE_START_DATE DATE

Next service start date of the activity predicted by PM
NEXT_SERVICE_END_DATE DATE

Next service end date of the activity predicted by PM
SET_NAME_ID NUMBER

Set name identifier
TYPE_CODE NUMBER

PM types: 'Rule Based', 'List Dates'
SCHEDULING_METHOD_CODE NUMBER

Scheduling Method: 'Forward' or 'Backward'
WHICHEVER_FIRST VARCHAR2 (1)
Whichever first or later
INCLUDE_MANUAL VARCHAR2 (1)
Whether rescheduling manual work orders or not
DAY_TOLERANCE NUMBER

How many days can the planned activity be delayed? This information is used in suppression.
DEFAULT_IMPLEMENT VARCHAR2 (1)
Default PM
GENERATE_WO_STATUS NUMBER

Generate Work order status identifier which indicates in which status work order has to be created based on PM schedule.
INTERVAL_PER_CYCLE NUMBER

This will store the number in which the cycle will be divided
CURRENT_CYCLE NUMBER

This will store the Current Cycle based on which the PM Schedule will be defined
CURRENT_SEQ NUMBER

This will store the current sequence within a cycle and will be used for resequencing of work orders
CURRENT_WO_SEQ NUMBER

This will store the previous work order sequence.
BASE_DATE DATE

This will store the Base Date from which the PM engine has to generate the Work Orders.
BASE_READING NUMBER

This will store the Base Reading from which the PM engine has to generate the Work Orders.
EAM_LAST_CYCLIC_ACT NUMBER

This will store the last cyclical activity performed for that PM Schedule.
MAINTENANCE_OBJECT_ID NUMBER

Object Id
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
GENERATE_NEXT_WORK_ORDER VARCHAR2 (1)
Flag indicating next work order generation
LAST_REVIEWED_BY NUMBER

PM Last Reviewed By
LAST_REVIEWED_DATE DATE

PM Last Reviewed Date

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

This table stores the rules of each preventive maintenance schedule. The rules include day time rules (rule_type=1), run time rules (rule_type=2), and list date rules (rule_type=3). Based on these rules, the preventive maintenance engine forecasts work orders.

Indexes
Index Type Tablespace Column
EAM_PM_SCHEDULING_RULES_N1 NONUNIQUE APPS_TS_TX_IDX PM_SCHEDULE_ID
EAM_PM_SCHEDULING_RULES_N2 NONUNIQUE APPS_TS_TX_IDX RULE_ID
EAM_PM_SCHEDULING_RULES_N3 NONUNIQUE APPS_TS_TX_IDX METER_ID
RULE_TYPE
Columns
Name Datatype Length Mandatory Comments
PM_SCHEDULE_ID NUMBER
Y Preventive Maintenance Schedule Identifier
RULE_TYPE NUMBER
Y Rule Type
BASE_DATE DATE

Base Date(Obsolete in I). See mtl_eam_asset_activities.last_service_start, last_service_end_date.
DAY_INTERVAL NUMBER

Day Interval
METER_ID NUMBER

Meter Identifier
RUNTIME_INTERVAL NUMBER

Runtime Interval
LAST_SERVICE_READING NUMBER

Last Service Reading(Obsolete in I) . See eam_pm_last_service.last_service_reading
CREATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
PREVIOUS_BASE_DATE DATE

Previous Base Date(Obsolete in I)
PREVIOUS_SERVICE_READING NUMBER

Previous Service Reading(Obsolete in I)
RULE_ID NUMBER

PM scheduling rules identifier
EFFECTIVE_READING_FROM NUMBER

The effective meter reading of the runtime rule
EFFECTIVE_READING_TO NUMBER

The effective meter reading of the runtime rule
EFFECTIVE_DATE_FROM DATE

The effective start date of the datetime rule
EFFECTIVE_DATE_TO DATE

The effective end date of the datetime rule
LIST_DATE DATE

Dates of a list date type PM
LIST_DATE_DESC VARCHAR2 (50)
List date description
MIGRATED_FLAG VARCHAR2 (1)
Migrated Flag

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

This is the table that holds set name definitions for Preventive Maintenance Schedules. In the eam_pm_schedulings table, there can be only one Preventive Maintenance Schedule for a unique combination of asset activity association and set name.

Indexes
Index Type Tablespace Column
EAM_PM_SET_NAMES_U1 UNIQUE APPS_TS_TX_IDX SET_NAME_ID
Columns
Name Datatype Length Mandatory Comments
SET_NAME_ID NUMBER
Y Set name identifier
SET_NAME VARCHAR2 (80) Y Set name
DESCRIPTION VARCHAR2 (240)
Description of PM set
END_DATE DATE

Effective end date of the PM set
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
CREATED_BY NUMBER
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
OWNING_ORGANIZATION_ID NUMBER

The Organization which the PM Set currently belongs to
LOCAL_FLAG VARCHAR2 (1)
Flag indicating whether the PM SET is globally visible or only visible for the owning organization

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

This table stores resolution code definition. As the resolution of a failure is identified, Resolution code is typically the last and final code reported by the user for a failure. As an example for a printer jam failure, Resolution Code could be REPLACEBELT and it's description could be Replaced Printer Belt.

Indexes
Index Type Tablespace Column
EAM_RESOLUTION_CODES_U1 UNIQUE APPS_TS_TX_IDX RESOLUTION_CODE
Columns
Name Datatype Length Mandatory Comments
RESOLUTION_CODE VARCHAR2 (80) Y Unique identifier for resolution code
DESCRIPTION VARCHAR2 (2000)
Resolution code description
EFFECTIVE_END_DATE DATE

End date beyond which resolution code is inactive
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_RESOURCE_IMPORT_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
RESOURCE_ID NUMBER

Resource Identifier
UOM_CODE VARCHAR2 (3)
Unit of measure code
BASIS_TYPE NUMBER

Basis for scheduling and charging resource
USAGE_RATE_OR_AMOUNT NUMBER

Rate per assembly or amount per job/schedule
ACTIVITY_ID NUMBER

Activity Identifier
SCHEDULED_FLAG NUMBER

Method of scheduling the resource
ASSIGNED_UNITS NUMBER

Number of resources assigned to do work
AUTOCHARGE_TYPE NUMBER

Method of charging the resource
STANDARD_RATE_FLAG NUMBER

Indicates whether the resource is charged at the standard rate
APPLIED_RESOURCE_UNITS NUMBER

Amount of resource units charged
APPLIED_RESOURCE_VALUE NUMBER

Value of resource units charged
START_DATE DATE

Scheduled start date of the resource
COMPLETION_DATE DATE

Scheduled completion date of the resource
SCHEDULE_SEQ_NUM NUMBER

schedule sequence number
SUBSTITUTE_GROUP_NUM NUMBER

substitution group number
REPLACEMENT_GROUP_NUM NUMBER

replacement group number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
DEPARTMENT_ID NUMBER

Department of this resource, if different from that of parent operation
MAX_ASSIGNED_UNITS NUMBER

Maximum allowed assigned units, inserted during job creation
FIRM_FLAG NUMBER

NOT FIRM - 0, FIRM_START - 1,FIRM_END - 2, FIRM_RESOURCE -3 ,FIRM_START_END- 4, FIRM_START_RESOURCE - 5, FIRM_END_RESOURCE - 6, FIRM_ALL 7
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_RESOURCE_INSTANCE_IMPORT_N NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
INSTANCE_ID NUMBER

Instance Identifier
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
START_DATE DATE

Scheduled start date of the resource instance
COMPLETION_DATE DATE

Scheduled completion date of the resource instance
TOP_LEVEL_BATCH_ID NUMBER

Batch Id used in grouping operation resource instances across jobs
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_RESOURCE_USAGE_IMPORT_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
START_DATE DATE

Start time for this usage block
COMPLETION_DATE DATE

End time for this usage block
ASSIGNED_UNITS NUMBER

Capacity for this duration
INSTANCE_ID NUMBER

Instance identifier of the resource
SERIAL_NUMBER VARCHAR2 (30)
Serial number of the resource instance
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This table stores preventive maintenance suppression rules and suppression templates. The parent activity suppresses the child activity. When tmpl_flag='Y', the row is a suppression template, and the parent_association_id and child_association_id refer to activity association templates in the mtl_eam_asset_activities table. When tmpl_flag='N' or is null, the row is a suppression rule, and the parent_association_id and child_association_id refer to asset activity associations in the mtl_eam_asset_activities table.

Indexes
Index Type Tablespace Column
EAM_SUPPRESSION_RELATIONS_U1 UNIQUE APPS_TS_TX_IDX PARENT_ASSOCIATION_ID
CHILD_ASSOCIATION_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_ASSOCIATION_ID NUMBER
Y Parent Activity Association Identifier
CHILD_ASSOCIATION_ID NUMBER
Y Child Activity Association Identifier
DAY_TOLERANCE NUMBER

Day Tolerance
RUNTIME_TOLERANCE NUMBER

Runtime Tolerance
DESCRIPTION VARCHAR2 (240)
Description of suppression
CREATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
TMPL_FLAG VARCHAR2 (1)
Template Flag

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

This table stores the bills created for maintenance work orders. Bills may also be treated as reference invoices and actual invoices may be created through Accounts Receivables. The information in this bill is either populated to the AR interface tables or, for work orders related to contract projects, is transferred to Project Accounting as a manual event. Relevant information within this table includes the work order, customer, billed item, billing basis, billed amount and more.

Indexes
Index Type Tablespace Column
EAM_WORK_ORDER_BILLS_N1 NONUNIQUE APPS_TS_TX_IDX BILLED_INVENTORY_ITEM_ID
ORGANIZATION_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (38) Y Inventory Organization ID
CUSTOMER_ID NUMBER (38)
Customer ID
BILL_TO_ADDRESS_ID NUMBER (38)
Customer Billing Address ID
WIP_ENTITY_ID NUMBER (38) Y Work Order ID
OPERATION_SEQ_NUM NUMBER (38)
Operation Sequence Number within Work Order (for "Bill By Requirements" only)
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (38) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (38) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who Column
INVENTORY_ITEM_ID NUMBER (38)
Item ID of item desired to be billed. This field is null for Resource Items. If not null, this item may or may not be actually billable, if it is not, BILLED_INVENTORY_ITEM_ID is different from this field, else it is same.
RESOURCE_ID NUMBER (38)
Resource ID (Only if Billed Item is of type Labor)
BILLED_INVENTORY_ITEM_ID NUMBER (38) Y Item ID of item against which bill is actually cut. This item is always billable and is the one against which the invoice will be created.
BILLED_UOM_CODE VARCHAR2 (3)
Unit Of Measure Code for Billed Item
BILLED_QUANTITY NUMBER (38)
Quantity of Billed Item
BILLING_BASIS NUMBER (38)
Billing Basis: 1= Price List, 2= Cost Plus
PRICE_LIST_HEADER_ID NUMBER (38)
Header ID of Price List used (only if Billing Basis is 'Price List')
COST_TYPE_ID NUMBER (38)
ID of Cost Type for the billed item (only if Billing Basis is 'Cost Plus')
COST_OR_LISTPRICE NUMBER (38)
Unit Price for Billed Item
COSTPLUS_PERCENTAGE NUMBER (38)
Markup percentage (only if Billing Basis is 'Cost Plus')
BILLED_AMOUNT NUMBER

Billed Amount for this billed item (BILLED_QUANTITY * COST_OR_LISTPRICE)
INVOICE_TRX_NUMBER NUMBER (38)
Header Number for Reference Invoice related to this billed item
INVOICE_LINE_NUMBER NUMBER (38)
Line Number for Reference Invoice related to this billed item
CURRENCY_CODE VARCHAR2 (15)
Billed Currency Code
CONVERSION_RATE NUMBER (38)
Currency Conversion Rate
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currenct ConversionType Code
CONVERSION_RATE_DATE DATE

Date on which the Currency Conversion is done
PROJECT_ID NUMBER (38)
ID of Project to be billed to (for Work Orders related to Contract Projects)
TASK_ID NUMBER (38)
ID of Task to be billed to (for Work Orders related to Contract Projects)
WORK_REQUEST_ID NUMBER (38)
ID of Work Request associated with billed work order
PA_EVENT_ID NUMBER (38)
ID of Manual Project Accounting Event (for Work Orders related to Contract Projects)
BILLING_METHOD NUMBER

Billing Method: 1=Bill By Requirements, 2=Bill By Activity
OVERRIDE_BILL_AMOUNT VARCHAR2 (1)
Reserved for future use
DYNAMIC_BILLING_ACTIVITY VARCHAR2 (1)
Reserved for future use
MASS_ADDITION_ID NUMBER

Unique identifier to search the status of Cost Adjustment in Oracle Assets
CAPITALIZATION_DATE DATE

Date on which Capitalization was carried out. This column is just for information purpose to know when the capitalization was carried out. User wont be able fa_mass_additions based on this
COMMENTS VARCHAR2 (64)
This column will be used to store the indentifier that can be used to query the corresponding transactionin Oracle Assets.It will have the concatenated value Work Order:Organization:Dept:Work Order Description
FIXED_ASSET_NUMBER NUMBER

This can be used for querying the Oracle Assets for the posted transaction.
OFFSET_ACCOUNT_CCID VARCHAR2 (1000)
Used to post the Offset Account Id to fa_mass_additions table

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

This table stores the work order detail information specific for eAM

Indexes
Index Type Tablespace Column
EAM_WORK_ORDER_DETAILS_U1 UNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
ORGANIZATION_ID
EAM_WORK_ORDER_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y Work Order Identifier
ORGANIZATION_ID NUMBER
Y Organization Identifier
USER_DEFINED_STATUS_ID NUMBER

User defined work order status
PENDING_FLAG VARCHAR2 (1)
Pending Flag
MATERIAL_SHORTAGE_CHECK_DATE DATE

Material Shortage check date
MATERIAL_SHORTAGE_FLAG NUMBER

Material Shortage Flag
WORKFLOW_TYPE NUMBER

Workflow type
WARRANTY_CLAIM_STATUS NUMBER

Warrany Claim Status
CYCLE_ID NUMBER

Cycle Identifier
SEQ_ID NUMBER

Sequence Number
DS_SCHEDULED_FLAG VARCHAR2 (1)
Flag to indicate if work order is scheduled by detailed scheduling engine
ASSIGNMENT_COMPLETE VARCHAR2 (1)
Flag to indicate the assignment completion for work order
WARRANTY_ACTIVE NUMBER

Flag indicating whether warranty is active for the workorder or not
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
PM_SUGGESTED_START_DATE DATE

Original Scheduled Start date of work order
PM_SUGGESTED_END_DATE DATE

Original Scheduled end date of work order
PM_BASE_METER_READING NUMBER

Stores the PM Base Meter Reading based on which work order is generated
PM_BASE_METER NUMBER

Stores the PM Base Meter Id based on which work order is generated
FAILURE_CODE_REQUIRED VARCHAR2 (240)
Stores whether a failure informationis required on this work order
ESTIMATE_ID NUMBER

Estimate id reference If the work order was created from Construction Estimate

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
EAM_WORK_ORDER_IMPORT_N1 NONUNIQUE APPS_TS_INTERFACE GROUP_ID
WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Work Order Name
WIP_ENTITY_ID NUMBER

WIP Job Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
DESCRIPTION VARCHAR2 (240)
Descriptive text
ASSET_NUMBER VARCHAR2 (30)
Asset Number
ASSET_GROUP_ID NUMBER

Asset Group Identifer
REBUILD_ITEM_ID NUMBER

Rebuild Item Identifier
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Serial Number
MAINTENANCE_OBJECT_ID NUMBER

maintenance object id
MAINTENANCE_OBJECT_TYPE NUMBER

maintenance object type
MAINTENANCE_OBJECT_SOURCE NUMBER

maintenance object source
CLASS_CODE VARCHAR2 (10)
Accounting class associated with job
ASSET_ACTIVITY_ID NUMBER

Inventory item Identifier for the assembly the job creates
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause
ACTIVITY_SOURCE VARCHAR2 (30)
Activity source
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
STATUS_TYPE NUMBER

Status of job
JOB_QUANTITY NUMBER

Job Quantity
DATE_RELEASED DATE

Date on which job is released
OWNING_DEPARTMENT NUMBER

Work order owning department
PRIORITY NUMBER

Priority of this job
REQUESTED_START_DATE DATE

Requested Start Date
DUE_DATE DATE

Due date of this job
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
FIRM_PLANNED_FLAG NUMBER

Control for MRP rescheduling
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Requried Flag
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Planned Maintenance Flag
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Project task Identifier
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity.
SCHEDULE_GROUP_ID NUMBER

Identifier for the job schedule group
BOM_REVISION_DATE DATE

Date of assembly item revision used to explode the bills of material used in the job
ROUTING_REVISION_DATE DATE

Routing revision date
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing used in a job
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate bill of material used in a job
ROUTING_REVISION VARCHAR2 (3)
Short code that uniquely identifies the Routing revision
BOM_REVISION VARCHAR2 (3)
BOM revision for the primary assembly
PARENT_WIP_ENTITY_ID NUMBER

Parent Job Identifier
MANUAL_REBUILD_FLAG VARCHAR2 (1)
The flag indicating whether this rebuild work order is created manually
PM_SCHEDULE_ID NUMBER

The preventive maintenance schedule that generates this work order.
WIP_SUPPLY_TYPE NUMBER

Method of material consumption within WIP
MATERIAL_ACCOUNT NUMBER

General Ledger account to accumulate material charges for a job
MATERIAL_OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate material overhead charges for a job
RESOURCE_ACCOUNT NUMBER

General Ledger account to accumulate resource charges for a job
OUTSIDE_PROCESSING_ACCOUNT NUMBER

General Ledger account to accumulate outside processing charges for a job
MATERIAL_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate material variances for a job
RESOURCE_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate resource variances for a job
OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

General Ledger account to accumulate outside processing variances for a job
STD_COST_ADJUSTMENT_ACCOUNT NUMBER

General Ledger account to accumulate standard cost variances for a job
OVERHEAD_ACCOUNT NUMBER

General Ledger account to accumulate overhead charges for a job
OVERHEAD_VARIANCE_ACCOUNT NUMBER

General ledger account to accumulate overhead variances for a job
SCHEDULED_START_DATE DATE

Date on which job is scheduled to start
SCHEDULED_COMPLETION_DATE DATE

Last unit scheduled completion date
COMMON_BOM_SEQUENCE_ID NUMBER

Bill of material identifier when a common bill is used
COMMON_ROUTING_SEQUENCE_ID NUMBER

Routing identifier when a common routing is used
PO_CREATION_TIME NUMBER

PO Creation Time for Outside Processing
GEN_OBJECT_ID NUMBER

Genealogy object identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Enable Material Issue Requests
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
Issue asset items from Expense subinventory at Zero cost
USER_ID NUMBER

User Identifier
RESPONSIBILITY_ID NUMBER

Responsibility Identifier
REQUEST_ID NUMBER

Enhanced Who column
PROGRAM_ID NUMBER

Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who column
SOURCE_LINE_ID NUMBER

Identifier of the source system that generated the job record
SOURCE_CODE VARCHAR2 (30)
Code of the process that generated the job record(null if created by Oracle Work In Process)
PROCESS_STATUS NUMBER

Status of processing (1=Picked up by program, 2= locked and being processed, 3=Relationship error, 4=Errored)
TOP_WIP_ENTITY_ID NUMBER

Updated by program and used for rolling back updates for hierarchies with invalid structures
RETURN_STATUS VARCHAR2 (1)
Return Status
TRANSACTION_TYPE NUMBER

Type of transaction. 0 Sync/ 1 Create/ 2 Update/ 3 Delete
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Y Header Identifier
GROUP_ID NUMBER
Y Group Identifier to process a group of records together
ROW_ID NUMBER

Row Identifier
ERROR_MESSAGE VARCHAR2 (4000)
Error message indicating the error occured while importing the row
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This tables stores the history of Asset Route

Indexes
Index Type Tablespace Column
EAM_WORK_ORDER_ROUTE_N1 NONUNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ROUTE_ASSET_SEQ_ID NUMBER
Y Route Asset Sequence Identifier
WIP_ENTITY_ID NUMBER
Y Work Order Identifier
INSTANCE_ID NUMBER
Y Instance Id
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

This table stores Wip_Entity_Id of all EAM work orders. A text (intermedia) index will be created on the column 'TEXT' with the help of a concurrent program and the same is used in Work Order text search page

Indexes
Index Type Tablespace Column
EAM_WORK_ORDER_TEXT_U1 UNIQUE APPS_TS_TX_IDX WIP_ENTITY_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

The Organization of the work order
WIP_ENTITY_ID NUMBER

Work Order
TEXT VARCHAR2 (1)
Column on which Intermedia index will be based
CREATED_BY NUMBER

Standard Who Columns
CREATION_DATE DATE

Standard Who Columns
LAST_UPDATED_BY NUMBER

Standard Who Columns
LAST_UPDATE_DATE DATE

Standard Who Columns
LAST_UPDATE_LOGIN NUMBER

Standard Who Columns

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

EAM work order Relationships table is used for holding four types of relations in EAM. They are - Scheduling Child, Costing Child, End to Start Dependency, and Follow up work order.

Indexes
Index Type Tablespace Column
EAM_WO_RELATIONSHIPS_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_OBJECT_ID
PARENT_OBJECT_TYPE_ID
PARENT_RELATIONSHIP_TYPE
EAM_WO_RELATIONSHIPS_N2 NONUNIQUE APPS_TS_TX_IDX CHILD_OBJECT_ID
CHILD_OBJECT_TYPE_ID
PARENT_RELATIONSHIP_TYPE
EAM_WO_RELATIONSHIPS_N3 NONUNIQUE APPS_TS_TX_IDX TOP_LEVEL_OBJECT_ID
TOP_LEVEL_OBJECT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
WO_RELATIONSHIP_ID NUMBER
Y Work order relationship identifier key
PARENT_OBJECT_ID NUMBER
Y Object identifier of the parent in the relationship
PARENT_OBJECT_TYPE_ID NUMBER
Y Object type of the parent in the relationship
CHILD_OBJECT_ID NUMBER
Y Object identifier of the child in the relationship
CHILD_OBJECT_TYPE_ID NUMBER
Y Object type of the child in the relationship
PARENT_RELATIONSHIP_TYPE NUMBER
Y Type of relationship between the entities
RELATIONSHIP_STATUS NUMBER

Status of relationship between work orders
CREATED_BY NUMBER
Y Created By
CREATION_DATE DATE
Y Creation date
LAST_UPDATED_BY NUMBER
Y Last Updated By
LAST_UPDATE_DATE DATE
Y Last Update Date
TOP_LEVEL_OBJECT_ID NUMBER

Identifier of object at upper end of hierarchy
TOP_LEVEL_OBJECT_TYPE_ID NUMBER

Type identifier of object at upper end of hierarchy

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

This table stores the association between service requests and work order to which the service requests have been associated.
You can associate service request to a work order only if the organization has been set up to be service request enabled.
WO_SERVICE_ENTITY_ASSOC_ID field defines the association between a work order and a service request.

Indexes
Index Type Tablespace Column
EAM_WO_SERVICE_ASSOCIATION_N1 NONUNIQUE APPS_TS_TX_IDX SERVICE_REQUEST_ID
WIP_ENTITY_ID
MAINTENANCE_ORGANIZATION_ID
EAM_WO_SERVICE_ASSOCIATION_N2 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
WO_SERVICE_ENTITY_ASSOC_ID NUMBER
Y Work Order Service Request Entity Association Identifier
MAINTENANCE_ORGANIZATION_ID NUMBER
Y Maintenance Organization ID
WIP_ENTITY_ID NUMBER
Y Work Order ID
SERVICE_REQUEST_ID NUMBER
Y Service Request ID
CREATION_DATE DATE
Y Creation date for the association
CREATED_BY NUMBER
Y Created By User
LAST_UPDATE_LOGIN NUMBER

Standard who column
PROGRAM_ID NUMBER

Standard who column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Segment
LAST_UPDATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
REQUEST_ID NUMBER

Request ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
ENABLE_FLAG VARCHAR2 (1)
Stores whether the Service Request association is enabled

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

This table is used for storing user-defined status and their association with WIP statuses. All the seeded statuses have Enabled_Flag as Y and Seeded_Flag as Y

Indexes
Index Type Tablespace Column
EAM_WO_STATUSES_B_U1 UNIQUE APPS_TS_TX_IDX STATUS_ID
Columns
Name Datatype Length Mandatory Comments
STATUS_ID NUMBER
Y Unique status Id
SEEDED_FLAG VARCHAR2 (1)
Stores Y for seeded status and N/Null for user defined status
SYSTEM_STATUS NUMBER
Y The WIP status id. This maps to Lookup_Code for Wip_Job_Status lookup
ENABLED_FLAG VARCHAR2 (1)
Indicates whether status is enabled or not.Y indicates enabled and Null/N indicates disabled.
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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 %
Comments

This table contains translation information for Work Order Statuses.

Indexes
Index Type Tablespace Column
EAM_WO_STATUSES_TL_U1 UNIQUE APPS_TS_TX_IDX STATUS_ID
LANGUAGE
EAM_WO_STATUSES_TL_U2 UNIQUE APPS_TS_TX_IDX USER_DEFINED_STATUS
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
STATUS_ID NUMBER
Y Unique status Id
SOURCE_LANG VARCHAR2 (4) Y Language from which you are translating
LANGUAGE VARCHAR2 (4) Y Language to which you are translating
USER_DEFINED_STATUS VARCHAR2 (80) Y Work Order Status
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

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

Table for storing workflow item type and keys corresponding to a work order. This will be used to show the Approval History information of work order.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

Stores the Wip Entity Id
WF_ITEM_TYPE VARCHAR2 (8)
This stores the workflow type workflow
WF_ITEM_KEY VARCHAR2 (240)
This stores the workflow key
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
ASSOCIATION_ID NUMBER

Association Id
INITIAL_READING NUMBER

METER_ID NUMBER

Meter Identifier
ORGANIZATION_ID NUMBER

Organization Identifier
ASSET_GROUP_ID NUMBER

Asset Group Identifier
ASSET_NUMBER VARCHAR2 (30)
Asset number
METER_NAME VARCHAR2 (80)
Meter Name
METER_TYPE NUMBER

METER_UOM VARCHAR2 (3)
Unit of Measure of the meter
VALUE_CHANGE_DIR VARCHAR2 (1)
Meter value change direction
EAM_REQUIRED_FLAG VARCHAR2 (1)
EAM Required Flag
PRIMARY_FAILURE_FLAG VARCHAR2 (1)
Primary Failure Flag
USED_IN_SCHEDULING VARCHAR2 (1)
Meter used in scheduling flag
USER_DEFINED_RATE NUMBER

User defined meter usage rate
USE_PAST_READING NUMBER

Number of past readings
DESCRIPTION VARCHAR2 (240)
Description of meter
FROM_EFFECTIVE_DATE DATE

Effective From Date of meter
TO_EFFECTIVE_DATE DATE

Effective To date of meter
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
MAINTENANCE_OBJECT_TYPE NUMBER

MAINTENANCE_OBJECT_ID NUMBER

CREATION_ORGANIZATION_ID NUMBER

TMPL_FLAG CHAR (1)
SOURCE_TMPL_ID NUMBER

EAM_ITEM_TYPE NUMBER

EAM Item Type
ASSET_GROUP VARCHAR2 (40)
Asset Group
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ASSET_DESCRIPTION VARCHAR2 (240)
Asset Number/Group Description
SOURCE_METER_NAME VARCHAR2 (80)
Source Counter
FACTOR NUMBER

Factor
INITIAL_READING_DATE DATE

Initial Reading Date
RELATIONSHIP_START_DATE DATE

Relationship Start Date
MAINT_ORGANIZATION_ID NUMBER

Maint Organization Id

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y Work Order Id
ORGANIZATION_ID NUMBER
Y Inventory Organization id
ACTIVITY_ID NUMBER

Maintenance Activity against which this work order is cut
BILLED_QUANTITY NUMBER

Billed Quantity
BILL_INVENTORY_ITEM_ID NUMBER

Id of Item desired to be billed
BILL_UOM VARCHAR2 (3)
BILL_QUANTITY NUMBER

Unit of Measure Code for billed item
ACTIVITY_DESCRIPTION VARCHAR2 (240)
Maintenance Activity Description
ACTIVITY_TYPE VARCHAR2 (80)
Maintenance Activity Type
ACTIVITY_SOURCE VARCHAR2 (80)
Maintenance Activity Source
ACTIVITY_CAUSE VARCHAR2 (80)
Maintenance Activity Cause

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

Work Order Id
ORGANIZATION_ID NUMBER

Inventory Organization Id
OP_SEQ_NUM NUMBER

Operation Sequence Number within the Work Order
ITEM_RESOURCE_ID NUMBER

Item Resource Id
ITEM_RESOURCE_NAME VARCHAR2 (40)
Item Resource Name
TYPE NUMBER

Internal Type
UOM VARCHAR2 (3)
Unit Of Measure
APPLIED_QUANTITY NUMBER

Quantity Applied or used against the work order.
BILLED_QUANTITY NUMBER

Quantity billed
BILL_INVENTORY_ITEM_ID NUMBER

Billable Item Id
BILL_UOM VARCHAR2 (3)
Billable Unit of Measure
BILL_QUANTITY NUMBER

Billable Quantity
BILLING_METHOD NUMBER

Billing Method: 1=Bill By Requirements, 2=Bill By Activity 3=Capitalization

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y Wip entity id
ORGANIZATION_ID NUMBER
Y Organization id
OPERATIONS_DEPT_ID NUMBER

Operations department identifier
OPERATIONS_SEQ_NUM NUMBER

Operation sequence number
OPERATION_DEPT_CODE VARCHAR2 (10) Y Department code
ITEM_DESCRIPTION VARCHAR2 (240)
Direct item description
ITEM_COST NUMBER

Cost of direct item
REQUIRED_QUANTITY NUMBER

Required quantity
REQUISITION_NUMBER VARCHAR2 (20)
Requisition number
PO_NUMBER VARCHAR2 (20)
Purchase order number
TOTAL_DIRECT_COST NUMBER
Y Total direct item cost
ITEM_NAME VARCHAR2 (40)

[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

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View for getting the resource instances- both person and equipment

Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (240)
Name of the instance - including both person and equipment
ORGANIZATION_ID NUMBER

Organization id to which the instance belong

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER
Y Work Order identifier
ORGANIZATION_ID NUMBER
Y Organization identifier
OPERATIONS_DEPT_ID NUMBER

Operations department identifier
OPERATIONS_SEQ_NUM NUMBER

Operation sequence number
OPERATION_DEPT_CODE VARCHAR2 (10) Y Operation department code
CONCATENATED_SEGMENTS VARCHAR2 (40)
Item name
REQUIRED_QUANTITY NUMBER

Required quantity for the material
ITEM_COST NUMBER

Item cost of material
TOTAL_ITEM_COST NUMBER

Total item cost

[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

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier (for internal use only)
INTERFACE_ID NUMBER

Interface identifier
GROUP_ID NUMBER
Y Group identifier
PROCESS_PHASE NUMBER
Y Process phase
PROCESS_PHASE_MEANING VARCHAR2 (80)
The meaning of process phase
PROCESS_STATUS NUMBER
Y Process status
PROCESS_STATUS_MEANING VARCHAR2 (80)
The meaning of process status
METER_ID NUMBER

Meter identifier
METER_NAME VARCHAR2 (50)
Meter name
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
WIP_ENTITY_ID NUMBER

Work Order Identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Work Order name
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATED_BY_NAME VARCHAR2 (100)
Standard Who column
CREATION_DATE DATE

Standard Who column
READING_VALUE NUMBER

Reading Value
READING_DATE DATE
Y Reading Date
RESET_FLAG VARCHAR2 (1)
Reset Flag for meter
LIFE_TO_DATE_READING NUMBER

Life to date reading
DESCRIPTION VARCHAR2 (240)
Description for meter reading
SOURCE_CODE VARCHAR2 (30)
Source Code
SOURCE_LINE_ID NUMBER

Source Line Identifier
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Extended Who column
PROGRAM_ID NUMBER

Extended Who column
PROGRAM_APPLICATION_ID NUMBER

Extended Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
READING_CHANGE NUMBER

DISABLE_FLAG VARCHAR2 (1)

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
METER_ID NUMBER

Meter identifier
METER_NAME VARCHAR2 (80)
Meter name
METER_TYPE NUMBER

Meter type
METER_UOM VARCHAR2 (3)
Meter unit of measure
VALUE_CHANGE_DIR VARCHAR2 (1)
Meter value change direction
METER_READING_ID NUMBER

Meter reading identifier
CURRENT_READING NUMBER

Current reading value
CURRENT_READING_DATE DATE

Date when the current reading was taken
RESET_FLAG VARCHAR2 (1)
Reset flag for the meter
DISABLE_FLAG VARCHAR2 (1)
Disable flag to disable meter reading
WIP_ENTITY_ID NUMBER

Work Order identifier
LIFE_TO_DATE_READING NUMBER

Life to date reading value
DESCRIPTION VARCHAR2 (1996)
Description for meter reading
FROM_EFFECTIVE_DATE DATE

Effective from date
TO_EFFECTIVE_DATE DATE

Effective to date
CREATED_BY NUMBER (15)
Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER (15)
Standard WHO Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard WHO Column
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CURR_READING_NEW NUMBER

New meter reading
CURR_READING_DATE DATE

New meter reading date
CURR_CHANGE NUMBER

Change from last meter reading
PREV_DESC VARCHAR2 (1996)
ROW_ID ROWID (10)
PREV_RESET VARCHAR2 (1)
ATTRIBUTE16 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE17 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE18 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE19 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE20 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE21 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE22 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE23 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE24 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE25 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE26 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE27 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE28 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE29 VARCHAR2 (150)
Standard Flexfield Columns
ATTRIBUTE30 VARCHAR2 (150)
Standard Flexfield Columns

[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

Comments
View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View provides a list of Next operations for a specific operation in a work order depends upon the Dependency Definition defined in WIP_OPERATION_NETWORKS

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQ_NUM NUMBER
Y Next operation
DESCRIPTION VARCHAR2 (240)
Description
DEPARTMENT_CODE VARCHAR2 (10) Y Assigned department
OPERATION_COMPLETED VARCHAR2 (80) Y Completion status(yes/No)
SCHEDULE_START_DATE DATE
Y Scheduled start date
SCHEDULE_END_DATE DATE
Y Scheduled end date
SCHEDULE_DURATION NUMBER

Scheduled duration
ACTUAL_START_DATE DATE

Actual start date
ACTUAL_END_DATE DATE

Actual end date
WIP_ENTITY_ID NUMBER
Y Work order identifier
PRIOR_OPERATION NUMBER
Y Current operation

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Transaction identifier of the complete or uncomplete transaction
TRANSACTION_DATE DATE
Y Transaction Date
TRANSACTION_TYPE NUMBER
Y Transaction Type. It takes on value=1 as this view has only those transactions where operations are in completed state of a given work order.
WIP_ENTITY_ID NUMBER
Y Work Order Identifier
ORGANIZATION_ID NUMBER
Y Inventory Organization Identifier
OPERATION_SEQ_NUM NUMBER
Y Operation Sequence Number
DEPARTMENT_ID NUMBER
Y Department Identifier
ASSET_GROUP_ID NUMBER

Inventory Item Identifier of the Asset Group
ASSET_NUMBER VARCHAR2 (30)
Serial Number that represents the asset number
ASSET_ACTIVITY_ID NUMBER

Inventory Item Identifier of the Asset Activity
ACTUAL_START_DATE DATE

Actual Start Date of the Operation
ACTUAL_END_DATE DATE

Actual End Date of the Operation
LAST_UPDATE_DATE DATE
Y Standard Who Column

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PM_GROUP_ID NUMBER
Y Preventive Maintenance Group identifier
WORK_ORDER_PM_TYPE NUMBER

Preventive Maintenance work order type
WORK_ORDER_PM_TYPE_MEANING VARCHAR2 (80)
Preventive Maintenance work order type meaning
WORK_ORDER_PM_ACTION NUMBER
Y Suggested action identifier for Preventive Maintenance work order
WORK_ORDER_PM_ACTION_MEANING VARCHAR2 (80)
Suggested action for Preventive Maintenance work order
WIP_ENTITY_ID NUMBER

Work order identifier
WIP_ENTITY_NAME VARCHAR2 (240)
Work order
ORGANIZATION_ID NUMBER

Organization identifier
FORECAST_ID NUMBER
Y Forecast identifier
ASSET_GROUP_ID NUMBER

Asset group identifier
ASSET_NUMBER VARCHAR2 (30)
Asset number
ASSET_ACTIVITY_ID NUMBER

Asset activity identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
STATUS_TYPE NUMBER

Work Order status type identifier
DESCRIPTION VARCHAR2 (240)
Description
FIRM_PLANNED_FLAG NUMBER

Planned Flag
SCHEDULED_START_DATE DATE

Scheduled start date
SCHEDULED_COMPLETION_DATE DATE

Scheduled completion date
WORK_ORDER_START_DATE DATE

Work Order start date
WORK_ORDER_COMPLETION_DATE DATE

Work Order completion date
PRIORITY NUMBER

Priority identifier
PRIORITY_MEANING VARCHAR2 (80)
Priority
PM_SCHEDULE_ID NUMBER
Y Schedule identifier
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order type identifier
WORK_ORDER_TYPE_MEANING VARCHAR2 (80)
Work Order type
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type identifier
ACTIVITY_TYPE_MEANING VARCHAR2 (80)
Activity Type
ACTIVITY_CAUSE VARCHAR2 (30)
Activity cause identifier
ACTIVITY_CAUSE_MEANING VARCHAR2 (80)
Activity cause
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown type identifier
SHUTDOWN_TYPE_MEANING VARCHAR2 (80)
Shutdown type
OWNING_DEPARTMENT_ID NUMBER

Owning department identifier
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
Owning Department code
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification required flag
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout required flag
PLAN_MAINTENANCE VARCHAR2 (1)
Plan maintenance flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
CYCLE_ID NUMBER

This indicates the maintenance cycle under which the work order is created
SEQ_ID NUMBER

This indicates the maintenance sequence of the work order within a cycle
WO_STATUS NUMBER

This indicates the user defined status id
WORK_ORDER_STATUS VARCHAR2 (80)
User defined status description
PM_NAME VARCHAR2 (50)
PM Schedule Name
EAM_ITEM_TYPE NUMBER

eAM item type
WO_STATUS_DISP VARCHAR2 (4000)
This shows either Forecasted Work Order or the status of created Work Orders
MAINTENANCE_OBJECT_ID NUMBER

Maintenance Object Id
MAINTENANCE_OBJECT_TYPE NUMBER

Maintenance Object Type

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ASSOCIATION_ID NUMBER
Y Activity association identifier
ASSET_NUMBER VARCHAR2 (30)
Maintained unit name
METER_ID NUMBER

Meter identifier
METER_NAME VARCHAR2 (80)
Meter name
METER_UOM VARCHAR2 (3)
UOM
VALUE_CHANGE_DIR VARCHAR2 (1)
'Ascending' or 'Descending' meter
DESCRIPTION VARCHAR2 (240)
Meter description
USAGE_RATE NUMBER

Meter usage rate
CREATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ASSOCIATION_ID NUMBER
Y Activity association identifier
LAST_SERVICE_READING NUMBER

Last service meter reading
ASSET_NUMBER VARCHAR2 (30)
Asset serial number
METER_ID NUMBER

Meter identifier
METER_NAME VARCHAR2 (80)
Meter name
METER_UOM VARCHAR2 (3)
Meter unit of measure
VALUE_CHANGE_DIR VARCHAR2 (1)
'Ascending' or 'Descending' meter
DESCRIPTION VARCHAR2 (240)
Meter description
USAGE_RATE NUMBER

Meter usage rate
CREATED_BY NUMBER
Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER
Y Standard who column

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
PM_SCHEDULE_ID NUMBER

Identifier for this PM schedule
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Asset Group identifier
ASSET_NUMBER VARCHAR2 (30)
Asset Number or Rebuild serial number
NON_SCHEDULED_FLAG VARCHAR2 (1)
Non scheduled flag
FROM_EFFECTIVE_DATE DATE

Date from which this PM schedule is effective
TO_EFFECTIVE_DATE DATE

Date till which this PM schedule record will be effective
RESCHEDULING_POINT NUMBER

Rescheduling point
LEAD_TIME NUMBER

Lead time
CREATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column
PM_SOURCE_CODE VARCHAR2 (30)
Application that the PM is created in
PM_SOURCE_LINE VARCHAR2 (30)
Source that PM is created from.
DEFAULT_IMPLEMENT VARCHAR2 (1)
Flag that tells whether this PM schedule is a default shcedule
WHICHEVER_FIRST VARCHAR2 (1)
Whichever first or later
INCLUDE_MANUAL VARCHAR2 (1)
Flag to indicate whether to include manual WOs
SET_NAME_ID NUMBER

PM Set Name id for this Schedule
SET_NAME VARCHAR2 (80)
PM Set Name for this schedule
SCHEDULING_METHOD_CODE NUMBER

Scheduling method code
TYPE_CODE NUMBER

Schedule Type code
SOURCE_TMPL_ID NUMBER

Schedule identifier from which this schedule is instantiated
AUTO_INSTANTIATION_FLAG VARCHAR2 (1)
Auto Instantiation flag
NAME VARCHAR2 (50)
Schedule Name
TMPL_FLAG VARCHAR2 (1)
Flag to indicate whether this schedule is template
MAINTENANCE_OBJECT_ID NUMBER

gen_object_id of the maintenance object
MAINTENANCE_OBJECT_TYPE NUMBER

type of the maintenance object
EAM_ITEM_TYPE NUMBER

Eam Item Type
GENERATE_WO_STATUS NUMBER

Generate Work order status identifier, which indicates in which status work order has to be created, based on PM schedule.
WORK_ORDER_STATUS VARCHAR2 (80)
Description of Work Order Status Id
INTERVAL_PER_CYCLE NUMBER

This will store the number in which the cycle will be divided.
CURRENT_CYCLE NUMBER

This will store the Current Cycle based on which the PM Schedule will be defined.
CURRENT_SEQ NUMBER

This will store the current sequence within a cycle and will be used for resequencing of work orders
BASE_DATE DATE

This will store the Base Date from which the PM engine has to generate the Work Orders.
BASE_READING NUMBER

This will store the Base Reading from which the PM engine has to generate the Work Orders.
EAM_LAST_CYCLIC_ACT NUMBER

This will store the last cyclical activity performed for that PM Schedule.
INSTANCE_ID NUMBER

This will display the Instance Id of Asset. Unique identifier
CONCATENATED_SEGMENTS VARCHAR2 (40)
Displays the Asset Group
DESCRIPTION VARCHAR2 (240)
Displays the Asset Group Description
INSTANCE_DESCRIPTION VARCHAR2 (240)
Asset Serial Number Description
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
LOCAL_FLAG VARCHAR2 (1)
Flag indicating whether the PM set is globally visible or only visible for the owning organization
OWNING_ORGANIZATION_ID NUMBER

The Organization in which the PM Set currently belongs to
NETWORK_ASSET VARCHAR2 (1)
Network asset flag
LAST_REVIEWED_BY_ID NUMBER (15)
PM Last Review By
LAST_REVIEWED_DATE DATE

PM Last Review Date
LAST_REVIEWED_BY VARCHAR2 (240)
PM Last Reviewed by
GENERATE_NEXT_WORK_ORDER VARCHAR2 (1)
Flag to generate next work order only

[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

Comments
View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View provides a list of prior operations for a specific operation in a work order. This depends upon the dependency definition in WIP_OPERATION_NETWORKS

Columns
Name Datatype Length Mandatory Comments
OPERATION_SEQ_NUM NUMBER
Y Prior operation
DESCRIPTION VARCHAR2 (240)
Description
DEPARTMENT_CODE VARCHAR2 (10) Y Assigned department
OPERATION_COMPLETED VARCHAR2 (80) Y Completion status(Yes/No)
SCHEDULE_START_DATE DATE
Y Schedule start date
SCHEDULE_END_DATE DATE
Y Schedule end date
SCHEDULE_DURATION NUMBER

Schedule duration
ACTUAL_START_DATE DATE

Actual start date
ACTUAL_END_DATE DATE

Actual end date
WIP_ENTITY_ID NUMBER
Y Work order identifier
NEXT_OPERATION NUMBER
Y Current operation

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WORK_ORDER VARCHAR2 (240) Y Maintenance Work Order
DESCRIPTION VARCHAR2 (240)
Maintenance Work Order Description
WIP_ENTITY_ID NUMBER
Y Maintenance Work Order Identifier
REBUILD_ITEM_ID NUMBER

Rebuildable Item Identifier
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Item Serial Number
SCHEDULED_START_DATE DATE
Y Scheduled Start Date of the rebuild work order
SCHEDULED_COMPLETION_DATE DATE
Y Scheduled End Date of the rebuild work order
REBUILD_ACTIVITY_ID NUMBER

Asset Activity associated with the rebuild item
DURATION1 NUMBER

Duration of the work order
PARENT_WORK_ORDER VARCHAR2 (240)
Parent Work Order that is associated with the rebuild work order
ASSET_NUMBER VARCHAR2 (30)
Asset Number of the Parent Work Order
ASSET_GROUP_ID NUMBER

Asset Group of the Parent Work Order
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Subinventory for the repair and restock rebuild items
COMPLETION_LOCATOR_ID NUMBER

Locator field for the Completion Subinventory for the repair and restock rebuild items
LOT_NUMBER VARCHAR2 (80)
Lot field for the Completion Subinventory for the non repair and restock rebuild items
MANUAL_REBUILD_FLAG VARCHAR2 (1)
Rebuild flag that specifies if the work order is for repair and reinstall or repair and restock
STATUS_TYPE NUMBER
Y Status of the rebuild work order
PROJECT_ID NUMBER

Project Identifier to the project that the work order belongs
TASK_ID NUMBER

Task Identifier to the project that the work order belongs
PARENT_WIP_ENTITY_ID NUMBER

Parent Maintenance Work Order Identifier of the rebuild work order
ORGANIZATION_ID NUMBER
Y Organization Identifier
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

Wip entity id
ORGANIZATION_ID NUMBER

Organization id
OPERATIONS_DEPT_ID NUMBER

Operation department id
OPERATIONS_SEQ_NUM NUMBER

Operation sequence number
OPERATION_DEPT_CODE VARCHAR2 (10)
Operation department code
RES_CODE VARCHAR2 (10)
Resource code
RESOURCE_RATE NUMBER

Resource rate
UOM VARCHAR2 (15)
Unit of measurement
RESOURCE_USAGE NUMBER

Resource usage
TOTAL_RESOURCE_COST NUMBER

Total resource cost
RESOURCE_TYPE VARCHAR2 (80)
RESOURCE_BASIS VARCHAR2 (80)
RESOURCE_OVERHEAD_COST NUMBER

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER

Rule identifier
ACTIVITY_ASSOCIATION_ID NUMBER

Activity association identifier
PM_SCHEDULE_ID NUMBER

PM schedule identifier
RULE_TYPE NUMBER

Rule type of this rule
METER_ID NUMBER

Meter identifier
METER_NAME VARCHAR2 (80)
Name of the meter
METER_UOM VARCHAR2 (3)
Meter unit of measure
VALUE_CHANGE_DIR VARCHAR2 (1)
The value change direction for the meter
METER_DESCRIPTION VARCHAR2 (240)
Meter description
RUNTIME_INTERVAL NUMBER

Runtime Interval. This will be used in the PM calculations
LAST_SERVICE_READING NUMBER

Last service reading
CREATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
EFFECTIVE_READING_FROM NUMBER

Reading from which this rule is effective
EFFECTIVE_READING_TO NUMBER

Reading till which this reading will be effective
EFFECTIVE_DATE_FROM DATE

Date from which this rule is effective
EFFECTIVE_DATE_TO DATE

Date till which this rule will be effective
USER_DEFINED_RATE NUMBER

User defined rate

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
INCIDENT_ID NUMBER (15) Y Service Request Identifier
INCIDENT_NUMBER VARCHAR2 (64) Y Service Request Number
INCIDENT_STATUS_ID NUMBER (15) Y Identifier for Service Request Status
STATUS VARCHAR2 (30)
Status
INCIDENT_SEVERITY_ID NUMBER (15) Y Identifier for Service Request Severity
SEVERITY VARCHAR2 (30)
Severity
ORG_ID NUMBER

Operating Unit Identifier
INV_ORGANIZATION_ID NUMBER

Identifier for Inventory Organization
INVENTORY_ITEM_ID NUMBER (15)
Identifier for Inventory Item
OPERATING_UNIT NUMBER

Operating Unit
ITEM_NAME VARCHAR2 (40)
Inventory Item
REQUEST_DATE DATE
Y Creation Date of Service Request
REQUEST_BY_DATE DATE

Expected Resolution Date
SUMMARY VARCHAR2 (240) Y Summary of Service Request
DEPARTMENT VARCHAR2 (10)
Department Name
OWNING_DEPARTMENT_ID NUMBER

Department Id
STATUS_FLAG VARCHAR2 (3) Y
MAINTENANCE_FLAG VARCHAR2 (3)
MAINT_ORGANIZATION_ID NUMBER

Maintenance Organization Id
MAINTENANCE_OBJECT_TYPE NUMBER

Maintenance Object Type
MAINTENANCE_OBJECT_ID NUMBER

Maintenance Object Id
ASSET_NUMBER VARCHAR2 (30)
Instance Number

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier (internal use only)
PARENT_ASSOCIATION_ID NUMBER
Y Parent Asset Activity association identifier
PARENT_ACTIVITY_ID NUMBER
Y Parent Activity identifier
CHILD_ASSOCIATION_ID NUMBER
Y Child Asset Activity association identifier
CHILD_ACTIVITY_ID NUMBER
Y Child Asset Activity association identifier
CHILD_ACTIVITY VARCHAR2 (40)
Child Activity
DESCRIPTION VARCHAR2 (240)
Description
CREATED_BY NUMBER
Y Standard Who columns
CREATION_DATE DATE
Y Standard Who columns
LAST_UPDATE_LOGIN NUMBER

Standard Who columns
LAST_UPDATE_DATE DATE
Y Standard Who columns
LAST_UPDATED_BY NUMBER
Y Standard Who columns
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield column
MAINTENANCE_OBJECT_TYPE NUMBER

Maintenance Object Type
MAINTENANCE_OBJECT_ID NUMBER

Maintenance Object Id

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id of WIP_DISCRETE_JOBS table
SCHED_PARENT_WIP_ENTITY_NAME VARCHAR2 (240)
Parent Wip Entity Name
ACTUAL_START_DATE DATE

Actual Start Date
WIP_ENTITY_ID NUMBER
Y Wip Entity Id
WIP_ENTITY_NAME VARCHAR2 (240) Y Wip Entity Name
WE_ROW_ID ROWID (10)
Row Id of Wip Entity Table
ENTITY_TYPE NUMBER
Y Entity Type
ORGANIZATION_ID NUMBER
Y Organization Id
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER
Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
DESCRIPTION VARCHAR2 (240)
Description
PRIMARY_ITEM_ID NUMBER

Primary Item Id - Asset Activity Id
ASSET_GROUP_ID NUMBER

Asset Group Id - Inventory Item Id of the Asset
ASSET_NUMBER VARCHAR2 (30)
Asset Number
ASSET_DESCRIPTION VARCHAR2 (240)
Asset Description
CLASS_CODE VARCHAR2 (10) Y Accounting Class Code
STATUS_TYPE NUMBER
Y Work Order Status
PM_SCHEDULE_ID NUMBER

PM Schedule Id
MANUAL_REBUILD_FLAG VARCHAR2 (1)
Manual Rebuild Flag
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type - Lookup
WORK_ORDER_TYPE_DISP VARCHAR2 (80)
Work Order Type - Meanings from Lookup
MATERIAL_ACCOUNT NUMBER

Material Account
MATERIAL_OVERHEAD_ACCOUNT NUMBER

Material Overhead Account
RESOURCE_ACCOUNT NUMBER

Resource Account
OUTSIDE_PROCESSING_ACCOUNT NUMBER

Outside Processing Account
MATERIAL_VARIANCE_ACCOUNT NUMBER

Material Variance Account
RESOURCE_VARIANCE_ACCOUNT NUMBER

Resource Variance Account
OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

Outside Processing Variance Account
STD_COST_ADJUSTMENT_ACCOUNT NUMBER

Standard Cost Adjustment Account
OVERHEAD_ACCOUNT NUMBER

Overhead Account
OVERHEAD_VARIANCE_ACCOUNT NUMBER

Overhead Variance Account
SCHEDULED_START_DATE DATE
Y Work Order Scheduled Start Date
SCHEDULED_COMPLETION_DATE DATE
Y Work Order Scheduled Completion Date
DATE_RELEASED DATE

Work Order Release Date
DATE_COMPLETED DATE

Completion Date of Work Order
DATE_CLOSED DATE

Closing Date of Work Order
OWNING_DEPARTMENT NUMBER

Owning Department of Work Order
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
Owning Department Code of Work Order
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type - Lookup
ACTIVITY_TYPE_DISP VARCHAR2 (80)
Activity Type - Meaning from Lookup
ACTIVITY_CAUSE VARCHAR2 (30)
Activity Cause - Lookup
ACTIVITY_CAUSE_DISP VARCHAR2 (80)
Activity Cause - Meaning from Lookup
PRIORITY NUMBER

Priority - from Lookup
PRIORITY_DISP VARCHAR2 (80)
Priority - Meaning from Lookup
REQUESTED_START_DATE DATE

Requested Start Date
REQUESTED_DUE_DATE DATE

Requested Due Date
ESTIMATION_STATUS NUMBER

Estimation Status
NOTIFICATION_REQUIRED VARCHAR2 (1)
Notification Required
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type - Lookup
SHUTDOWN_TYPE_DISP VARCHAR2 (80)
Shutdown Type - Meaning from Lookup
TAGOUT_REQUIRED VARCHAR2 (1)
Tagout Required
PLAN_MAINTENANCE VARCHAR2 (1)
Planned Maintenance
FIRM_PLANNED_FLAG NUMBER
Y Firm flag
SCHEDULE_GROUP_ID NUMBER

Schedule Group Id
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Schedule Group Name
PROJECT_NUMBER VARCHAR2 (4000)
Project Number
PROJECT_NAME VARCHAR2 (4000)
Project Name
PROJECT_ID NUMBER

Project Id
TASK_NUMBER VARCHAR2 (4000)
Task Number
TASK_NAME VARCHAR2 (4000)
Task Name
TASK_ID NUMBER

Task Id
PARENT_WIP_ENTITY_ID NUMBER

Parent Wip Entity Id - Parent Work Order Id
PARENT_WIP_ENTITY_NAME VARCHAR2 (240)
Parent Work Order Name
REBUILD_ITEM_ID NUMBER

Rebuild Item Id - Inventory Item Id of Rebuild Item
REBUILD_SERIAL_NUMBER VARCHAR2 (30)
Rebuild Serial Number
BOM_REFERENCE_ID NUMBER

Bill of Materials Reference Id
ROUTING_REFERENCE_ID NUMBER

Routing Reference Id
COMMON_BOM_SEQUENCE_ID NUMBER

Common BOM Sequence Id
COMMON_ROUTING_SEQUENCE_ID NUMBER

Common Routing Sequence Id
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM Designator
BOM_REVISION VARCHAR2 (3)
Revision of Bill of Materials
BOM_REVISION_DATE DATE

Revision Date of Bill of Materials
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate Routing Designator
ROUTING_REVISION VARCHAR2 (3)
Routing Revision
ROUTING_REVISION_DATE DATE

Routing Revision Date
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Subinventory
COMPLETION_LOCATOR_ID NUMBER

Completion Locator Id
LOT_NUMBER VARCHAR2 (80)
Lot Number
DEMAND_CLASS VARCHAR2 (30)
Demand Class
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Segments
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segments
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segments
INSTANCE_ID NUMBER

Instance Id
INSTANCE_NUMBER VARCHAR2 (30)
Instance Number
MAINTENANCE_OBJECT_SOURCE NUMBER

Maintenance Object Source
MAINTENANCE_OBJECT_TYPE NUMBER

Maintenance Object Type
SOURCE VARCHAR2 (80)
Source
MAINTENANCE_OBJECT_ID NUMBER

Maintenance Object Id - Genealogy Object Id for serialized rebuild items/assets and inventory item id for non-serialized rebuilds
SERVICE_REQUEST_ID NUMBER

Service Request Id
SERVICE_REQUEST VARCHAR2 (64)
Service Request
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Material Issue By Move Order
ACTIVITY_SOURCE VARCHAR2 (30)
Activity Source - Lookup
ACTIVITY_SOURCE_MEANING VARCHAR2 (80)
Activity Source - Meaning from Lookup
EAM_LINEAR_LOCATION_ID NUMBER

PENDING_FLAG VARCHAR2 (1)
Stores whether status change has some pending approval.Y indicates status is pending, N or Null indicates not pending
USER_DEFINED_STATUS_ID NUMBER

Stores the User defined work order status
WORK_ORDER_STATUS VARCHAR2 (80)
Status of work order
WORK_ORDER_STATUS_PENDING VARCHAR2 (4000)
Concatenates Pending flag with user defined status if the work order is in pending status else shows the user defined status
MATERIAL_SHORTAGE_CHECK_DATE DATE

The date at which the work order was checked for material shortage
MATERIAL_SHORTAGE_FLAG NUMBER

Stores the material shortage status of the workorder. 2 if all material is available, 1 if some/all material is not available, null if shortage has not been calculated yet, 3 if an error occurred when calculating the shortage
MATERIAL_SHORTAGE_DISP VARCHAR2 (80)
Description of material shortage
WORKFLOW_TYPE NUMBER

Stores the Workflow Type to find the workflow process to be followed. Maps to lookup_code for EAM_WORKFLOW_TYPE lookup type
WARRANTY_CLAIM_STATUS NUMBER

The status of the warranty claim.
CYCLE_ID NUMBER

Used by Multiple Asset Activity PM
SEQ_ID NUMBER

Used by Multiple Asset Activity PM
DS_SCHEDULED_FLAG VARCHAR2 (1)
Identify if the Detailed Scheduler has scheduled the work order.
ASSET_SERIAL_NUMBER VARCHAR2 (30)
serial_number
MAINT_ORGANIZATION_ID NUMBER

Maintenance organization id
ASSET_REBUILD_GROUP VARCHAR2 (40)
Concatenated segments for Asset Group / Rebuild Items
PM_SUGGESTED_START_DATE DATE

Original Scheduled Start Date
PM_SUGGESTED_END_DATE DATE

Original Scheduled End Date
FAILURE_ID NUMBER

Failure identifier
FAILURE_ENTRY_ID NUMBER

Failure entry identifier
FAILURE_CODE VARCHAR2 (80)
Identifier for failure code
CAUSE_CODE VARCHAR2 (80)
Identifier for cause code
RESOLUTION_CODE VARCHAR2 (80)
Identifier for resolution code
FAILURE_CODE_REQUIRED VARCHAR2 (240)
Flag indicating if failure code entry is required
FAILURE_DATE DATE

Failure date
COMMENTS VARCHAR2 (2000)
Failure comment
PARENT_INSTANCE_NUMBER VARCHAR2 (30)
Asset number of parent work order

[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

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (38) Y Organization Id
CUSTOMER_ID NUMBER (38)
Customer Id
CUSTOMER_NAME VARCHAR2 (360) Y Customer Name
BILL_TO_ADDRESS_ID NUMBER (38)
Customer Bill Address Id
WIP_ENTITY_ID NUMBER (38) Y Work Order Id
WIP_ENTITY_NAME VARCHAR2 (240) Y Work Order Name
OPERATION_SEQ_NUM NUMBER (38)
Operation Sequence Number of Work Order
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (38) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (38) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who Column
INVENTORY_ITEM_ID NUMBER (38)
Item Id
RESOURCE_ID NUMBER (38)
Resource Id
BILLED_INVENTORY_ITEM_ID NUMBER (38) Y Billed Item Id
BILLED_UOM_CODE VARCHAR2 (3)
Billed Unit of Measure Code
BILLED_QUANTITY NUMBER (38)
Billed Quantity
BILLING_BASIS NUMBER (38)
Billing Basis
PRICE_LIST_HEADER_ID NUMBER (38)
Price List Header Id
COST_TYPE_ID NUMBER (38)
Cost Type Id
COST_OR_LISTPRICE NUMBER (38)
Unit Price of Billed Item
COSTPLUS_PERCENTAGE NUMBER (38)
Cost Plus Markup
BILLED_AMOUNT NUMBER

Billed Amount
REF_INVOICE_TRX_NUMBER NUMBER (38)
Reference Invoice header
REF_INVOICE_LINE_NUMBER NUMBER (38)
Reference Invoice Line Number
CURRENCY_CODE VARCHAR2 (15)
Bill Currency Code
CONVERSION_RATE NUMBER (38)
Currency Conversion Rate
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currency Conversion Type Code
CONVERSION_RATE_DATE DATE

Date on which currency conversion done
PROJECT_ID NUMBER (38)
Contract Project Id
PROJECT_NAME VARCHAR2 (30)
Contract Project Name
TASK_ID NUMBER (38)
Contract Project Task Id
TASK_NAME VARCHAR2 (20)
Contract Project Task Name
WORK_REQUEST_ID NUMBER (38)
Maintenance Work Request Id
PA_EVENT_ID NUMBER (38)
Project Accounting Event Id
BILLED_DATE DATE
Y Billed Date
INVOICE_DATE DATE

Invoice Date
TRX_NUMBER VARCHAR2 (20)
Invoice Transaction Number
LINE_NUMBER NUMBER

Invoice Line Number

[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