Search Results gmp_eam_equip_resources_v




Overview
Explore in AI Chat

Overview

GMP_EAM_EQUIP_RESOURCES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, validated for release 12.1.1 and 12.2.2. It belongs to the GMP product family — Process Manufacturing Process Planning — and exposes equipment resource assignments that bridge Enterprise Asset Management (EAM) equipment instances with Oracle Process Manufacturing (OPM) resource definitions. Because OPM planning and scheduling engines operate against resources, departments, and capacity data rather than against raw equipment records, this view provides the denormalized, planning-ready projection required by capacity planning, resource utilization, and integration interfaces.

The view is read-only; no DML is permitted. Its role in reporting and integration is to present a single consolidated row per active, non-deleted resource detail record associated with an OPM-enabled organization, combining resource master attributes (name, description), resource detail attributes (quantity, group, unit of measure, autocharge type), and equipment instance attributes (serial numbers, instance IDs). This makes it a primary source for tools that must reconcile shop-floor equipment with the schedulable resource entities in OPM.

Underlying Base Objects

The view text defines a five-way join across the following documented base objects (all exposed to APPS as synonyms):

The join is constrained by CRD.DELETE_MARK = 0, CRD.INACTIVE_IND = 0, and MP.PROCESS_ENABLED_FLAG = 'Y', ensuring that only active resources attached to process-enabled organizations are returned. The SELECT DISTINCT clause guards against duplication introduced by the equipment-to-instance relationship.

Key Columns

Common Use Cases and Queries

Typical usage includes CTP eligibility reporting, capacity-versus-assignment audits, and EAM-to-OPM equipment reconciliation.

SELECT organization_code, resource_code, serial_number, ctp_flag
FROM   apps.gmp_eam_equip_resources_v
WHERE  ctp_flag = 'Y'
ORDER BY organization_code, resource_code;

An equipment reconciliation query:

SELECT resource_code, equipment_item_id, instance_id, assigned_qty
FROM   apps.gmp_eam_equip_resources_v
WHERE  organization_id = :org_id;

Because the view is not indexed directly, filtering by ORGANIZATION_ID or RESOURCE_ID leverages the underlying base-table indexes and is recommended for performance in high-volume planning extracts.