Search Results plan_bucket_pattern_id




Overview
Explore in AI Chat

Overview

The PO_ASL_ATTRIBUTES_VAL_V view in the APPS schema is a validated database object within the Oracle E-Business Suite Purchasing (PO) module. It exposes the approved supplier list (ASL) attribute records that are currently active, filtering out any ASL entries flagged as disabled. Its core purpose is to present a consolidated, reportable set of sourcing, scheduling, supplier, and Vendor Managed Inventory (VMI) attributes for approved suppliers across the enterprise. Because the view already applies the DISABLE_FLAG exclusion logic, it is the preferred source for reporting and integration logic that must consider only enabled supplier relationships.

In Oracle EBS 12.1.1 and 12.2.2, this object supports sourcing analysis, supplier performance reporting, plan and ship scheduling configuration, and VMI and consigned inventory processing. The user attribute PLAN_BUCKET_PATTERN_ID and its close companion SHIP_BUCKET_PATTERN_ID, for example, link ASL attributes to scheduling bucketing patterns used in supplier scheduling workflows.

Underlying Base Objects

The view text is defined over two base objects, both referenced as synonyms in the APPS schema:

  • PO_ASL_ATTRIBUTES — the primary attribute table storing per-ASL sourcing, scheduling, supplier, VMI, and consigned inventory settings. All columns prefixed with the alias PAA originate here.
  • PO_APPROVED_SUPPLIER_LIST — the approved supplier list header, aliased PASL. It supplies the join key and the disabled status.

The view joins the two using PAA.ASL_ID = PASL.ASL_ID and applies the filter NVL(PASL.DISABLE_FLAG, 'N') = 'N', returning only rows whose supplier list entry is not disabled. Since the view is essentially a filtered projection of PO_ASL_ATTRIBUTES, it inherits that table's column types and update semantics.

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying the enabled ASL attributes for an item/organization combination, auditing scheduling bucket pattern assignments, and extracting VMI parameters for replenishment processing. The following query returns the active sourcing attributes for a given item and vendor:

SELECT v.asl_id,
       v.using_organization_id,
       v.vendor_id,
       v.item_id,
       v.document_sourcing_method,
       v.plan_schedule_type,
       v.plan_bucket_pattern_id,
       v.enable_vmi_flag
  FROM po_asl_attributes_val_v v
 WHERE v.vendor_id = :p_vendor_id
   AND v.item_id   = :p_item_id;

Because the view excludes disabled supplier list entries, no additional DISABLE_FLAG filtering is required in reporting queries, making it suitable for integration extracts that must reflect only active approved supplier arrangements.