Search Results rev_control_flag




Overview
Explore in AI Chat

Overview

QA_ERES_SPECS_V is an APPS-owned, VALID database view in the Oracle E-Business Suite Quality (QA) module. It is described in the ETRM metadata as a "specification view for electronic records," which identifies its primary purpose: presenting specification data from the QA_SPECS entity in a flattened, denormalized form suitable for electronic records (ERES) processing and reporting. The view is available in both EBS 12.1.1 and 12.2.2, and because it resides in the APPS schema it is directly accessible to reporting tools, concurrent programs, and custom integrations that operate against the APPS schema.

The view consolidates specification header information with decoded reference data — organization, category set, item, vendor, customer, and spec element details — so that consumers do not need to perform their own joins to lookup tables. Several columns are resolved through calls to the QA_ERES_PKG package, indicating that the view is specifically oriented toward the electronic records and electronic signatures framework within Quality Management rather than general-purpose inventory reporting.

Underlying Base Objects

The documented base objects for QA_ERES_SPECS_V reflect a broad dependency footprint. The core driving object is QA_SPECS (synonym), which supplies SPEC_ID, SPEC_NAME, effective dates, assignment type, category, item, vendor, customer, character, and specification status columns. Supporting reference objects include:

Because much of the reference data is joined inside the view definition, query performance depends heavily on the underlying indexes on QA_SPECS and the item master tables.

Key Columns

The view exposes the primary key column SPEC_ID along with standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN). Descriptive and organizational columns include SPEC_NAME, ORGANIZATION_ID, ORGANIZATION_CODE, organization NAME, EFFECTIVE_FROM, and EFFECTIVE_TO. Common-spec relationships are tracked through COMMON_SPEC_ID and COMMON_SPEC_NAME, where a DECODE returns NULL when the spec is its own common spec.

Assignment and category columns include ASSIGNMENT_TYPE and its meaning, CATEGORY_SET_ID, CATEGORY_SET_NAME, CATEGORY_SET_DESCRIPTION, STRUCTURE_ID, CATEGORY_ID, CATEGORY_NAME, and CATEGORY_DESCRIPTION (exposed under the misspelled alias CATEGORY_DESCRIPTIION). Item-related columns include ITEM_ID, ITEM (concatenated segments), ITEM_DESCRIPTION, and ITEM_REVISION. Notably, the column most relevant to revision control searches is REV_CONTROL_FLAG, which is sourced from MTL_SYSTEM_ITEMS_B.REVISION_QTY_CONTROL_CODE via the alias I. This flag indicates whether revision quantity control is enabled for the associated item, which is central to determining whether revision-level specification tracking is enforced.

Additional columns cover VENDOR_ID, VENDOR_NUMBER, VENDOR_NAME, CUSTOMER_ID, CUSTOMER_NUMBER, CUSTOMER_NAME, CHAR_ID, SPEC_ELEMENT, SPEC_ELEMENT_VALUE, SPEC_STATUS and its meaning, plus fifteen descriptive flexfield columns (ATTRIBUTE_CATEGORY through ATTRIBUTE15).

Common Use Cases and Queries

Typical uses include ERES audit reporting, specification master extraction, and cross-referencing specifications to items with revision control enabled. A representative query filtering on the revision control flag is:

  • SELECT spec_id, spec_name, item, item_revision, rev_control_flag, spec_status FROM qa_eres_specs_v WHERE rev_control_flag IS NOT NULL;
  • SELECT spec_id, spec_name, organization_code, assignment_type_meaning, effective_from, effective_to FROM qa_eres_specs_v WHERE organization_id = :org_id;
  • SELECT spec_name, category_set_name, category_name, item, vendor_name, customer_name FROM qa_eres_specs_v WHERE spec_id = :spec_id;

These queries support quality audits, specification reconciliation, and integration extracts feeding downstream electronic records systems.