Search Results chv_bucket_patterns_val_v




Overview
Explore in AI Chat

Overview

CHV_BUCKET_PATTERNS_VAL_V is a validation view owned by the APPS schema in Oracle E-Business Suite, defined within the CHV (Supplier Scheduling) product family. The view exposes validated bucket pattern definitions used by supplier scheduling and planning functionality, where a "bucket" represents a time interval (daily, weekly, monthly, or quarterly) into which supply and demand information is grouped. The suffix "_VAL_V" identifies it as a validation view, typically referenced by Value Set definitions or descriptive flexfield validation, ensuring that end users select only active bucket patterns when configuring scheduling horizons, releases, or planning windows.

The view text applies an activity filter with the predicate SYSDATE < NVL(CBP.INACTIVE_DATE, SYSDATE + 1), which excludes any bucket pattern whose inactive date has passed. Patterns with a null inactive date remain permanently available. This behavioral filter makes the view a self-maintaining source of current, selectable values rather than a historical listing.

Underlying Base Objects

The documented base objects for this view are:

  • CHV_BUCKET_PATTERNS (synonym over the application table) — the primary source of bucket pattern header records, supplying the pattern ID, name, description, inactive date, and the four bucket-count columns.
  • PO_LOOKUP_CODES (view) — joined to translate the WEEK_START_DAY lookup code into a displayable value via the DISPLAYED_FIELD column. The join is an outer join (PLC.LOOKUP_CODE (+) = WEEK_START_DAY) restricted to LOOKUP_TYPE 'DAY_OF_WEEK'.
  • FND_GLOBAL (package) — listed as a referenced object, consistent with standard APPS validation views that may invoke FND_GLOBAL for session or user context resolution.

The join logic defaults the lookup type to 'DAY_OF_WEEK' when the lookup type is null, ensuring the outer join still resolves to the correct lookup category.

Key Columns

  • BUCKET_PATTERN_ID — Primary identifier for the bucket pattern; used as the value returned to the calling form or value set.
  • BUCKET_PATTERN_NAME — User-facing name of the pattern, generally the displayed value in a list of values.
  • DESCRIPTION — Descriptive text carried from the base bucket pattern record.
  • INACTIVE_DATE — Date after which the pattern is no longer offered; drives the SYSDATE filter.
  • NUMBER_DAILY_BUCKETS, NUMBER_WEEKLY_BUCKETS, NUMBER_MONTHLY_BUCKETS, NUMBER_QUARTERLY_BUCKETS — The count of buckets defined at each time granularity, defining the shape of the scheduling horizon.
  • DISPLAYED_FIELD — The decoded day-of-week description derived from PO_LOOKUP_CODES, indicating the pattern's week start day.

Common Use Cases and Queries

This view is most commonly consumed by validation value sets and by custom reports that need a filtered list of active bucket patterns. A typical query retrieving all currently valid patterns, ordered by name, is:

SELECT bucket_pattern_id,
       bucket_pattern_name,
       description,
       week_start_day
FROM   apps.chv_bucket_patterns_val_v
ORDER BY bucket_pattern_name;

To inspect bucket granularity for a specific pattern:

SELECT bucket_pattern_name,
       number_daily_buckets,
       number_weekly_buckets,
       number_monthly_buckets,
       number_quarterly_buckets
FROM   apps.chv_bucket_patterns_val_v
WHERE  bucket_pattern_id = :p_pattern_id;

Because the view already enforces the inactive-date predicate, custom extractions that previously joined CHV_BUCKET_PATTERNS and applied their own SYSDATE filter can be simplified by querying this view directly, guaranteeing consistent behavior with standard Oracle EBS validation logic in both 12.1.1 and 12.2.2 environments.