Search Results okc_qa_list_processes_v




Overview
Explore in AI Chat

Overview

OKC_QA_LIST_PROCESSES_V is a documented Oracle E-Business Suite view owned by the APPS schema within the OKC — Contracts Core product. It exposes the contents of the OKC_QA_LIST_PROCESSES table and, per its ETRM definition, exists explicitly as the "View for table OKC_QA_LIST_PROCESSES." The object carries a VALID status in both 12.1.1 and 12.2.2, and its view text is a straightforward projection: the SELECT lists a ROWID alias (ROW_ID) followed by the descriptive, WHO, and DFF columns of the underlying table, filtered only by the FROM clause with no WHERE restriction or join. Functionally, the view is part of the quality assurance (QA) framework in Contracts Core, where QA list processes associate a QA checklist (QCL_ID) with a PDF/process definition (PDF_ID) and govern how that checklist is applied — its severity, activation status, and execution order. Because it is a single-table view, it serves as a stable, read-oriented interface for reports, concurrent programs, and integration extracts that must reference QA list process setup without touching the base table directly.

Underlying Base Objects

The documented referenced base object is OKC_QA_LIST_PROCESSES, which is exposed through a SYNONYM. The view text aliases that table as QLPB and selects every relevant column from it. The presence of OBJECT_VERSION_NUMBER indicates the underlying table participates in Oracle's optimistic locking (OAF/ADF-style) framework, and the ACCESS_LEVEL column reflects the standard access control attribute used across OKC entities. The WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the fifteen ATTRIBUTE flexfield columns are carried through unchanged, confirming the view performs no transformation, derivation, or denormalization. Consequently, any row in OKC_QA_LIST_PROCESSES is visible one-to-one in the view, and DML against the view would resolve to the base table where the schema permits it.

Key Columns

  • ROW_ID — The ROWID of the base table row, exposed for direct row addressing.
  • QCL_ID — Identifier of the associated QA checklist; a principal foreign key linking the process record to its checklist definition.
  • PDF_ID — Identifier of the process/PDF definition to which the QA process is tied.
  • OBJECT_VERSION_NUMBER — Optimistic locking version counter for the record.
  • SEVERITY — Severity classification applied when the QA process is evaluated.
  • ACTIVE_YN — Activation flag determining whether the QA list process is in effect.
  • RUN_SEQUENCE — Ordering value controlling the sequence in which the process runs.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield context and segments for customer-defined extensions.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO auditing columns.
  • ACCESS_LEVEL — Access control indicator inherited from the base entity.

Common Use Cases and Queries

Typical uses include validating QA list process configuration, reporting active processes by checklist or process definition, and extracting setup for migration or audit. Because the view mirrors the base table, queries are simple and index-friendly.

  • List active QA processes for a checklist:

    SELECT qcl_id, pdf_id, severity, run_sequence
    FROM okc_qa_list_processes_v
    WHERE active_yn = 'Y'
    ORDER BY qcl_id, run_sequence;

  • Retrieve all processes tied to a specific process definition:

    SELECT qcl_id, severity, active_yn
    FROM okc_qa_list_processes_v
    WHERE pdf_id = :p_pdf_id;

  • Audit recent changes:

    SELECT qcl_id, pdf_id, last_updated_by, last_update_date
    FROM okc_qa_list_processes_v
    WHERE last_update_date >= :p_since;

For reporting and integration, the view provides a dependable, version-consistent access point to QA list process metadata across Oracle EBS 12.1.1 and 12.2.2.