Search Results po_asl_documents_v




Overview
Explore in AI Chat

Overview

PO_ASL_DOCUMENTS_V is an APPS-owned database view within the Oracle Purchasing (PO) module. Its documented status is VALID, and its description carries the notation "Retrofitted," indicating that the object was carried forward into the current release line (12.1.1 and 12.2.2) as part of the E-Business Suite readiness and upgrade effort. The view presents the association between Approved Supplier List (ASL) entries and the purchasing documents linked to them, joining supplier-list context to the underlying PO_HEADERS_ALL document headers and their lines. As a denormalized read-only presentation, it serves reporting and integration purposes, exposing ASL document assignments alongside header, line, organization, and vendor attributes in a single queryable surface.

Users searching for the column DOCUMENT_STATUS_DSP are typically seeking the resolved, display-ready status of a purchasing document attached to an ASL entry. The view supplies this value through a DECODE expression rather than a stored column: for QUOTATION type documents it returns PH.STATUS_LOOKUP_CODE, while for BLANKET and CONTRACT documents it returns PH.AUTHORIZATION_STATUS. This conditional projection is what reporting tools surface as the document status display value.

Underlying Base Objects

The view is defined over the following documented base objects: PO_ASL_DOCUMENTS (SYNONYM), PO_APPROVED_SUPPLIER_LIST (SYNONYM), PO_HEADERS_ALL (SYNONYM), PO_LINES_ALL (SYNONYM), PO_LOOKUP_CODES (VIEW), MTL_PARAMETERS (SYNONYM), HR_ORG_UNITS_NO_JOIN (VIEW), HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM), plus the FND_GLOBAL, HR_GENERAL, and HR_SECURITY packages. PO_ASL_DOCUMENTS is the driving table, holding the ASL-to-document link keyed by ASL_ID and DOCUMENT_HEADER_ID. PO_APPROVED_SUPPLIER_LIST provides vendor, vendor site, item, and category context. PO_HEADERS_ALL and PO_LINES_ALL (the latter an outer join) supply document header and line detail. PO_LOOKUP_CODES resolves both the document type display text and the status display text. MTL_PARAMETERS and the HR organization views supply the using-organization code and name. The HR packages and FND_GLOBAL apply organizational security and session context at query time.

Key Columns

Common Use Cases and Queries

Typical usages include ASL-to-document reporting, supplier qualification audits, and integration extracts that require the displayed status of blanket agreements or contracts tied to a supplier list entry. Because date-effective HR security is applied, results are filtered by the querying user's organization access.

  • List all documents for a given ASL entry with their resolved status.
  • Report blanket agreements and contracts by supplier and organization with status display.
  • Extract ASL document associations for interface into external procurement systems.

Sample query:

SELECT asl_id,
       document_type_code,
       displayed_field        AS document_type_dsp,
       document_status_dsp,
       segment1               AS document_number,
       organization_code,
       start_date,
       end_date
FROM   apps.po_asl_documents_v
WHERE  asl_id = :p_asl_id
ORDER  BY sequence_num;

The view is read-only and must be queried as APPS or through a synonym, with the invoking session's organization context properly initialized.