This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | Asset Explosion Temp |
---|
This is a temporary table used to explode asset hierarchy information.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ASSET_EXPLOSION_TEMP_N1 | NONUNIQUE | APPS_TS_NOLOGGING | GROUP_ID |
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 |
EAM.EAM_ASSET_EXPLOSION_TEMP does not reference any database object
EAM.EAM_ASSET_EXPLOSION_TEMP is referenced by following:
Description: | Stores Information about failure events against the asset. |
---|
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.
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 |
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 |
EAM.EAM_ASSET_FAILURES does not reference any database object
EAM.EAM_ASSET_FAILURES is referenced by following:
Description: | Stores detailed information captured for a failure event. |
---|
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.
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 |
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 |
EAM.EAM_ASSET_FAILURE_CODES does not reference any database object
EAM.EAM_ASSET_FAILURE_CODES is referenced by following:
Description: | This table stores log information of operational status of assets which will be used to analyse the assets. |
---|
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.
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 |
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 |
EAM.EAM_ASSET_LOG does not reference any database object
EAM.EAM_ASSET_LOG is referenced by following:
Description: | Asset Meter Association |
---|
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 |
This table stores association information between Assets and Meters. It stores asset information as well as meter attributes.
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 |
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 |
EAM.EAM_ASSET_METERS does not reference any database object
EAM.EAM_ASSET_METERS is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ASSET_MOVE_TEMP_PK | UNIQUE | INSTANCE_ID |
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 |
EAM.EAM_ASSET_MOVE_TEMP does not reference any database object
EAM.EAM_ASSET_MOVE_TEMP is referenced by following:
Description: | This table stores Asset Operational Transactions, Check-In and Check Out Operations on Assets. |
---|
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.
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 |
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 |
EAM.EAM_ASSET_OPERATION_TXN does not reference any database object
EAM.EAM_ASSET_OPERATION_TXN is referenced by following:
Description: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ASSET_RESULTS_GTT_U1 | UNIQUE | GEN_OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GEN_OBJECT_ID | NUMBER |
EAM.EAM_ASSET_RESULTS_GTT does not reference any database object
EAM.EAM_ASSET_RESULTS_GTT is referenced by following:
Description: | Table for Asset Status History |
---|
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 |
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.
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 |
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 |
EAM.EAM_ASSET_STATUS_HISTORY does not reference any database object
EAM.EAM_ASSET_STATUS_HISTORY is referenced by following:
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 |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ASSET_TEXT_U1 | UNIQUE | APPS_TS_TX_IDX | INSTANCE_ID |
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 |
EAM.EAM_ASSET_TEXT does not reference any database object
EAM.EAM_ASSET_TEXT is referenced by following:
Description: | Table to store the Cause Codes defined in the system |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_FAILURE_COMBINATIONS.CAUSE_CODE | EAM_CAUSE_CODES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_CAUSE_CODES_U1 | UNIQUE | APPS_TS_TX_IDX | CAUSE_CODE |
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 |
EAM.EAM_CAUSE_CODES does not reference any database object
EAM.EAM_CAUSE_CODES is referenced by following:
Description: | Estimations based on Construction Units |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_ESTIMATE_ASSOCIATIONS.ESTIMATE_ID | EAM_CONSTRUCTION_ESTIMATES |
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
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 |
EAM.EAM_CONSTRUCTION_ESTIMATES does not reference any database object
EAM.EAM_CONSTRUCTION_ESTIMATES is referenced by following:
Description: | This table stores the template for construction units. Estimates are build for these construction units. |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_CONSTRUCTION_UNIT_DETAILS.CU_ID | EAM_CONSTRUCTION_UNITS |
EAM_ESTIMATE_ASSOCIATIONS.CU_ID | EAM_CONSTRUCTION_UNITS |
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_CU_ORG_ID_N01 | NONUNIQUE | APPS_TS_TX_IDX | ORGANIZATION_ID |
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 |
EAM.EAM_CONSTRUCTION_UNITS does not reference any database object
EAM.EAM_CONSTRUCTION_UNITS is referenced by following:
Description: | Table to store the construction unit and activity associations |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_CONSTRUCTION_UNIT_DETAILS.CU_ID | EAM_CONSTRUCTION_UNITS |
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_CU_DTL_ID_N01 | NONUNIQUE | APPS_TS_TX_IDX | CU_DETAIL_ID |
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 |
EAM.EAM_CONSTRUCTION_UNIT_DETAILS does not reference any database object
EAM.EAM_CONSTRUCTION_UNIT_DETAILS is referenced by following:
Description: | This table is used to store the information regarding the events which needs to be tracked for all Assets in each maintenance organization. |
---|
This table is used to store the information regarding the events which needs to be tracked for all Assets in each maintenance organization.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ASSET_LOG_CONTROLS_U1 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
EVENT_ID EVENT_TYPE |
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 |
EAM.EAM_CONTROL_EVENT does not reference any database object
EAM.EAM_CONTROL_EVENT is referenced by following:
Description: |
---|
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 |
EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL does not reference any database object
EAM.EAM_EMP_ASSIGNMENT_DETAILS_TBL is referenced by following:
Description: |
---|
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) |
EAM.EAM_EMP_SEARCH_RESULT_TBL does not reference any database object
EAM.EAM_EMP_SEARCH_RESULT_TBL is referenced by following:
Description: | This table stores the various maintenance object source values for which workflow is enabled/disabled |
---|
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.
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 |
EAM.EAM_ENABLE_WORKFLOW does not reference any database object
EAM.EAM_ENABLE_WORKFLOW is referenced by following:
Description: | Association table for Estimates and Construction Units |
---|
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 | % |
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.
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 |
EAM.EAM_ESTIMATE_ASSOCIATIONS does not reference any database object
EAM.EAM_ESTIMATE_ASSOCIATIONS is referenced by following:
Description: | Table to store the Failure Codes defined in the system |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_FAILURE_CODES_U1 | UNIQUE | APPS_TS_TX_IDX | FAILURE_CODE |
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 |
EAM.EAM_FAILURE_CODES does not reference any database object
EAM.EAM_FAILURE_CODES is referenced by following:
Description: | Stores the unique Failure/Cause/Resolution Code Combinations |
---|
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 |
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.
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 |
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 |
EAM.EAM_FAILURE_COMBINATIONS does not reference any database object
EAM.EAM_FAILURE_COMBINATIONS is referenced by following:
Description: | Temporary table used by eAM to hold data about Failure History/Analysis |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_FAILURE_HISTORY_TEMP_N1 | NONUNIQUE | APPS_TS_TX_IDX | GROUP_ID |
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 |
EAM.EAM_FAILURE_HISTORY_TEMP does not reference any database object
EAM.EAM_FAILURE_HISTORY_TEMP is referenced by following:
Description: | All the failure set definitions are stored in this table. |
---|
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.
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 |
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 |
EAM.EAM_FAILURE_SETS does not reference any database object
EAM.EAM_FAILURE_SETS is referenced by following:
Description: | Stores the associations between an Item and an Failure Set. |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_FAILURE_SET_ASSOCIATIONS.SET_ID | % |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_FAILURESET_ASSOCIATION_U1 | UNIQUE | APPS_TS_TX_IDX |
SET_ID
INVENTORY_ITEM_ID |
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 |
EAM.EAM_FAILURE_SET_ASSOCIATIONS does not reference any database object
EAM.EAM_FAILURE_SET_ASSOCIATIONS is referenced by following:
Description: | Forecasted Work Orders |
---|
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 |
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.
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 |
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 |
EAM.EAM_FORECASTED_WORK_ORDERS does not reference any database object
EAM.EAM_FORECASTED_WORK_ORDERS is referenced by following:
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. |
---|
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.
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 |
EAM.EAM_FORECASTS does not reference any database object
EAM.EAM_FORECASTS is referenced by following:
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. |
---|
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.
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 |
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 |
EAM.EAM_FORECAST_CEBBA does not reference any database object
EAM.EAM_FORECAST_CEBBA is referenced by following:
Description: | This table stores all of the work order information for a forecasted work order for eAM maintenance budgeting and forecasting. |
---|
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.
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. |
EAM.EAM_FORECAST_WDJ does not reference any database object
EAM.EAM_FORECAST_WDJ is referenced by following:
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. |
---|
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.
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 |
EAM.EAM_FORECAST_WEDI does not reference any database object
EAM.EAM_FORECAST_WEDI is referenced by following:
Description: | This table stores the operation level information for forecasted work orders for eAM maintenance budgeting and forecasting. |
---|
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.
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 |
EAM.EAM_FORECAST_WO does not reference any database object
EAM.EAM_FORECAST_WO is referenced by following:
Description: | This table stores the resource requirements associated with forecasted work orders for eAM maintenance budgeting and forecasting. |
---|
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.
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 |
EAM.EAM_FORECAST_WOR does not reference any database object
EAM.EAM_FORECAST_WOR is referenced by following:
Description: | This table stores the material requirements of forecasted work orders for eaM maintenance budgeting and forecasting. |
---|
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.
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. |
EAM.EAM_FORECAST_WRO does not reference any database object
EAM.EAM_FORECAST_WRO is referenced by following:
Description: | Work Order Completion Transaction History |
---|
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 |
This is a history table that keeps a record of details of all maintenance work orders completed or uncompleted.
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 |
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 |
EAM.EAM_JOB_COMPLETION_TXNS does not reference any database object
EAM.EAM_JOB_COMPLETION_TXNS is referenced by following:
Description: | This table is for linear location ids pushed into EAM from external sources. |
---|
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.
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 |
EAM.EAM_LINEAR_LOCATIONS does not reference any database object
EAM.EAM_LINEAR_LOCATIONS is referenced by following:
Description: | Material Import Table |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_MATERIAL_IMPORT_N1 | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_MATERIAL_IMPORT does not reference any database object
EAM.EAM_MATERIAL_IMPORT is referenced by following:
Description: | Table for asset meter definition |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_ASSET_METERS.METER_ID | EAM_METERS |
EAM_METER_READINGS.METER_ID | EAM_METERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_METERS_U1 | UNIQUE | APPS_TS_TX_IDX | METER_ID |
EAM_METERS_U2 | UNIQUE | APPS_TS_TX_IDX | METER_NAME |
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 |
EAM.EAM_METERS does not reference any database object
EAM.EAM_METERS is referenced by following:
Description: | Table to store asset meter readings |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_METER_READINGS.METER_ID | EAM_METERS |
EAM_METER_READINGS.WIP_ENTITY_ID | WIP_DISCRETE_JOBS |
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'.
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 |
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 |
EAM.EAM_METER_READINGS does not reference any database object
EAM.EAM_METER_READINGS is referenced by following:
Description: | Asset Meter Readings Interface table |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_MRS_INTERFACE_N1 | NONUNIQUE | APPS_TS_INTERFACE | GROUP_ID |
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 |
EAM.EAM_METER_READINGS_INTERFACE does not reference any database object
EAM.EAM_METER_READINGS_INTERFACE is referenced by following:
Description: | Work Order Operations Import |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_OPERATION_IMPORT_N1 | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_OPERATION_IMPORT does not reference any database object
EAM.EAM_OPERATION_IMPORT is referenced by following:
Description: | Work Order Operation Completion Transaction History |
---|
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 |
This is a history table that keeps a record of all work orders' operations complete and uncomplete events.
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 |
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 |
EAM.EAM_OP_COMPLETION_TXNS does not reference any database object
EAM.EAM_OP_COMPLETION_TXNS is referenced by following:
Description: | Maintenance Organization Specific Defaults For Several Type of Objects |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_ORG_MAINT_DEFAULTS_U1 | UNIQUE | APPS_TS_SEED |
OBJECT_ID
OBJECT_TYPE ORGANIZATION_ID |
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 |
EAM.EAM_ORG_MAINT_DEFAULTS does not reference any database object
EAM.EAM_ORG_MAINT_DEFAULTS is referenced by following:
Description: | This table stores the PM Schedule activities and their associated attributes |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_PM_ACTIVITIES.ACTIVITY_ASSOCIATION_ID | MTL_EAM_ASSET_ACTIVITIES |
EAM_PM_ACTIVITIES.PM_SCHEDULE_ID | EAM_PM_SCHEDULINGS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_PM_ACTIVITIES_U1 | NONUNIQUE | APPS_TS_TX_IDX |
PM_SCHEDULE_ID
ACTIVITY_ASSOCIATION_ID |
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 |
EAM.EAM_PM_ACTIVITIES does not reference any database object
EAM.EAM_PM_ACTIVITIES is referenced by following:
Description: | PM Last Service Information |
---|
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 |
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.
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 |
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 |
EAM.EAM_PM_LAST_SERVICE does not reference any database object
EAM.EAM_PM_LAST_SERVICE is referenced by following:
Description: | PM Scheduling Definition |
---|
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 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 |
This tables stores the details of all user defined Preventive Maintenance schedules.
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 |
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 |
EAM.EAM_PM_SCHEDULINGS does not reference any database object
EAM.EAM_PM_SCHEDULINGS is referenced by following:
Description: | Table to store PM scheduling rules |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_PM_SCHEDULING_RULES.PM_SCHEDULE_ID | EAM_PM_SCHEDULINGS |
EAM_PM_SCHEDULING_RULES.METER_ID | CSI_COUNTERS_B |
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.
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 |
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 |
EAM.EAM_PM_SCHEDULING_RULES does not reference any database object
EAM.EAM_PM_SCHEDULING_RULES is referenced by following:
Description: | PM Set Names |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_PM_SCHEDULINGS.SET_NAME_ID | EAM_PM_SET_NAMES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_PM_SET_NAMES_U1 | UNIQUE | APPS_TS_TX_IDX | SET_NAME_ID |
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 |
EAM.EAM_PM_SET_NAMES does not reference any database object
EAM.EAM_PM_SET_NAMES is referenced by following:
Description: | Table to store the Resolution Codes defined in the system |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_FAILURE_COMBINATIONS.RESOLUTION_CODE | EAM_RESOLUTION_CODES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_RESOLUTION_CODES_U1 | UNIQUE | APPS_TS_TX_IDX | RESOLUTION_CODE |
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 |
EAM.EAM_RESOLUTION_CODES does not reference any database object
EAM.EAM_RESOLUTION_CODES is referenced by following:
Description: | Work Order Resource |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_RESOURCE_IMPORT_N1 | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_RESOURCE_IMPORT does not reference any database object
EAM.EAM_RESOURCE_IMPORT is referenced by following:
Description: | Work Order Resource Instances |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_RESOURCE_INSTANCE_IMPORT_N | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_RESOURCE_INSTANCE_IMPORT does not reference any database object
EAM.EAM_RESOURCE_INSTANCE_IMPORT is referenced by following:
Description: | Work Order Resource Usage |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_RESOURCE_USAGE_IMPORT_N1 | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_RESOURCE_USAGE_IMPORT does not reference any database object
EAM.EAM_RESOURCE_USAGE_IMPORT is referenced by following:
Description: | Table to store PM suppression relations |
---|
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 |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_SUPPRESSION_RELATIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
PARENT_ASSOCIATION_ID
CHILD_ASSOCIATION_ID |
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 |
EAM.EAM_SUPPRESSION_RELATIONS does not reference any database object
EAM.EAM_SUPPRESSION_RELATIONS is referenced by following:
Description: | Work Order Billing Information. |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_WORK_ORDER_BILLS.BILLED_INVENTORY_ITEM_ID
EAM_WORK_ORDER_BILLS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_WORK_ORDER_BILLS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
BILLED_INVENTORY_ITEM_ID
ORGANIZATION_ID WIP_ENTITY_ID |
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 |
EAM.EAM_WORK_ORDER_BILLS does not reference any database object
EAM.EAM_WORK_ORDER_BILLS is referenced by following:
Description: | eAM Work Order Details |
---|
This table stores the work order detail information specific for eAM
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 |
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 |
EAM.EAM_WORK_ORDER_DETAILS does not reference any database object
EAM.EAM_WORK_ORDER_DETAILS is referenced by following:
Description: | Work Order Import |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_WORK_ORDER_IMPORT_N1 | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
WIP_ENTITY_ID |
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 |
EAM.EAM_WORK_ORDER_IMPORT does not reference any database object
EAM.EAM_WORK_ORDER_IMPORT is referenced by following:
Description: | Work Order Import Errors |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
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 |
EAM.EAM_WORK_ORDER_IMPORT_ERRORS does not reference any database object
EAM.EAM_WORK_ORDER_IMPORT_ERRORS is referenced by following:
Description: | Route Asset History Table |
---|
This tables stores the history of Asset Route
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_WORK_ORDER_ROUTE_N1 | NONUNIQUE | APPS_TS_TX_IDX | WIP_ENTITY_ID |
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 |
EAM.EAM_WORK_ORDER_ROUTE does not reference any database object
EAM.EAM_WORK_ORDER_ROUTE is referenced by following:
Description: | This table stores all the EAM workorders.This is used in Intermedia search for workorders |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_WORK_ORDER_TEXT_U1 | UNIQUE | APPS_TS_TX_IDX |
WIP_ENTITY_ID
ORGANIZATION_ID |
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 |
EAM.EAM_WORK_ORDER_TEXT does not reference any database object
EAM.EAM_WORK_ORDER_TEXT is referenced by following:
Description: | Eam Work Order Relationships |
---|
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.
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 |
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 |
EAM.EAM_WO_RELATIONSHIPS does not reference any database object
EAM.EAM_WO_RELATIONSHIPS is referenced by following:
Description: | Work Order Service Request Association |
---|
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.
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 |
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 |
EAM.EAM_WO_SERVICE_ASSOCIATION does not reference any database object
EAM.EAM_WO_SERVICE_ASSOCIATION is referenced by following:
Description: | Table for storing user defined statuses |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
EAM_WO_STATUSES_B_U1 | UNIQUE | APPS_TS_TX_IDX | STATUS_ID |
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 |
EAM.EAM_WO_STATUSES_B does not reference any database object
EAM.EAM_WO_STATUSES_B is referenced by following:
Description: | This table contains translation information for Work Order Statuses. |
---|
Foreign Key Column | Foreign Table |
---|---|
EAM_WO_STATUSES_TL.STATUS_ID | % |
This table contains translation information for Work Order Statuses.
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 |
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 |
EAM.EAM_WO_STATUSES_TL does not reference any database object
EAM.EAM_WO_STATUSES_TL is referenced by following:
Description: | Table for storing workflow item type and keys corresponding to a work order |
---|
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.
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 |
EAM.EAM_WO_WORKFLOWS does not reference any database object
EAM.EAM_WO_WORKFLOWS is referenced by following:
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.
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 |
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.
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 |
APPS.EAM_BILL_BY_ACTIVITIES_V is not referenced by any database object
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.
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 |
APPS.EAM_BILL_BY_REQUIREMENTS_V is not referenced by any database object
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.
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) |
APPS.EAM_DIRECT_ITEMS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View for getting the resource instances- both person and equipment
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 |
APPS.EAM_INSTANCES is not referenced by any database object
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.
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 |
APPS.EAM_MATERIALS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
APPS.EAM_METER_READINGS_INTERFACE_V is not referenced by any database object
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.
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 |
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
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 |
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.
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 |
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.
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 |
APPS.EAM_OUTSTANDING_WORK_ORDERS_V is not referenced by any database object
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.
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 |
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.
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 |
APPS.EAM_PM_LAST_SERVICE_V is not referenced by any database object
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.
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 |
APPS.EAM_PM_SCHEDULINGS_V is not referenced by any database object
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
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 |
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.
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 |
APPS.EAM_REBUILD_COMPLETION_JOBS_V is not referenced by any database object
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.
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 |
APPS.EAM_RESOURCES_V is not referenced by any database object
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.
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 |
APPS.EAM_RUNTIME_INTERVAL_V is not referenced by any database object
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.
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 |
APPS.EAM_SERVICE_REQUEST_DETAILS_V is not referenced by any database object
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.
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 |
APPS.EAM_SUPPRESSION_RELATIONS_V is not referenced by any database object
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.
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 |
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.
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 |
APPS.EAM_WORK_ORDER_BILL_DETAILS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |