Search Results row_select_order




Overview
Explore in AI Chat

Overview

APPS.CHV_HORIZ_BKT_SCHEDULES_V is a reporting view in the Oracle EBS Advanced Pricing / Channel Revenue Management (CHV) module. It exposes the horizontal bucket schedule definitions used by pricing and accrual engines to organize time-phased or quantity-phased data into ordered buckets. The view flattens the underlying schedule storage into a business-friendly projection in which each bucket column is resolved to its semantic bucket type through the CHV_INQ_SV.GET_BUCKET_TYPE function. This design allows reports and integrations to interpret which bucket (for example, a period, a quantity band, or a user-defined category) applies to a given column position without needing to decode internal codes.

The view is read-only and is intended for inquiry and reporting rather than transactional maintenance. Because all bucket columns pass through a PL/SQL function, its role is primarily presentational and analytical, feeding concurrent programs, BI Publisher reports, and custom inquiry screens. The ROW_SELECT_ORDER column is particularly relevant to the user's search term, since it defines the display and selection sequence in which bucket rows are returned.

Underlying Base Objects

The documented referenced base objects are:

  • CHV_HORIZONTAL_SCHEDULES (SYNONYM) — the base schedule header/item storage that supplies SCHEDULE_ID, SCHEDULE_ITEM_ID, ROW_SELECT_ORDER, ROW_TYPE, and the COLUMN1 through COLUMN48 raw bucket values.
  • CHV_INQ_SV (PACKAGE) — the inquiry service package whose GET_BUCKET_TYPE function converts each raw bucket value into a descriptive bucket type.

The view therefore acts as a thin transformation layer over CHV_HORIZONTAL_SCHEDULES, adding semantic decoding while preserving the schedule/item identity keys. No aggregation or joins to additional dimension tables are performed within the view text, so row cardinality follows the base schedule directly.

Key Columns

  • SCHEDULE_ID — Identifier of the horizontal bucket schedule header.
  • SCHEDULE_ITEM_ID — Identifier of the individual row (schedule item) within the schedule.
  • ROW_SELECT_ORDER — Numeric ordering used to sequence rows when the schedule is presented or queried; commonly the target of an ORDER BY in reporting SQL.
  • ROW_TYPE — Classifies the nature of the schedule row (for example, header versus detail or a bucket category).
  • Bucket columns (COLUMN1–COLUMN48) — Each is passed through CHV_INQ_SV.GET_BUCKET_TYPE, yielding the descriptive bucket type for that column position rather than the raw stored value.

Common Use Cases and Queries

Typical usage covers schedule definition review, bucket layout validation, and integration extracts. Because ROW_SELECT_ORDER governs presentation sequence, queries commonly sort on it to reproduce the configured bucket order.

Listing all items for a schedule in configured order:

  • SELECT schedule_id, schedule_item_id, row_select_order, row_type FROM apps.chv_horiz_bkt_schedules_v WHERE schedule_id = :p_schedule_id ORDER BY row_select_order;

Inspecting the resolved bucket types for a specific item:

  • SELECT schedule_item_id, row_select_order, column1, column2, column3 FROM apps.chv_horiz_bkt_schedules_v WHERE schedule_id = :p_schedule_id AND schedule_item_id = :p_item_id;

Joining to other schedule-based views or extracts for reporting is also common, using SCHEDULE_ID and SCHEDULE_ITEM_ID as the linking keys and ROW_SELECT_ORDER to control deterministic output ordering.