Search Results order_direction




Overview
Explore in AI Chat

Overview

APPS.EGO_RESULTS_FORMAT_COLUMNS_V is a reporting view in Oracle E-Business Suite that exposes the column-level formatting, ordering, and display configuration applied to result regions within the extensibility framework. It is part of the EGO (Oracle Product Information Management / extensibility) schema, and it presents a flattened, query-friendly projection of the metadata stored in the AK_CUSTOM_REGION_ITEMS table. In EBS 12.1.1 and 12.2.2, this view is used primarily to drive the presentation of configurable result tables, allowing administrators and developers to inspect how attributes are sequenced and rendered on a region.

The view does not store data itself; rather, it consolidates multiple property rows from the base customization table into a single row per attribute, joining display sequence, order sequence, order direction, column name, and total-display flags. This makes it valuable for diagnostics, personalization analysis, and integration reporting where the effective display layout of a customizable region must be determined programmatically.

Underlying Base Objects

The documented base object referenced by EGO_RESULTS_FORMAT_COLUMNS_V is AK_CUSTOM_REGION_ITEMS (exposed to APPS through a synonym). The view is constructed from several inline subqueries, each filtering AK_CUSTOM_REGION_ITEMS on a distinct PROPERTY_NAME value. Specifically, the view joins derived query blocks keyed on 'DISPLAY_SEQUENCE', 'ORDER_SEQUENCE', and 'ORDER_DIRECTION' against additional lookups that supply the column name and the show-total flag. Because the source is a single customization table that stores property values in name/value pairs, the view acts as a pivot that reassembles those rows into a conventional columnar result set.

This design means the view inherits the region- and attribute-scoping semantics of AK_CUSTOM_REGION_ITEMS, including the customization application and code, region application and code, and attribute application and code keys. The attribute_application_id column the user searched for is one of those scoping keys, identifying the application that owns the attribute being formatted.

Key Columns

  • CUSTOMIZATION_APPLICATION_ID / CUSTOMIZATION_CODE — Identify the customization that defines the region layout.
  • REGION_APPLICATION_ID / REGION_CODE — Identify the specific region whose columns are being formatted.
  • ATTRIBUTE_APPLICATION_ID / ATTRIBUTE_CODE — Identify the individual attribute (column) within the region. ATTRIBUTE_APPLICATION_ID is the application that owns the attribute, and it is the column most relevant to the user's search.
  • ORDER_SEQUENCE — The numeric sequence used to order columns within the region.
  • DISPLAY_SEQUENCE — The display order position assigned to the attribute.
  • ORDER_DIRECTION — The sort direction (for example ascending or descending) applied to the attribute.
  • COLUMN_NAME — The physical or logical column name rendered for the attribute.
  • SHOW_TOTAL — Indicates whether the column participates in a total row.

Common Use Cases and Queries

Typical uses include auditing how a region's columns are ordered, verifying that the correct attribute application is mapped, and generating reports that reproduce the effective result-table layout. A representative query filtering by the searched column is:

  • SELECT customization_code, region_code, attribute_application_id, attribute_code, order_sequence, display_sequence, order_direction, column_name, show_total FROM apps.ego_results_format_columns_v WHERE attribute_application_id = :app_id ORDER BY region_code, order_sequence;

This query returns the ordered column definition for every attribute owned by the supplied application, enabling verification of sequence, direction, and total behavior across regions.