Search Results capacity_uom

Overview

PMITS_OPERATION_RESOURCES_V is a secure, reporting-oriented view owned by the APPS schema in Oracle E-Business Suite. It belongs to the PMI (Process Manufacturing Intelligence) product family and is documented as the GMD Operation Resources View. The view exposes the resource definitions attached to process manufacturing operations, joining operation resource records to resource master data, operation headers, cost component and cost analysis masters, and lookup code descriptions. Its principal role in EBS reporting and integration is to present a denormalized, business-friendly projection of the underlying GMD operation resource tables so that operational, costing, and capacity data can be queried or extracted without repeatedly reconstructing the join logic. A defining characteristic of the view is that it is secured: the WHERE clause applies PMI_SECURITY_PKG.SHOW_RECORD(OV.OWNER_ORGN_CODE), which filters rows according to the organization security profile of the querying user. The view carries a status of VALID in the documented environment.

Underlying Base Objects

The view is defined over several base tables and master tables, combined in a single SELECT with inner joins. The driving table is GMD_OPERATION_RESOURCES (alias ORS), which holds the resource assignments for an operation. It is joined to GMD_OPERATION_ACTIVITIES (alias OA) on OPRN_LINE_ID, and OA is joined to GMD_OPERATIONS_VL (alias OV) on OPRN_ID; the operations view supplies the header-level attributes, including the process quantity unit of measure and OWNER_ORGN_CODE used by the security predicate. Resource master data comes from CR_RSRC_MST (alias RM) via the RESOURCES key. Costing attributes are resolved through CM_CMPT_MST (alias CM) on COST_CMPNTCLS_ID and CM_ALYS_MST (alias AM) on COST_ANALYSIS_CODE. Two references to GEM_LOOKUPS provide display meanings: RSRC_LKP resolves ORS.PRIM_RSRC_IND against lookup type 'GMD_PRIM_RSRC_IND', and SCAL_LKP resolves ORS.SCALE_TYPE against lookup type 'GMD_RESOURCE_SCALE_TYPE'. The documented view metadata additionally records DUAL as a referenced object, consistent with the security function call appearing in the predicate. Because all joins are inner joins, a resource row appears only when its master, operation, cost, and lookup references are all resolvable.

Key Columns

RESOURCES, RESOURCE_DESC, and RESOURCE_CLASS identify the resource and its class. OPRN_LINE_ID links the row to the operation activity line. RSRC_UOM is an alias of ORS.PROCESS_UOM, while PROCESS_QTY carries the resource process quantity and PROCESS_UOM (from OV.PROCESS_QTY_UM) provides its unit of measure. RESOURCE_USAGE and USAGE_UM describe consumption per unit, and RESOURCE_COUNT states how many of the resource are required. PRIM_RSRC_IND holds the primary-resource flag, with PRIM_RSRC_IND_DISP providing the decoded lookup meaning; SCALE_TYPE and SCALE_TYPE_DISP behave identically for resource scaling. Costing columns include COST_CMPNTCLS_ID, COST_CMPNTCLS_CODE, COST_CMPNTCLS_DESC, COST_ANALYSIS_CODE, and COST_ANALYSIS_DESC. OFFSET_INTERVAL, MIN_CAPACITY, MAX_CAPACITY, and CAPACITY_UOM describe scheduling and capacity constraints. DELETE_MARK and TEXT_CODE carry the standard soft-delete and text-translation keys, and PROCESS_PARAMETER_1 through PROCESS_PARAMETER_5 provide the five free-form process parameters.

Common Use Cases and Queries

The most frequent scenario is listing the resources consumed by a given process operation, together with usage, cost class, and capacity constraints. A second common pattern is a costing or capacity review filtered by resource class. The following query returns resources for a specific operation:

• SELECT RESOURCES, RESOURCE_DESC, PROCESS_QTY, PROCESS_UOM, RESOURCE_USAGE, USAGE_UM, RESOURCE_COUNT FROM APPS.PMITS_OPERATION_RESOURCES_V WHERE OPRN_LINE_ID = :p_line_id AND DELETE_MARK = 0;
• SELECT RESOURCES, RESOURCE_CLASS, COST_CMPNTCLS_CODE, COST_ANALYSIS_CODE, MIN_CAPACITY, MAX_CAPACITY, CAPACITY_UOM FROM APPS.PMITS_OPERATION_RESOURCES_V WHERE RESOURCE_CLASS = :p_class AND DELETE_MARK = 0;
• SELECT RESOURCES, PRIM_RSRC_IND_DISP, SCALE_TYPE_DISP, PROCESS_QTY FROM APPS.PMITS_OPERATION_RESOURCES_V WHERE PRIM_RSRC_IND = 'Y';

Because results are restricted by PMI_SECURITY_PKG.SHOW_RECORD, callers should run these queries under a responsibility whose organization security profile includes the owning organizations of the intended operations; otherwise valid rows will be silently excluded. Filtering on DELETE_MARK = 0 is recommended to exclude logically deleted resource assignments.