Search Results icx_horizontal_schedule_v




Overview
Explore in AI Chat

Overview

ICX_HORIZONTAL_SCHEDULE_V is a database view owned by the APPS schema within the Oracle iProcurement (ICX) product family. It is documented in Oracle E-Business Suite releases 12.1.1 and 12.2.2 as the "Horizontal Schedule View." The object is registered in ETRM with a status of VALID, confirming it is a supported dictionary object in both releases.

The view exposes the horizontal, column-oriented representation of purchasing and sourcing schedules used by iProcurement. Horizontal schedules pivot time-bucketed supplier or item information across a fixed set of columns rather than storing each bucket as a separate row. This view flattens that pivot structure into a form that can be consumed directly by Oracle Forms, OAF pages, concurrent programs, and custom reporting queries. It is a read-only reporting and integration artifact; it holds no data of its own and inherits all content from the underlying schedule tables.

Because schedule rows include both bucket descriptor rows and data rows, the view applies conditional decoding so that column values are rendered appropriately depending on the row type. This makes the view suitable for display-driven queries without additional application-layer transformation.

Underlying Base Objects

ETRM documents four referenced objects for this view:

  • CHV_HORIZONTAL_SCHEDULES (SYNONYM) — the primary source of schedule rows. The view selects schedule_id, schedule_item_id, row_select_order, row_type, and the ten column positions (column1 through column10) from this object, along with the standard WHO columns created_by, creation_date, last_updated_by, and last_update_date.
  • CHV_INQ_SV (PACKAGE) — supplies the GET_BUCKET_TYPE function, which is invoked for rows where row_select_order equals 1. This call resolves each of the ten columns to a bucket type descriptor rather than a raw value.
  • PO_LOOKUP_CODES (VIEW) — provides lookup descriptions and the displayed_field attribute. The join is keyed on the row type, and the description is returned only when row_type is not 'BUCKET_DESCRIPTOR'.
  • FND_GLOBAL (PACKAGE) — the standard EBS global context package, referenced for session and responsibility context used during execution.

The synonym CHV_HORIZONTAL_SCHEDULES is the principal dependency; the view is effectively a decoding and presentation layer over it.

Key Columns

  • SCHEDULE_ID — identifier of the parent horizontal schedule.
  • SCHEDULE_ITEM_ID — identifier of the individual line or item within the schedule.
  • ROW_SELECT_ORDER — indicates which logical row the record represents; value 1 drives bucket-type decoding and value 2 drives date decoding.
  • ROW_TYPE — classifies the row (for example, a bucket descriptor versus a data row) and controls whether a lookup description is returned.
  • DESCRIPTION / DISPLAYED_FIELD — lookup description and the field label sourced from PO_LOOKUP_CODES; the description is suppressed for bucket descriptor rows.
  • COLUMN1 through COLUMN10 — the pivoted bucket values. Depending on row_select_order, each is returned as a bucket type, a formatted date (YYYY/MM/DD), or the raw column value.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns inherited from the base schedules object.

Common Use Cases and Queries

Typical scenarios include diagnosing misconfigured horizontal schedules in iProcurement, reconciling displayed schedule rows against source data, and building custom reports over time-phased schedule information.

  • Retrieve all rows for a given schedule:
    SELECT schedule_id, schedule_item_id, row_select_order, row_type, column1, column2 FROM apps.icx_horizontal_schedule_v WHERE schedule_id = :p_schedule_id ORDER BY row_select_order;
  • Return only descriptor rows to map bucket types:
    SELECT schedule_id, row_type, column1, column2, column3 FROM apps.icx_horizontal_schedule_v WHERE row_select_order = 1;
  • Inspect lookup-backed labels:
    SELECT row_type, description, displayed_field FROM apps.icx_horizontal_schedule_v WHERE row_type <> 'BUCKET_DESCRIPTOR';
  • Audit recently changed schedules:
    SELECT schedule_id, last_updated_by, last_update_date FROM apps.icx_horizontal_schedule_v WHERE last_update_date > SYSDATE - 30;

Queries should be executed against the APPS schema or a synonym, and callers relying on bucket-type resolution must ensure the CHV_INQ_SV package is valid and compiled.