Search Results share_capacity_flag

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

• GMP_RESOURCE_EQUIPMENTS — links an OPM resource to the equipment item that fulfills it; supplies EQUIPMENT_ITEM_ID.
• GMP_RESOURCE_INSTANCES — the specific equipment instance records; supplies INSTANCE_ID and EQP_SERIAL_NUMBER. Joined to GMP_RESOURCE_EQUIPMENTS on RESOURCE_ID.
• CR_RSRC_DTL — the resource detail table; supplies RESOURCE_ID, ASSIGNED_QTY, GROUP_RESOURCE, USAGE_UOM, and the filter columns DELETE_MARK, INACTIVE_IND, and ORGANIZATION_ID.
• CR_RSRC_MST — the resource master table; supplies RESOURCES (resource code) and RESOURCE_DESC. Joined on the RESOURCES key against CR_RSRC_DTL.
• MTL_PARAMETERS — the inventory organization parameters table; supplies ORGANIZATION_CODE and PROCESS_ENABLED_FLAG.

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

• ORGANIZATION_ID / ORGANIZATION_CODE — the OPM process organization that owns the resource. Returned twice in the projection.
• RESOURCE_ID / RESOURCE_CODE / DESCRIPTION — the schedulable resource identity.
• EQUIPMENT_ITEM_ID, INSTANCE_ID, SERIAL_NUMBER — the EAM equipment item and specific instance backing the resource.
• ASSIGNED_QTY, CAPACITY_UNITS, UNIT_OF MEASURE — quantity and capacity attributes driving planning calculations.
• AUTOCHARGE_TYPE, CTP_FLAG, SHARE_CAPACITY_FLAG, AVAILABLE_24_HOURS_FLAG, SCHEDULE_TO_INSTANCE — behavioral control flags. CTP_FLAG (capable-to-promise) indicates whether the resource may be used in capable-to-promise availability checks.
• DEPARTMENT_ID / DEPARTMENT_CODE, GROUP_RESOURCE / RESOURCE_GROUP_NAME — department and resource-group classification.

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.