Search Results resource_count

Overview

FM_OPRN_DTL_VW1 is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the GMD (Process Manufacturing Product Development) product family. The object carries a status of VALID and is documented in ETRM as "Operation detail view." Its purpose is to present a consolidated, denormalized projection of routing operation definitions, combining operation-level header attributes with the resource-level detail that is assigned to each operation line. This consolidation is significant because the underlying normalized model separates operation activities from operation resources, and consumers — including Oracle Forms inquiry windows, concurrent program extracts, and third-party integrations — require a single relational surface that returns both in one pass.

The view is version-portable across 12.1.1 and 12.2.2. Because it is a view rather than a table, no physical storage or index maintenance is required, and any change to the base tables is immediately reflected. This makes it a stable integration endpoint for reporting against process manufacturing routings without depending on internal table layout.

Underlying Base Objects

ETRM documents two referenced base objects, both resolved through synonyms in the APPS schema:

• GMD_OPERATION_ACTIVITIES (OA) — supplies operation header attributes such as OPRN_ID, ACTIVITY, TEXT_CODE, audit columns, and the ATTRIBUTE1 through ATTRIBUTE30 flexfield columns plus ATTRIBUTE_CATEGORY.
• GMD_OPERATION_RESOURCES (GOR) — supplies the resource-level detail, including RESOURCES, PROCESS_QTY, PRIM_RSRC_IND, SCALE_TYPE, COST_ANALYSIS_CODE, COST_CMPNTCLS_ID, RESOURCE_COUNT, RESOURCE_USAGE, USAGE_UM, OFFSET_INTERVAL, and OPRN_LINE_ID.

The join is an outer join expressed as OA.OPRN_LINE_ID(+) = GOR.OPRN_LINE_ID. The preserved side is GMD_OPERATION_RESOURCES (GOR), meaning that every operation resource row is returned, and operation activity attributes are appended when a matching operation line exists. Resource lines without a corresponding activity record therefore still appear in the result set, with the OA-derived columns null.

Key Columns

• OPRN_ID — identifier of the operation header; the primary means of grouping resources under a routing operation.
• ACTIVITY — the activity or operation step name from the operation activity record.
• OPRN_LINE_ID — the join key linking an operation activity to its resource assignments; it is the pivotal column in the outer-join predicate.
• PRIM_RSRC_IND — the primary resource indicator. This is the column most frequently searched by users, since it flags which resource on an operation line is designated primary, driving scheduling, capacity, and cost rollup behavior.
• RESOURCES, RESOURCE_COUNT, RESOURCE_USAGE, USAGE_UM — the resource identifier and its quantity/usage characteristics, including the unit of measure.
• PROCESS_QTY, SCALE_TYPE — the process quantity basis and the scaling method applied when the resource usage is scaled.
• COST_ANALYSIS_CODE, COST_CMPNTCLS_ID — cost analysis classification and cost component class used for cost rollup.
• OFFSET_INTERVAL — the timing offset applied to the resource relative to the operation.
• TEXT_CODE and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — standard EBS audit trail.
• ATTRIBUTE1–ATTRIBUTE30, ATTRIBUTE_CATEGORY — descriptive flexfield columns inherited from GMD_OPERATION_ACTIVITIES.
• DEP_OPRN_LINE_ID and POC_CTL_CLASS — listed in the documented column inventory but projected as literal NULL in the view text, retained for structural compatibility.

Common Use Cases and Queries

Typical uses include identifying the primary resource on each operation, reporting resource usage and cost component assignment, and driving custom extracts or interfaces that require operation and resource data together. A representative query to isolate primary resources is:

SELECT oprn_id, activity, resources, resource_count, resource_usage, usage_um
FROM apps.fm_oprn_dtl_vw1
WHERE prim_rsrc_ind = 'Y';

To review all resources attached to a given operation, filter by OPRN_ID and order by OPRN_LINE_ID. To produce a cost-oriented extract, select COST_ANALYSIS_CODE and COST_CMPNTCLS_ID alongside the resource and usage columns. Because the view preserves GMD_OPERATION_RESOURCES rows, queries should not assume ACTIVITY is always populated; a null ACTIVITY indicates an operation resource line with no matching activity record.