Results for “oprn_id”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

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.