EAM Views (58)

EAM - Enterprise Asset Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
EAM_ASSET_METERS_V	This view gives all the information about a meter associated with an asset.
EAM_BILL_BY_ACTIVITIES_V	A view used to simplify forms coding. Used for getting information for the bill by activities block.
EAM_BILL_BY_REQUIREMENTS_V	A view used to simplify forms coding. Used to display the bill by requirements block for the work order billing form.
EAM_CAPT_BILL_BY_REQ_V	This view will be used to display the materials, direct items and resources of a work order. It is essentially a union of eam_bill_by_requir
EAM_CFR_COUNTER_READINGS_V	Work Order Completion Counter readings
EAM_CFR_ISSUED_SERIALS_V	Work Order Completion Issued Serials
EAM_CFR_MATERIALS_V	This view displays information on materials for work orders.
EAM_CFR_OPERATIONS_V	This view displays information on operations for work orders.
EAM_CFR_QA_PLANS_V	This view displays information on QA Plans for work orders.This view is used for ERES at the time of Work Order Completion in the XGM
EAM_CFR_RESOURCES_V	This view displays information on resources for work orders.This view is used for ERES at the time of Work Order Completion in the XGM
EAM_CFR_WORK_COMPLETION_V	This view displays the details of all maintenance work orders completed or uncompleted .This view is used for ERES at the time of work order
EAM_CFR_WORK_ORDER_V	This view displays details of all maintenance work orders.This view is used for ERES at the time of work order completion in the XGM.
EAM_CHECKED_OUT_ASSETS_V	This view provides information of all Checked Out Assets which is used by Oracle Service Management/Depot Repair product.
EAM_CONTROL_EVENT_V	This view provides information of System Events for which Asset Operation Log is required with an Organization Context.
EAM_COUNTERS_V	This View gives all active Meter/Meter Templates. Basically the view refers to counters tables for the information. TMPL_FLAG is Y for Meter
EAM_DIRECT_ITEMS_RECS_LITE_V	This is a light weight version og EAM_DIRECT_ITEMS_RECS_V
EAM_DIRECT_ITEMS_V	View shows the details of direct items from cst_eam_wo_estimate_details table.
EAM_DIRECT_ITEM_RECS_V	View to select both the description based direct items as well as non-stockable inventory items
EAM_FAILUREINFO_V	This view gives details of Failures Information as reported against a Work Order.
EAM_FAILURE_CODES_V	This view provides all Failure/Cause/Resolution Codes with their Code Types.
EAM_FAILURE_COMBINATIONS_V	This view displays all Failure/Cause/Resolution Code Combinations along with their description.
EAM_FAILURE_SET_ASSOCIATIONS_V	This view queries all active Failure Set - Item associations.
EAM_FORECAST_WORK_ORDER_V	This view resolves all foreign keys for forecasted work orders used in eAM maintenance budgeting and forecasting.
EAM_INSTANCES	View for getting the resource instances- both person and equipment
EAM_ISOLATION_STATUSES_VL	View based on EAM_SAFETY_USR_DEF_STATUSES_B for displaying user defined isolation statuses and their mapping with corresponding isolation sy
EAM_MANAGE_REQS_V	It brings all the work requests and all the service requests in open status
EAM_MATERIALS_V	View shows the details of materials for a work order
EAM_METER_READINGS_INTERFACE_V	View used to get meter and meter reading interface details.
EAM_METER_READINGS_V	View gives details about meter and meter readings.
EAM_NEXT_OPERATIONS_V	View provides a list of Next operations for a specific operation in a work order depends upon the Dependency Definition defined in WIP_OPERA
EAM_OPERATIONS_DETAILS_V	View provides details about the operations of a work order
EAM_OP_COMPLETION_TXNS_V	This view shows the details of all the completed operations of a work order.The view has been derived from the eam_op_completion_txns table.
EAM_OUTSTANDING_WORK_ORDERS_V	View shows work orders forecasted by Preventive Maintenance scheduling.
EAM_PERMIT_STATUSES_VL	View based on EAM_SAFETY_USR_DEF_STATUSES_B for displaying user defined permit statuses and their mapping with corresponding permit system s
EAM_PM_ACTIVITYGROUP_V	This view will display details of Preventive Maintenance Schedule Activities
EAM_PM_ASSET_ACTIVITY_V	View for meters that can be used in PM
EAM_PM_LAST_SERVICE_V	Last service information view
EAM_PM_SCHEDULINGS_V	View is used to access individual Preventive Maintenance schedule.
EAM_PRIOR_OPERATIONS_V	View provides a list of prior operations for a specific operation in a work order.
EAM_REBUILD_COMPLETION_JOBS_V	Rebuild Work Order Completion View
EAM_REQUIREMENT_OPERATIONS_V	View on top of wip_requirement_operations. It has the extra columns needed for the support of one-off items.
EAM_RESOURCES_V	View shows all the resources for a work order based on table cst_eam_wo_estimate_details
EAM_RUNTIME_INTERVAL_V	View used to get runtime rule information and meter details.
EAM_SAF_WO_CONCAT_STATUSES_VL	This view unions the Permit statuses, work clearance statuses, isolation statuses and Work Order statuses
EAM_SERVICE_REQUEST_DETAILS_V	View for service request details
EAM_SUPPRESSION_RELATIONS_V	This view shows suppression relationships between a parent activity on an asset and the child activities suppressed by it.
EAM_WORKORDER_DOWNTIME_V	Downtime view by work order/operation
EAM_WORK_ASSET_ROUTE_V	The view shows the work order route infromation
EAM_WORK_CLEARANCE_STATUSES_VL	View based on EAM_SAFETY_USR_DEF_STATUSES_B for displaying user defined work clearance statuses and their mapping with corresponding work cl
EAM_WORK_ORDERS_V	View shows all maintenance work orders along with the work requests/service requests associated to them.
EAM_WORK_ORDER_BILL_DETAILS_V	An internal view used to simplify forms coding.
EAM_WORK_ORDER_DETAILS_V	View based on the table eam_work_order_details to display user defined statuses based on pending flag and also displays material shortage de
EAM_WORK_ORDER_DIRECT_ITEMS_V	View shows direct item details of a work order.
EAM_WORK_ORDER_REQ_PO_V	View shows purchase order and requisition details of a work order.
EAM_WORK_REQUEST_ASSOC_V	View shows all associated work requests and service requests for a work order.
EAM_WO_DIRECT_ITEMS_LITE_V	This is a light weight version of the view EAM_WORK_ORDER_DIRECT_ITEMS_V.
EAM_WO_REQ_PO_LITE_V	This is a light weight version of EAM_WORK_ORDER_REQ_PO_V.
EAM_WO_STATUSES_VL	View based on eam_wo_statuses for displaying user defined statuses and their mapping with corresponding wip status