Search Results approved_supplier_list_id




Overview
Explore in AI Chat

Overview

POBV_ASL_DOCUMENTS is an Oracle E-Business Suite view owned by the APPS schema and classified under the PO - Purchasing product family. It is documented with the annotation "Retrofitted," indicating that the object was carried forward through an upgrade or re-implementation path rather than newly authored for the current release. It remains in VALID status in both Oracle EBS 12.1.1 and 12.2.2.

The view presents approved supplier list (ASL) document assignments. An ASL entry records the qualification of a supplier, supplier site, or supplier-site combination to provide a specific item or commodity to a given organization. Associated with each ASL entry are one or more "documents" — typically sourcing, quality, or specification references categorized by document type — that support or qualify that supplier approval. POBV_ASL_DOCUMENTS exposes these document-to-ASL assignments, including the linked document header and line identifiers, together with standard WHO (audit) columns. The view is defined as a read-only construct (WITH READ ONLY), so it serves reporting, inquiry, and downstream integration functions rather than transactional maintenance. Users searching for the identifier "document_line_id" arrive at this object because DOCUMENT_LINE_ID is one of the core columns surfaced here, linking each ASL document record to a specific line on the referenced external document.

Underlying Base Objects

The view is defined over a single base object: PO_ASL_DOCUMENTS, accessed through a synonym in the APPS schema. The view text selects from that synonym and aliases it as AD. Because only one base object is involved, the view performs no join operations; its transformation logic consists of column projection, aliasing, and the injection of descriptive flexfield and security tokens.

The relationship is therefore one-to-one at the row level: every row returned by POBV_ASL_DOCUMENTS corresponds to exactly one row in PO_ASL_DOCUMENTS. The projection renames the base columns to conform to the view's documented column list — for example, ASL_ID is exposed as APPROVED_SUPPLIER_LIST_ID, USING_ORGANIZATION_ID and ORG_ID map to USING_ORGANIZATION_ID and OPERATING_UNIT_ID respectively, SEQUENCE_NUM becomes SEQUENCE_NUMBER, DOCUMENT_HEADER_ID becomes DOCUMENT_ID, and the audit columns are exposed with CREATED_DATE/LAST_UPDATED_DATE naming. A WHERE clause applying a security token ('_SEC:AD.ORG_ID') IS NOT NULL enforces operating-unit-level data access control, ensuring that only rows within the user's authorized organization context are returned.

Key Columns

  • APPROVED_SUPPLIER_LIST_ID — Identifier of the parent ASL entry to which the document is attached; joins to PO_ASL_HEADERS or the ASL entity.
  • USING_ORGANIZATION_ID / OPERATING_UNIT_ID — The inventory organization and operating unit context governing the ASL record, and the basis for the view's security filter.
  • SEQUENCE_NUMBER — Ordering of documents within the ASL record, permitting deterministic display sequences.
  • DOCUMENT_TYPE — A descriptive flexfield/lookup-derived column resolving to the PO lookup type "PO TYPE," denoting whether the document is, for example, a purchasing document, a specification, or a quality clause. The view text embeds the token '_LA:AD.DOCUMENT_TYPE_CODE:PO_LOOKUP_CODES:PO TYPE:DISPLAYED_FIELD', indicating association with the PO_LOOKUP_CODES lookup set.
  • DOCUMENT_ID — Header identifier of the referenced document (sourced from DOCUMENT_HEADER_ID).
  • DOCUMENT_LINE_ID — Line-level identifier within the referenced document. This is the column most commonly used to trace a specific ASL document assignment back to its originating document line.
  • CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY — Standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical scenarios include supplier qualification audits, sourcing document traceability, and integration extracts that populate external supplier management or document management systems. The view is frequently queried to list all documents supporting a supplier's approval status, or to reverse-look-up which ASL entries reference a given document line.

To retrieve all documents for a specific ASL entry:

  • SELECT approved_supplier_list_id, sequence_number, document_type, document_id, document_line_id FROM apps.pobv_asl_documents WHERE approved_supplier_list_id = :asl_id ORDER BY sequence_number;

To find ASL records linked to a known document line:

  • SELECT approved_supplier_list_id, operating_unit_id, document_type, document_id FROM apps.pobv_asl_documents WHERE document_line_id = :document_line_id;

Because the view is read-only and carries an organization security predicate, queries automatically respect the caller's operating unit context; any insert, update, or delete against it will raise an error, and DML must be directed to PO_ASL_DOCUMENTS itself.