Results for “qa_eres_spec_status”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.QA_SPEC_CHARS_VAL_V is an Oracle EBS Quality Management (QA) view that presents the characteristic-level specification values defined against QA specification headers. It consolidates rows from QA_SPEC_CHARS (the specification-to-characteristic assignment and limit values) together with descriptive detail from QA_CHARS (characteristic definition) and header information from QA_SPECS (specification name, effective dates, and status). The view additionally joins MFG_LOOKUPS twice to resolve lookup meanings for the enabled flag and specification status.
Its role in reporting and integration is to provide a flattened, denormalised projection of specification limits and characteristic attributes suitable for concurrent programs, XML/BI Publisher reports, OBIEE/OTBI extracts, and inbound/outbound interfaces that need to evaluate whether a characteristic value falls within defined limits. Because it resolves the QA_ERES_SPEC_STATUS lookup meaning inline, the view is a common access point for electronic records and electronic signatures (ERES) reporting, where the current status of a specification must be rendered as a user-facing meaning rather than a raw code. The _VAL suffix indicates that the view is scoped to characteristic validation values rather than the full specification definition.
Underlying Base Objects
The view is owned by APPS and is defined over the following documented objects:
- QA_SPEC_CHARS (SYNONYM) — the driving table, providing per-characteristic limit values, UOM, enabled flag, and the DFF attribute columns.
- QA_SPECS (SYNONYM) — the specification header, supplying SPEC_ID, SPEC_NAME, effective dates, and SPEC_STATUS.
- QA_CHARS (SYNONYM) — the characteristic master, supplying name, datatype, decimal precision, and default UOM.
- MFG_LOOKUPS (VIEW) — joined twice: ML2 resolves the SYS_YES_NO meaning for the enabled flag; ML3 resolves the QA_ERES_SPEC_STATUS meaning for the specification status.
Joins are performed on CHAR_ID, SPEC_ID (matched to QS.COMMON_SPEC_ID), and lookup code. The lookup joins use outer-join syntax (ML3 is outer-joined via the (+) operator), so rows survive when no QA_ERES_SPEC_STATUS lookup value exists. The enabled flag is filtered so that only rows with NVL(QSC.ENABLED_FLAG,-1)=1 are returned; ML2 is joined through a DECODE that maps 1 to 1 and any other value to 2.
Key Columns
- ROW_ID, SPEC_ID, CHAR_ID — unique row identifier and the specification/characteristic keys.
- TARGET_VALUE, UPPER_SPEC_LIMIT, LOWER_SPEC_LIMIT — the nominal target and specification limits.
- UPPER_REASONABLE_LIMIT, LOWER_REASONABLE_LIMIT, UPPER_USER_DEFINED_LIMIT, LOWER_USER_DEFINED_LIMIT — secondary tolerance bands.
- SPEC_NAME, CHAR_NAME — human-readable specification and characteristic names.
- UOM_CODE — resolved via NVL from the specification characteristic, falling back to the characteristic default.
- EFFECTIVE_FROM, EFFECTIVE_TO — the specification validity window.
- DATATYPE, DECIMAL_PRECISION — characteristic data type and precision for formatting.
- SPEC_CHAR_ENABLED, SPEC_CHAR_ENABLED_MEANING — enabled flag and its SYS_YES_NO meaning.
- SPEC_STATUS, MEANING — the raw status code and the QA_ERES_SPEC_STATUS lookup meaning.
- ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Who columns.
Common Use Cases and Queries
Typical scenarios include listing all enabled characteristics for a specification together with their limits and status meaning, and validating results against limits in integration routines.
SELECT spec_name, char_name, target_value,
lower_spec_limit, upper_spec_limit, uom_code,
spec_status, meaning
FROM apps.qa_spec_chars_val_v
WHERE spec_id = :p_spec_id
ORDER BY char_name;
To report specification status using the QA_ERES_SPEC_STATUS lookup — the term most users search on — filter or display the MEANING column, which carries the decoded status:
SELECT spec_name, spec_status, meaning
FROM apps.qa_spec_chars_val_v
WHERE spec_status IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN effective_from AND NVL(effective_to, SYSDATE);
Other uses include generating limit-compliance extracts for LIMS interfaces, producing effective-date-driven specification reports, and querying DFF attribute values for custom characteristic classification.
-
Quality Specification Status
-
Quality Specification Status
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
VIEW: APPS.QA_SPEC_CHARS_V 12.1.1
-
VIEW: APPS.QA_SPEC_CHARS_V 12.2.2
-
VIEW: APPS.QA_SPECS_V 12.1.1
-
View: QA_SPEC_CHARS_V 12.2.2
Shows specification and collection elements
APPS.QA_SPEC_CHARS_V·↳ MFG_LOOKUPS·↳ QA_CHARS·↳ QA_SPECS·Explore QA module →
-
VIEW: APPS.QA_SPECS_VAL_V 12.1.1
-
VIEW: APPS.QA_SPECS_VAL_V 12.2.2
-
View: QA_SPEC_CHARS_V 12.1.1
Shows specification and collection elements
APPS.QA_SPEC_CHARS_V·↳ MFG_LOOKUPS·↳ QA_CHARS·↳ QA_SPECS·Explore QA module →
-
View: QA_SPEC_CHARS_VAL_V 12.2.2
Shows specification and collection elements
APPS.QA_SPEC_CHARS_VAL_V·↳ MFG_LOOKUPS·↳ QA_CHARS·↳ QA_SPECS·Explore QA module →
-
View: QA_SPEC_CHARS_VAL_V 12.1.1
Shows specification and collection elements
APPS.QA_SPEC_CHARS_VAL_V·↳ MFG_LOOKUPS·↳ QA_CHARS·↳ QA_SPECS·Explore QA module →
-
VIEW: APPS.QA_SPECS_V 12.2.2
-
VIEW: APPS.QA_ERES_SPECS_V 12.1.1
-
VIEW: APPS.QA_ERES_SPECS_V 12.2.2
-
View: QA_SPECS_VAL_V 12.2.2
Shows valid specifications
APPS.QA_SPECS_VAL_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore QA module →
-
View: QA_SPECS_VAL_V 12.1.1
Shows valid specifications
APPS.QA_SPECS_VAL_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore QA module →
-
View: QA_SPECS_V 12.1.1
Shows all specifications
APPS.QA_SPECS_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore QA module →
-
View: QA_ERES_SPECS_V 12.1.1
specification view for electronic records
APPS.QA_ERES_SPECS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MFG_LOOKUPS·↳ MTL_CATEGORY_SETS_B·Explore QA module →
-
View: QA_ERES_SPECS_V 12.2.2
specification view for electronic records
APPS.QA_ERES_SPECS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MFG_LOOKUPS·↳ MTL_CATEGORY_SETS_B·Explore QA module →
-
View: QA_SPECS_V 12.2.2
Shows all specifications
APPS.QA_SPECS_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore QA module →