Search Results oprn_vers

Overview

The view APPS.PMITS_OPERATION_MASTER_V is a reporting and integration object within Oracle EBS Process Manufacturing Intelligence (product code PMI). It is documented in ETRM as a VALID view owned by the APPS schema with the description "GMD Operation Master View." Its purpose is to present a flattened, security-filtered, and human-readable projection of Process Manufacturing operations master data originating from the GMD (Process Manufacturing) tables. The view joins operation definitions to unit-of-measure and organization masters, resolves foreign-key coded values into descriptive text, and applies row-level security.

For Oracle EBS 12.1.1 and 12.2.2 environments, this object is relevant where Process Manufacturing Intelligence or dependent GMD components are installed. It is important to note that PMI — Process Manufacturing Intelligence — is flagged Obsolete in the ETRM product classification, so the view should be treated as legacy. Nonetheless, in installations where it remains deployed, it functions as a consolidated read-only source for operation attributes, particularly the operation description (OPRN_DESC), which is the term the user searched for ("oprn_desc").

Underlying Base Objects

The view text is defined over the following documented base objects:

• GMD_OPERATIONS_VL (aliased OPV) — the primary source, a translated base view/table holding operation master records, including OPRN_ID, OPRN_NO, OPRN_VERS, and OPRN_DESC.
• SY_UOMS_MST (aliased UM) — unit-of-measure master, joined on PROCESS_QTY_UM = UM.UM_CODE to validate the process quantity UOM.
• SY_ORGN_MST (aliased OGM) — organization master, joined on OWNER_ORGN_CODE = ORGN_CODE to supply the owning organization name.
• FM_OPRN_CLS (aliased OC) — operation class reference table, joined with an outer join (+) on OPRN_CLASS = OPRN_CLASS to resolve OPRN_CLASS_DESC.
• GMD_STATUS (aliased GS) — status reference table, joined on OPERATION_STATUS = STATUS_CODE to resolve the STATUS meaning.
• PMI_SECURITY_PKG.SHOW_RECORD — an APPS security function invoked in the WHERE clause, returning 'TRUE' only for organizations the current user is authorized to see.

The ETRM "referenced base objects" metadata for 12.2.2 documents DUAL (SYNONYM) as the resolved dependency at the documented level; however, the authoritative view text above demonstrates the functional dependency chain through the GMD and SY reference tables. The inclusion of 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(OGM.ORGN_CODE) means every query against this view is dynamically filtered by the operator's organization-level security profile.

Key Columns

• OPRN_ID — surrogate primary key identifying the operation.
• OPRN_NO — the user-visible operation number/code.
• OPRN_VERS — operation version, supporting versioned operation definitions.
• OPRN_DESC — the operation description text; this is the column that resolves the "oprn_desc" search term.
• PROCESS_QTY_UM — unit of measure for the process quantity, validated against SY_UOMS_MST.
• OPRN_CLASS / OPRN_CLASS_DESC — operation class code and its decoded description from FM_OPRN_CLS.
• POC_CTL_CLASS — process operation control class indicator.
• INACTIVE_IND / DELETE_MARK — status flags identifying inactive or logically deleted operations.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-range validity for the operation version.
• OPERATION_STATUS / STATUS — status code and its decoded meaning from GMD_STATUS.
• OWNER_ORGN_CODE / ORGN_NAME — owning organization code and its decoded name.
• TEXT_CODE — reference to associated descriptive text.

Common Use Cases and Queries

Typical scenarios include listing operations by organization, searching operation descriptions, and feeding downstream reports or interfaces. Because security is enforced inside the view, callers need not add organization filters, though adding them improves performance.

Retrieve all active operations with descriptions for the current user's authorized organizations:

• SELECT oprn_no, oprn_vers, oprn_desc, orgn_name, status FROM apps.pmits_operation_master_v WHERE inactive_ind = 'N' AND delete_mark = 0;

Search operations by description text (the "oprn_desc" lookup):

• SELECT oprn_id, oprn_no, oprn_desc FROM apps.pmits_operation_master_v WHERE UPPER(oprn_desc) LIKE '%' || UPPER(:p_desc) || '%';

Report operation classes and their organization for a specific owning organization:

• SELECT orgn_name, oprn_class_desc, COUNT(*) FROM apps.pmits_operation_master_v WHERE effective_end_date IS NULL GROUP BY orgn_name, oprn_class_desc;

Given its Obsolete PMI classification, use of this view should be validated against the target instance and, where possible, migrated to supported GMD operation master sources.