Search Results okx_list_headers_v




Overview
Explore in AI Chat

Overview

OKX_LIST_HEADERS_V is a VALID Oracle E-Business Suite view owned by the APPS schema in the OKX – Contracts Integration module. It exposes header information for all types of lists maintained by Oracle Advanced Pricing, presenting a denormalized, translation-aware, and status-derived projection of the underlying pricing list structures. Rather than requiring report developers and integration components to join base and translation tables and compute effective-date status manually, the view consolidates a single row per list header per language and annotates it with a derived availability status.

The view is particularly relevant in contracts integration (OKX) scenarios, where list headers drive the resolution of price lists, discount lists, and promotion lists. Because OKX and Advanced Pricing share the QP schema objects, this view provides the canonical read interface for list header attributes such as currency, automatic application, and the DISCOUNT_LINES_FLAG — the very column that surfaces when users search for "discount_lines_flag" in the ETRM metadata. It is documented and available in both Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view text selects from two documented base objects, both referenced via APPS synonyms in ETRM:

The alias B refers to the base row (exposed as B_STATUS through B.ACTIVE_FLAG), while alias T supplies the translated text. The join condition is B.LIST_HEADER_ID = T.LIST_HEADER_ID. A synthetic literal column '#' ID2 is included, and ID1 is mapped from B.LIST_HEADER_ID.

Key Columns

  • LIST_TYPE_CODE — the classification of the list (e.g., price list, discount list, promotion list).
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range governing list availability.
  • AUTOMATIC_FLAG — indicates whether the list is applied automatically.
  • CURRENCY_CODE — the currency associated with the list header.
  • DISCOUNT_LINES_FLAG — the flag indicating whether the list carries discount lines; this is the attribute most frequently searched for when troubleshooting pricing qualification behavior.
  • NAME / DESCRIPTION — language-specific text from QP_LIST_HEADERS_TL.
  • B_STATUS — the raw base-table ACTIVE_FLAG value.
  • STATUS — a derived column computed with nested DECODE/SIGN logic against TRUNC(SYSDATE). It evaluates to 'I' when today precedes START_DATE_ACTIVE or exceeds END_DATE_ACTIVE, and 'A' when the list is currently active. Note that this logic intentionally treats a today-before-start case as 'I'.
  • ID1 — the list header identifier, aliasing LIST_HEADER_ID.

Common Use Cases and Queries

The view is commonly used to list active price or discount lists for a given currency, to drive pricing qualification reports, and as the header source in OKX contract integration extracts. A typical query enumerating currently active discount-bearing lists might read:

  • SELECT id1, name, list_type_code, currency_code, discount_lines_flag, status
  • FROM okx_list_headers_v
  • WHERE status = 'A'
  • AND discount_lines_flag = 'Y'
  • AND list_type_code = 'DISCOUNT';

Because the view filters translations by the session language, reports automatically return NAME and DESCRIPTION in the runtime language. Analysts investigating the "discount_lines_flag" attribute frequently join this view to QP_LIST_LINES through the list header id to reconcile header-level and line-level discount settings.