Results for “parent_transaction”

20 results




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

Overview

QABV_COLPLNTXN is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Quality (QA) product family and exposes collection plan transaction data in a denormalized, business-friendly form. The view is documented as "Retrofitted," indicating it was introduced or re-pointed during an upgrade or localization effort to preserve compatibility with prior customizations or reports. The view definition includes the WITH READ ONLY clause, so it supports query and reporting access only; no DML is permitted against it. Its principal role is to support reporting and integration scenarios that require plan transaction attributes — in particular the background collection flag — in decoded, human-readable form rather than as raw lookup codes stored in the base table.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view references two base objects: QA_PLAN_TRANSACTIONS (exposed through a synonym) and MFG_LOOKUPS (a view). QA_PLAN_TRANSACTIONS is the driving table, aliased QPT in the view text, and supplies the transaction-level columns such as plan transaction ID, flags, foreign keys, and audit columns. MFG_LOOKUPS is joined four times under the aliases MF1 through MF4 to translate stored lookup codes into their meanings or descriptions. MF1, MF2, and MF3 use the lookup type SYS_YES_NO and are outer-joined (the (+) operator), so rows are returned even when a flag is null or has no matching lookup. MF4 uses the lookup type QA_TXN_NAME and is joined with an inner-join predicate, linking transaction numbers to a descriptive parent transaction label.

Key Columns

Common Use Cases and Queries

The view is typically queried to report on collection plan transactions with their flags already decoded, avoiding repeated joins to MFG_LOOKUPS. A frequent scenario is identifying transactions configured for background collection, which corresponds directly to the background_collection_flag search term:

  • List background-collected transactions for a plan: SELECT collection_plan_id, parent_transaction, background_collection_flag, mandatory_collection_flag FROM qabv_colplntxn WHERE collection_plan_id = :plan_id AND background_collection_flag = 'Yes';
  • Audit recently changed configurations: SELECT plan_transaction_id, parent_transaction, last_updated_by, last_update_date FROM qabv_colplntxn ORDER BY last_update_date DESC;
  • Integration extracts: feed enabled and mandatory flags to downstream quality or MES systems by selecting the decoded columns rather than raw codes.
  • Reconciliation: compare decoded flag meanings against QA_PLAN_TRANSACTIONS to validate lookup configuration.

Because the flags are outer-joined, reports should treat null decoded values as "no lookup match" rather than "No." Standard EBS security and the APPS schema privileges apply to all queries.