Search Results consigned_billing_cycle




Overview
Explore in AI Chat

Overview

POBV_APPROVED_SUPPLIER_LISTS is a read-only view owned by the APPS schema and shipped with the Oracle Purchasing (PO) module. It presents the Approved Supplier List (ASL) definition together with the header-level status and the sourcing-rule attributes maintained for each ASL entry, exposing both the raw key/flag columns and a set of Oracle Forms LOV/List of Values descriptor strings (prefixed _LA:) that the E-Business Suite framework uses to render lookup values correctly on the corresponding form and folder blocks.

The view is categorized in the Oracle E-Business Suite Technical Reference Manual (ETRM) as Retrofitted, meaning it was carried into the 12.1.1 and 12.2.2 releases to preserve backward compatibility for existing customizations, reports and integrations written against earlier releases. It is not a base transactional table; it is a queryable projection designed for reporting and integration consumption, joining the ASL master record to its status and its attributes. The form-oriented pseudo-columns do not alter the semantics of the data but make the view suitable as a single source for both online form queries and programmatic extraction.

Underlying Base Objects

The view is defined over three documented synonyms:

  • PO_APPROVED_SUPPLIER_LIST (synonym) — aliased AL; supplies the ASL identity, owning/using inventory organization, vendor, vendor site, item, category, manufacturer, comments, review date and audit columns.
  • PO_ASL_STATUSES (synonym) — aliased ST; supplies the status code and its description.
  • PO_ASL_ATTRIBUTES (synonym) — aliased AT; supplies planning, sourcing and consignment attributes for the ASL line.

The join is: AL.ASL_ID = AT.ASL_ID and AL.USING_ORGANIZATION_ID = AT.USING_ORGANIZATION_ID, with AL.ASL_STATUS_ID = ST.STATUS_ID. The view text is declared WITH READ ONLY, confirming that no DML is possible through it.

Key Columns

Common Use Cases and Queries

The view is typically used to report ASL coverage by organization and item, to validate sourcing rules before requisition/purchase order creation, and to extract consignment configuration such as billing cycle and last billing date.

List consigned ASLs and their billing cycle for one organization:

SELECT asl_id, using_organization_id, vendor_id, vendor_site_id,
       item_id, status, consigned_billing_cycle, last_billing_date
FROM   apps.pobv_approved_supplier_lists
WHERE  using_organization_id = :org_id
AND    consigned_from_supplier_flag = 'Y';

Find ASLs approaching their review date:

SELECT asl_id, vendor_id, item_id, status_description, review_by_date
FROM   apps.pobv_approved_supplier_lists
WHERE  review_by_date <= SYSDATE + 30
AND    status = 'APPROVED';

Because the view is read-only and joined to status and attributes, it is safe for concurrent, real-time reporting. For transactional updates, the underlying PO_APPROVED_SUPPLIER_LIST and PO_ASL_ATTRIBUTES base tables must be used.