Results for “qabv_collection_plan_elements”

24 results




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

Overview

The view APPS.QABV_COLLECTION_PLAN_ELEMENTS is a reporting and integration object within the Oracle E-Business Suite QA – Quality module. It exposes the relationship between collection plans and the collection elements (characteristics) associated with them, presenting this data in a denormalized, human-readable form. The view carries a status of VALID in the APPS schema and is documented as "Retrofitted," indicating it was introduced or carried forward to preserve backward compatibility across release levels, including 12.1.1 and 12.2.2.

Rather than requiring consumers to join multiple tables and decode lookup codes manually, the view resolves the enabled and mandatory flags into their descriptive meanings through the SYS_YES_NO lookup type. This makes the object particularly useful for reporting, extracts, and integration interfaces where the technical key values of collection plan elements must be presented alongside their descriptive attributes. Because it is defined WITH READ ONLY, the view supports query access only and cannot be used as a DML target.

Underlying Base Objects

The view is defined over four documented base objects:

The joins are established on PLAN_ID (QA_PLAN_CHARS to QA_PLANS) and CHAR_ID (QA_PLAN_CHARS to QA_CHARS), with the lookup joins constrained by matching lookup type and code.

Key Columns

Common Use Cases and Queries

Typical scenarios include reporting on which elements belong to a given collection plan, validating element configuration prior to data collection, and feeding external quality systems with plan-element metadata. The following query lists all elements for a specific plan:

  • SELECT collection_plan_name, collection_element_name, default_value, results_column_prompt, enabled_flag, mandatory_flag FROM apps.qabv_collection_plan_elements WHERE collection_plan_id = :p_plan_id;
  • SELECT collection_plan_id, collection_plan_name, COUNT(*) element_count FROM apps.qabv_collection_plan_elements WHERE enabled_flag = 'Yes' GROUP BY collection_plan_id, collection_plan_name;

Because the view is read-only, it is appropriate exclusively for SELECT-based reporting and extraction, not for maintaining collection plan element data.