Results for “upper_user_defined_limit”

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

Overview

QAFV_QUALSPCELM is a read-only reporting view in the APPS schema belonging to the Oracle Quality (QA) product family. It presents the specification limits defined for each collection element (characteristic) attached to a quality specification. In Oracle Quality, a specification is a named set of collection elements — such as length, temperature, or hardness — together with the target value and the acceptable tolerance boundaries for each. QAFV_QUALSPCELM exposes those boundaries in a single denormalized row per specification–element pair, resolving the internal identifiers of the specification and the collection element into their user-facing names.

The view is defined with the WITH READ ONLY clause, which reinforces that it is intended strictly for query, reporting, and integration purposes and cannot be used as the target of DML. It is described in the EBS Technical Reference Manual as "Retrofitted," indicating it was converted from an earlier 11i-era construct and remains valid in both 12.1.1 and 12.2.2. Because the underlying data lives in the specification setup tables, the view reflects whatever limits have been configured on the specification, making it a convenient single source for limit data used in quality results validation, integration with external systems, and ad hoc analysis.

Underlying Base Objects

The view is built from four documented base objects:

• QA_SPEC_CHARS — the specification element table, aliased QUALITY_SPECIFICATION_ELEMENT. This is the driving table holding the target value, the reasonable/ specification/user-defined upper and lower limits, and the enabled flag.
• QA_SPECS — the specification header table, aliased QUALITY_SPECIFICATION, joined on SPEC_ID to obtain the specification name.
• QA_CHARS — the collection element (characteristic) table, aliased COLLECTION_ELEMENT, joined on CHAR_ID to obtain the element name.
• MFG_LOOKUPS — a view over the lookup tables, joined on LOOKUP_TYPE = 'SYS_YES_NO' and LOOKUP_CODE = ENABLED_FLAG to translate the enabled flag into its display meaning.

In EBS 12.2.2 the QA tables are referenced through synonyms resolving to the QA base tables. The joins are inner joins on the three key relationships, so only specification elements with both a valid parent specification and a valid collection element are returned.

Key Columns

• SPECIFICATION_ID / SPECIFICATION_NAME — identifier and name of the quality specification.
• COLLECTION_ELEMENT_ID / COLLECTION_ELEMENT_NAME — identifier and name of the characteristic whose limits are described.
• LOWER_REASONABLE_LIMIT — the lower reasonable limit. This is the column most commonly retrieved by the search term "lower_reasonable_limit"; it represents the outer boundary below which a measured result is considered unreasonable for the element.
• LOWER_SPECIFICATION_LIMIT — the lower specification limit (aliased from LOWER_SPEC_LIMIT), the formal tolerance boundary.
• LOWER_USER_DEFINED_LIMIT — an additional lower limit supplied by the user.
• UPPER_REASONABLE_LIMIT, UPPER_SPECIFICATION_LIMIT, UPPER_USER_DEFINED_LIMIT — the corresponding upper boundaries.
• TARGET_VALUE — the nominal value against which results are assessed.
• ENABLED_FLAG — the decoded SYS_YES_NO meaning indicating whether the element is active on the specification.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include verifying configured limits before collecting quality results, exporting specification limits to laboratory or shop-floor systems, and reconciling reasonable limits against specification limits in audits. A representative query for the searched term is:

SELECT SPECIFICATION_NAME, COLLECTION_ELEMENT_NAME, LOWER_REASONABLE_LIMIT, UPPER_REASONABLE_LIMIT, TARGET_VALUE FROM APPS.QAFV_QUALSPCELM WHERE ENABLED_FLAG = 'Yes' ORDER BY SPECIFICATION_NAME, COLLECTION_ELEMENT_NAME;

To inspect all boundaries for a single specification:

SELECT COLLECTION_ELEMENT_NAME, LOWER_REASONABLE_LIMIT, LOWER_SPECIFICATION_LIMIT, TARGET_VALUE, UPPER_SPECIFICATION_LIMIT, UPPER_REASONABLE_LIMIT FROM APPS.QAFV_QUALSPCELM WHERE SPECIFICATION_ID = :p_spec_id;

Because the view is read-only and joins only setup tables, it performs efficiently for reporting and can be safely embedded in custom concurrent programs, BI Publisher data templates, and interface extracts.