Search Results poc_ctl_class




Overview
Explore in AI Chat

Overview

FM_OPRN_MST_VW1 is a public APPS-owned view that presents operation master data for the Oracle E-Business Suite Process Manufacturing (GMD) product family, specifically the Process Manufacturing Product Development module. In EBS 12.1.1 and 12.2.2 the view is documented as VALID and serves as a simplified, filtered read interface over the operation definition table used by formula, recipe, and routing functionality. Its stated description is "Operation master view."

Because the operation master is central to process manufacturing — every routing step, formula operation, and resource assignment references an operation — this view provides a stable projection of that master data for reporting, integration, and inquiry. The user search term "oprn_desc" maps directly to the OPRN_DESC column, which is the human-readable operation description exposed by the view. Rather than querying the underlying transaction table directly, developers and report authors use FM_OPRN_MST_VW1 so that only active, non-deleted operation records are surfaced, with a consistent column contract across releases.

Underlying Base Objects

The view is defined over a single documented base object, GMD_OPERATIONS, accessed through a SYNONYM in the APPS schema. The view text is a straightforward SELECT with an explicit column list rather than a SELECT *, which protects consumers from column-order changes in the base table.

A critical aspect of the view is its row filter: it restricts results to records where OPERATION_STATUS is 700 or 900. These status codes correspond to enabled/active operation states, so the view effectively hides operations that are pending approval, obsolete, or otherwise not usable in production. The view also inherits the standard EBS WHO columns from GMD_OPERATIONS, including CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, along with the DELETE_MARK and INACTIVE_IND flags and the full ATTRIBUTE1 through ATTRIBUTE30 descriptive flexfield columns.

Key Columns

The view exposes the primary key OPRN_ID along with the business identifiers OPRN_NO and OPRN_VERS. Notably, the second projected column concatenates OPRN_NO and OPRN_VERS with a hyphen, producing a composite operation identifier, while the individual OPRN_NO and OPRN_VERS columns are also exposed separately.

  • OPRN_ID — surrogate primary key for the operation; used as the foreign key from routing and formula step tables.
  • OPRN_DESC — the operation description, the attribute most commonly searched and displayed in reports.
  • OPRN_VERS — the operation version, supporting version-controlled operation masters.
  • PROCESS_QTY_UM — the unit of measure associated with the process quantity for the operation.
  • OPRN_CLASS — the operation class used to categorize operations.
  • POC_CTL_CLASS and IN_USE — columns projected as NULL in the view text, retained for interface compatibility with consumers expecting the full operation structure.
  • INACTIVE_IND, DELETE_MARK, TEXT_CODE — standard EBS status and audit control columns.

Common Use Cases and Queries

Typical usage includes operation master LOVs, routing and recipe reports, and inbound/outbound integration extracts. A minimal query retrieving operation descriptions is:

SELECT oprn_id, oprn_no, oprn_vers, oprn_desc, process_qty_um, oprn_class FROM apps.fm_oprn_mst_vw1 WHERE inactive_ind = 'N';

A search driven by the term "oprn_desc" would typically take the form:

SELECT oprn_id, oprn_no || '-' || oprn_vers AS operation, oprn_desc FROM apps.fm_oprn_mst_vw1 WHERE UPPER(oprn_desc) LIKE UPPER('%:search_term%');

Because the view already applies the OPERATION_STATUS filter, callers do not need to re-apply it, though they should generally add INACTIVE_IND = 'N' and DELETE_MARK IS NULL or 0 to exclude logically disabled rows. Joining the view to routing step tables on OPRN_ID is the standard technique for producing operation-level routing reports.