Search Results chv_bucket_patterns




Overview
Explore in AI Chat

Overview

PO_ASL_ATTRIBUTES_V is an APPS-owned reporting view in the Oracle E-Business Suite Purchasing (PO) module, valid in both 12.1.1 and 12.2.2. It exposes the sourcing rules and supplier scheduling attributes maintained at the Approved Supplier List (ASL) attribute level, denormalized across the lookup, organization, and person entities that the base table references only by identifier. The view is described in ETRM as "Retrofitted," indicating it was re-pointed or re-created during the 12.2 upgrade cycle while preserving its pre-12.2 column contract for downstream consumers.

Its reporting role is to translate coded values into user-facing meanings. Document sourcing method, release generation method, plan and ship schedule types, purchasing unit of measure, VMI replenishment approval, and consigned billing cycle are all surfaced as DISPLAYED_FIELD text rather than raw lookup codes. Similarly, organization identifiers are resolved to organization codes and names, bucket pattern identifiers are resolved to bucket pattern names, and the scheduler identifier is resolved to a full person name. This makes the view suitable for ASL inquiry extracts, supplier scheduling audit reports, and interface programs that must not embed lookup-decoding logic of their own.

Underlying Base Objects

The documented base objects are PO_ASL_ATTRIBUTES, PO_LOOKUP_CODES, MTL_PARAMETERS, PER_PEOPLE_F, HR_ORG_UNITS_NO_JOIN, HR_ALL_ORGANIZATION_UNITS_TL, CHV_BUCKET_PATTERNS, plus the FND_GLOBAL, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages used for the organization and person resolution.

PO_ASL_ATTRIBUTES is the driving table and supplies the ASL identifier, using organization, document sourcing and release generation methods, schedule enablement flags and schedule types, plan and ship bucket pattern identifiers, autoschedule and authorization flags, vendor, vendor site, item, category, the DFF attribute segment columns, the VMI and consigned inventory attributes, the ordering constraints (minimum order quantity, fixed lot multiple, fixed order quantity), and the standard WHO audit columns. PO_LOOKUP_CODES is joined four times to decode the sourcing method, release generation method, and the plan and ship schedule types. MTL_PARAMETERS provides the inventory organization code. CHV_BUCKET_PATTERNS is joined twice — once for the plan bucket pattern and once for the ship bucket pattern — which is the direct source of the bucket pattern names. PER_PEOPLE_F and the HR packages resolve the scheduler and the owning organization.

Because CHV_BUCKET_PATTERNS is referenced as a synonym, the view inherits whatever bucket pattern definitions exist in the current operating unit's context, including patterns created for supplier scheduling in the Planning or Purchasing horizon windows.

Key Columns

Common Use Cases and Queries

The most frequent use is reporting ASL scheduling setup by supplier and item, particularly to confirm which bucket pattern is assigned to the plan and ship horizons. A typical query joining the view to PO_ASL_ATTRIBUTES for a specific vendor and organization is:

  • SELECT asl_id, organization_code, bucket_pattern_name, ship_schedule_type, enable_plan_schedule_flag FROM po_asl_attributes_v WHERE plan_bucket_pattern_id IS NOT NULL;
  • SELECT v.vendor_id, v.item_id, v.plan_bucket_pattern_id, v.bucket_pattern_name FROM po_asl_attributes_v v WHERE v.using_organization_id = :org_id;
  • SELECT asl_id, full_name, enable_autoschedule_flag FROM po_asl_attributes_v WHERE enable_autoschedule_flag = 'Y';

Related scenarios include VMI and consigned inventory audits restricted by ENABLE_VMI_FLAG or CONSIGNED_FROM_SUPPLIER_FLAG, supplier scheduling extracts that need the decoded release generation method rather than the lookup code, and diagnostics that identify ASL rows whose plan or ship bucket pattern identifier no longer resolves to an active CHV_BUCKET_PATTERNS record.