Search Results po_quotation_approvals




Overview
Explore in AI Chat

Overview

APPS.PO_QUOTATION_APPROVALS_V is a reporting view in the Oracle E-Business Suite Purchasing (PO) module that exposes quotation approval records for supplier quotations. Quotation approvals represent the workflow-driven authorisation steps applied to a quotation, recording who approved or rejected a quotation line and the reason for that decision. The view denormalises the underlying approval data by joining it to lookup values and to the HR employee directory, so consumers receive readable approval type and approval reason descriptions alongside the approver's full name rather than raw coded identifiers.

Because it is an APPS-owned view rather than a public API, it is intended for query and reporting rather than for transactional inserts or updates. It surfaces standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) together with the eleven-plus descriptive flexfield attribute columns, making it suitable for both functional reports and integration extracts. In 12.1.1 and 12.2.2 the view remains structurally consistent, and the ETRM metadata reflects the 12.2.2 definition.

Underlying Base Objects

The view is defined primarily over PO_QUOTATION_APPROVALS (referenced as a synonym in the ETRM metadata), which supplies the driving rows, including the surrogate key QUOTATION_APPROVAL_ID and the LINE_LOCATION_ID linking the approval to a specific quotation line and shipment. Supporting joins are made to PO_LOOKUP_CODES twice — once aliased PLC for the APPROVAL_TYPE lookup type 'QUOTE APPROVAL TYPE', and once aliased PLC1 for APPROVAL_REASON under lookup type 'QUOTE APPROVAL REASON'. The approver identity is resolved through HR_EMPLOYEES (HRE), with HRE.EMPLOYEE_ID equalling PQA.APPROVER_ID.

Additional ETRM-documented dependencies include HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages, which HR_EMPLOYEES and related personnel views rely on, plus the FND_GLOBAL and FND_PROFILE packages used for session context and multi-org profile resolution. The ORG_ID column confirms the view is operating-unit aware, so queries typically return data scoped to the current operating unit.

Key Columns

  • QUOTATION_APPROVAL_ID — primary identifier for the approval record.
  • LINE_LOCATION_ID — foreign key to the quotation line and shipment being approved.
  • APPROVAL_TYPE / DISPLAYED_APPROVAL_TYPE — the coded value and its translated lookup meaning (e.g. approval action type).
  • APPROVAL_REASON — coded reason, joined from lookup type 'QUOTE APPROVAL REASON'.
  • APPROVER_ID / APPROVER_NAME — employee ID and resolved FULL_NAME of the approver.
  • COMMENTS — free-text remarks entered by the approver.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — effectiveness window for the approval.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — descriptive flexfield columns for customer-defined data.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit trail.
  • ORG_ID — operating unit identifier.

Common Use Cases and Queries

Typical uses include audit reporting of quotation approvals, extracting approver actions for workflow reconciliation, and joining to quotation headers for procurement analysis.

  • Listing approvals for a specific quotation line:
    SELECT approver_name, displayed_approval_type, approval_reason, comments FROM apps.po_quotation_approvals_v WHERE line_location_id = :p_line_location_id;
  • Approval history by approver:
    SELECT qa.quotation_approval_id, qa.approver_name, qa.creation_date FROM apps.po_quotation_approvals_v qa WHERE qa.approver_id = :p_employee_id ORDER BY qa.creation_date DESC;
  • Filtered by approval reason and operating unit:
    SELECT * FROM apps.po_quotation_approvals_v WHERE org_id = :p_org_id AND approval_reason = :p_reason;

When querying, note that the view resolves names through HR security, so results depend on the querying responsibility's personnel access.