Results for “quality_specification_element”

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

Overview

APPS.QAFV_QUALSPCELM is a read-only Oracle EBS view that exposes the relationship between quality specifications and the collection elements (characteristics) assigned to them. In Oracle Quality, a specification (QA_SPECS) defines the acceptable bounds for one or more measurable characteristics, and each characteristic is drawn from the collection element master (QA_CHARS). This view flattens that many-to-many assignment into a single reporting row per specification–collection element pair, joining the specification header, the specification–characteristic association, the collection element master, and the system Yes/No lookup that interprets the enabled flag.

The view is defined with the WITH READ ONLY clause, confirming it is intended strictly for query, reporting, and integration — not for DML. It is part of the Quality (QA) schema family and is typically consumed through the APPS synonym layer, which makes it accessible to custom reports, concurrent programs, Oracle Discoverer workbooks, OBIEE/BI Publisher data models, and interface programs that need to validate specification limits before loading inspection or results data.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is owned by APPS and references the following objects:

• QA_SPECS (synonym) — the quality specification header, providing SPEC_ID and SPEC_NAME.
• QA_SPEC_CHARS (synonym) — the specification-to-characteristic association, holding the numeric limits, target, enabled flag, and audit columns.
• QA_CHARS (synonym) — the collection element master, supplying CHAR_ID and NAME.
• MFG_LOOKUPS (view) — the shared lookup view, filtered to LOOKUP_TYPE = 'SYS_YES_NO', used to translate the stored enabled code into a readable meaning.

In the view text these objects are aliased as QUALITY_SPECIFICATION (QA_SPECS), QUALITY_SPECIFICATION_ELEMENT (QA_SPEC_CHARS), COLLECTION_ELEMENT (QA_CHARS), and MF (MFG_LOOKUPS). The join conditions are QUALITY_SPECIFICATION_ELEMENT.SPEC_ID = QUALITY_SPECIFICATION.SPEC_ID, QUALITY_SPECIFICATION_ELEMENT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID, and MF.LOOKUP_CODE = QUALITY_SPECIFICATION_ELEMENT.ENABLED_FLAG. Because MFG_LOOKUPS is itself a view over FND_LOOKUP_VALUES-type data, an inner join here means only rows whose enabled flag resolves to a valid Yes/No lookup are returned.

Key Columns

• SPECIFICATION_ID — surrogate key of the owning specification (QA_SPECS.SPEC_ID).
• SPECIFICATION_NAME — user-facing name of the specification.
• COLLECTION_ELEMENT_ID — the characteristic identifier (QA_SPEC_CHARS.CHAR_ID, aliased from QA_CHARS.CHAR_ID).
• COLLECTION_ELEMENT_NAME — descriptive name of the collection element.
• LOWER_REASONABLE_LIMIT / UPPER_REASONABLE_LIMIT — advisory bounds used for flagging results that warrant attention but are not necessarily out of specification.
• LOWER_SPECIFICATION_LIMIT / UPPER_SPECIFICATION_LIMIT — the spec limits that define conformance.
• LOWER_USER_DEFINED_LIMIT / UPPER_USER_DEFINED_LIMIT — optional limits entered manually by the quality engineer.
• TARGET_VALUE — the nominal or ideal reading for the element.
• ENABLED_FLAG — the decoded meaning of the Yes/No lookup for the assignment.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns inherited from QA_SPEC_CHARS.

Common Use Cases and Queries

Typical scenarios include listing all collection elements on a specification, building interval or limit-validation logic before results entry, and feeding downstream statistical process control or inspection reporting. A basic listing follows:

• SELECT specification_name, collection_element_name, lower_specification_limit, upper_specification_limit, target_value, enabled_flag FROM apps.qafv_qualspcelm WHERE specification_name = :spec ORDER BY collection_element_name;
• Filter to active assignments only: add AND enabled_flag = 'Yes'.
• Find every specification using a given characteristic: WHERE collection_element_name = :element.
• Locate elements lacking defined limits for data-quality review: WHERE lower_specification_limit IS NULL OR upper_specification_limit IS NULL.
• Audit traceability: select the four audit columns alongside SPECIFICATION_ID and COLLECTION_ELEMENT_ID for change tracking.

Because the view performs an inner join to MFG_LOOKUPS, assignments whose enabled flag does not resolve in SYS_YES_NO are silently excluded; reports requiring a full inventory should reconcile against QA_SPEC_CHARS directly. The view is identical in its definition across 12.1.1 and 12.2.2, so queries written against it remain portable between the two releases.