Search Results day_of_week




Overview
Explore in AI Chat

Overview

APPS.CHV_BUCKET_PATTERNS_VAL_V is a validation view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It presents bucket pattern definitions maintained in the Advanced Supply Chain Planning and Procurement scheduling framework, exposing only those patterns that remain active as of the current system date. The view is used primarily for list-of-values (LOV) validation and reference during the definition of supplier and buyer scheduling agreements, where bucket patterns determine how planned requirements are grouped across daily, weekly, monthly, and quarterly horizons.

The _VAL_V suffix indicates this is a validation view, meaning it is intended to supply valid, selectable records rather than to serve as a transactional data source. Its role in reporting and integration is to provide a filtered, human-readable list of bucket patterns enriched with the displayed name of the configured week start day.

Underlying Base Objects

The view is defined over the following documented base objects:

  • CHV_BUCKET_PATTERNS (accessed via a synonym) — the primary table that stores bucket pattern definitions, including the daily, weekly, monthly, and quarterly bucket counts and the week start day lookup code.
  • PO_LOOKUP_CODES (a view) — joined to resolve the week start day lookup code into its displayed field value. The join uses the DAY_OF_WEEK lookup type.
  • FND_GLOBAL (a package) — referenced for session context such as the current application and user environment, standard to EBS validation views.

The join to PO_LOOKUP_CODES is an outer join (PLC.LOOKUP_CODE (+) = WEEK_START_DAY), so patterns with no matching lookup row are still returned. The predicate NVL(PLC.LOOKUP_TYPE, 'DAY_OF_WEEK') = 'DAY_OF_WEEK' restricts the lookup side to day-of-week values while tolerating a NULL lookup type.

Key Columns

Collectively these columns describe how a bucket pattern divides a planning horizon, and the week start day clarifies the weekly bucket boundary.

Common Use Cases and Queries

This view is typically queried when configuring or validating scheduling agreement parameters, building LOVs, or auditing active bucket pattern definitions. A common query retrieves all active patterns with their week start day:

  • Populate a bucket-pattern LOV on an agreement or planning form.
  • Report on active patterns and their daily/weekly/monthly/quarterly breakdown.
  • Verify which patterns remain valid given current inactive dates.

Sample SQL:

SELECT bucket_pattern_id, bucket_pattern_name, description, number_daily_buckets, number_weekly_buckets, number_monthly_buckets, number_quarterly_buckets, displayed_field FROM apps.chv_bucket_patterns_val_v ORDER BY bucket_pattern_name;

To locate a specific pattern by name:

SELECT bucket_pattern_id, bucket_pattern_name, displayed_field FROM apps.chv_bucket_patterns_val_v WHERE bucket_pattern_name = :pattern_name;

Because the view already enforces the active-date filter and the DAY_OF_WEEK lookup constraint, callers do not need to reapply these conditions, which keeps validation logic consistent across EBS modules.