Search Results scale_type_disp

Overview

APPS.PMITS_OPERATION_RESOURCES_V is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Process Manufacturing (OPM/Process Manufacturing) module. It presents operation resource information — the resources assigned to routing operations, together with their usage, capacity, cost, and scaling attributes — in a denormalized, reporting-friendly format. In Oracle EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and registered under FND Design Data as PMI.PMITS_OPERATION_RESOURCES_V with a status of VALID. Because it is a BIS view, its purpose is to support operational reporting, analytics, and downstream integrations that need to consume process manufacturing resource data without navigating the underlying transactional tables directly. The view is not a transactional object; no DML should be issued against it.

Underlying Base Objects

The documented view metadata for 12.2.2 lists a single referenced base object: DUAL (SYNONYM). This indicates the view definition is constructed largely through expressions, constants, or inline constructs rather than a straightforward join across multiple documented process manufacturing tables. In practice, PMITS_OPERATION_RESOURCES_V sits in front of OPM operation-resource domain data (routing operations and their resources) and exposes it through the PMITS (Process Manufacturing Intelligence) naming convention. The RESOURCES column is the resource identifier, and OPRN_LINE_ID anchors each row to an operation line. The DUAL reference confirms the view is not defined as a simple select over a single large table; the underlying logic is encapsulated by Oracle and the columns below are the stable, documented interface.

Key Columns

• RESOURCES / RESOURCE_DESC / RESOURCE_CLASS — Resource identifier, description, and classification.
• OPRN_LINE_ID — Operation line identifier linking the resource to a routing operation.
• RSRC_UOM, PROCESS_QTY, PROCESS_UOM — Resource unit of measure and the process quantity/UOM the resource usage is expressed against.
• RESOURCE_USAGE / USAGE_UM / RESOURCE_COUNT — Amount of resource consumed, its UOM, and the number of resources required.
• PRIM_RSRC_IND / PRIM_RSRC_IND_DISP — Numeric flag and its display form indicating whether the resource is the primary resource on the operation.
• SCALE_TYPE / SCALE_TYPE_DISP — The numeric scale type code and its user-facing display value; this is the column the user searched for ("scale_type_disp"). SCALE_TYPE_DISP translates the internal SCALE_TYPE code into a readable label describing how resource usage scales with batch or process quantity.
• COST_CMPNTCLS_ID / COST_CMPNTCLS_CODE / COST_CMPNTCLS_DESC — Cost component class identifiers and descriptions used for costing rollups.
• COST_ANALYSIS_CODE / COST_ANALYSIS_DESC — Cost analysis classification.
• OFFSET_INTERVAL, MIN_CAPACITY, MAX_CAPACITY, CAPACITY_UOM — Scheduling offset and capacity constraints.
• PROCESS_PARAMETER_1 … PROCESS_PARAMETER_5 — Flexfield-style process parameters.
• DELETE_MARK, TEXT_CODE — Standard OPM soft-delete flag and text reference.

Common Use Cases and Queries

Typical scenarios include routing cost analysis, capacity planning, and resource utilization reporting. The SCALE_TYPE_DISP column is commonly selected to present scale type in business terms rather than as a numeric code. A representative query:

SELECT resources,
       resource_desc,
       oprn_line_id,
       resource_usage,
       usage_um,
       scale_type_disp,
       prim_rsrc_ind_disp,
       min_capacity,
       max_capacity
FROM   apps.pmits_operation_resources_v
WHERE  delete_mark = 0
ORDER  BY resources;

A filtered variant for primary resources on a given routing operation:

SELECT oprn_line_id,
       resources,
       resource_count,
       scale_type_disp,
       cost_cmpntcls_code
FROM   apps.pmits_operation_resources_v
WHERE  prim_rsrc_ind = 1
AND    delete_mark = 0;

All queries should qualify the APPS schema, apply the DELETE_MARK = 0 predicate to exclude soft-deleted rows, and treat the view as read-only.