Results for “data_entry_hint”

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

Overview

QAFV_COLLECTION_ELEMENTS is a read-only Oracle E-Business Suite view owned by the APPS schema and registered as VALID within the QA (Quality) product module. It is designated in the ETRM repository as a retrofitted object, indicating that it was re-implemented or reconciled during an upgrade or patch cycle. The view presents a business-friendly projection of collection elements — the individual quality characteristics entered against a collection plan — joined to their decoded lookup meanings, units of measure, and descriptive metadata.

Its principal purpose is to expose coded columns in a human-readable form. Rather than returning raw lookup codes for data type, element type, enabled status, and mandatory status, the view resolves each to its corresponding meaning value from the manufacturing and common lookup tables. This makes the view well suited for ad hoc reporting, discoverability layers, and external integrations that must render quality specifications without re-implementing the QA lookup decoding logic. Because it is defined WITH READ ONLY, the view is strictly a query surface; it cannot be used as a DML target.

Underlying Base Objects

The view is defined over a single driving synonym, QA_CHARS (aliased COLLECTION_ELEMENT), which stores the quality characteristic records. Four lookup or reference objects supply the decoded attributes: MFG_LOOKUPS is joined three times for the QA_CHAR_DATATYPE, SYS_YES_NO, and SYS_YES_NO lookup types (the latter two resolving the enabled and mandatory flags); FND_COMMON_LOOKUPS provides the ELEMENT_TYPE meaning constrained to APPLICATION_ID 250 (Quality); and MTL_UNITS_OF_MEASURE supplies the unit of measure description. FND_GLOBAL is listed among the referenced objects because FND_COMMON_LOOKUPS is itself a view dependent on that package, not because QAFV_COLLECTION_ELEMENTS calls it directly.

The join to MTL_UNITS_OF_MEASURE is an outer join on UOM_CODE, so elements without an assigned unit of measure are still returned. All other joins are inner joins, meaning an element whose lookup codes are not defined in the respective lookup types will be excluded from the result set.

Key Columns

• COLLECTION_ELEMENT_ID — Surfaces QA_CHARS.CHAR_ID, the primary key of the underlying characteristic.
• COLLECTION_ELEMENT_NAME — The characteristic name as defined by the user.
• DATA_ENTRY_HINT — A free-text hint presented to the operator at data entry time, guiding the expected format or value of the result.
• DATA_TYPE / ELEMENT_TYPE — Decoded meanings describing the datatype of the characteristic and whether it is a variable, attribute, or similar element classification.
• DEFAULT_VALUE — The value pre-populated when a result is created.
• LOWER_REASONABLE_LIMIT, LOWER_SPECIFICATION_LIMIT, LOWER_USER_DEFINED_LIMIT — The three-tier lower tolerance thresholds; the specification limit is aliased to LOWER_SPECIFICATION_LIMIT.
• UPPER_REASONABLE_LIMIT, UPPER_SPECIFICATION_LIMIT, UPPER_USER_DEFINED_LIMIT — The corresponding upper thresholds.
• TARGET_VALUE — The nominal value the process is expected to achieve.
• RESULTS_COLUMN_PROMPT — Maps to QA_CHARS.PROMPT, controlling the label shown for the result column.
• ENABLED_FLAG / MANDATORY_FLAG — Yes/No meanings indicating whether the element is active and whether a result is required.
• UNIT_OF_MEASURE — Description of the assigned UOM, null when unassigned.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard audit columns.

Common Use Cases and Queries

The view is typically used to report on specification limits, to verify that entry hints and mandatory flags are consistently configured across collection plans, and to feed downstream systems that require decoded quality characteristic definitions.

A representative query returning enabled variable characteristics with their limits and entry hints:

SELECT collection_element_name, data_entry_hint, data_type, element_type, target_value, lower_specification_limit, upper_specification_limit, unit_of_measure, mandatory_flag FROM qafv_collection_elements WHERE enabled_flag = 'Yes' AND element_type = 'Variable' ORDER BY collection_element_name;

A second common pattern audits the completeness of configuration, flagging elements that lack an entry hint or whose mandatory status is inconsistent:

SELECT collection_element_name, data_entry_hint, mandatory_flag, results_column_prompt FROM qafv_collection_elements WHERE data_entry_hint IS NULL OR results_column_prompt IS NULL ORDER BY last_update_date DESC;