Results for “cs_cf_flow_pages_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_CF_FLOW_PAGES_VL is a multi-lingual (ML) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CS (Service) product family. It presents the logical union of the base table CS_CF_FLOW_PAGES_B (which stores language-independent, or "base," attributes) and the translation table CS_CF_FLOW_PAGES_TL (which stores language-dependent, translated attributes). The "_VL" suffix is the standard Oracle EBS naming convention indicating a view that exposes both base and translated columns through a single SELECT, transparently filtered by the user's current session language. In the ETRM metadata, the object is marked VALID and is a VIEW type under the APPS owner for both 12.1.1 and 12.2.2.

Functionally, this view surfaces configuration data for "flow pages" used by the Service module's configuration/flow framework. It allows reporting, forms, and integration layers to query flow-page definitions without having to manually join the base and translation tables, and it automatically restricts rows to the translations relevant to the invoking user's language (via USERENV('LANG')). The view is particularly relevant to users searching for the page_display_name attribute, since that translatable column is exposed only through this view, not through the base table alone.

Underlying Base Objects

The view is defined over two documented base objects, both exposed to the APPS schema as synonyms:

• CS_CF_FLOW_PAGES_B — the base table holding language-independent columns such as FLOW_ID, FLOW_TYPE_PAGE_ID, ENABLED_FLAG, WHO audit columns, OBJECT_VERSION_NUMBER, and the ATTRIBUTE1 through ATTRIBUTE15 DFF columns.
• CS_CF_FLOW_PAGES_TL — the translation table holding the language-dependent column PAGE_DISPLAY_NAME, keyed by FLOW_ID and FLOW_TYPE_PAGE_ID, plus LANGUAGE.

The view text joins the two on FLOW_ID and FLOW_TYPE_PAGE_ID and filters the translation side on T.LANGUAGE = USERENV('LANG'). It also exposes B.ROWID as ROW_ID. The equivalence of _B and _TL rows is therefore governed by the (FLOW_ID, FLOW_TYPE_PAGE_ID) pair plus the current language.

Key Columns

• ROW_ID — the ROWID of the base (_B) row, useful for identifying the underlying physical row.
• FLOW_ID — identifier of the parent flow to which the page belongs. Part of the join key between base and translation tables.
• FLOW_TYPE_PAGE_ID — identifier of the flow-type page; the second component of the primary logical key.
• PAGE_DISPLAY_NAME — the translated, user-facing page name; sourced from CS_CF_FLOW_PAGES_TL and resolved for the current language. This is the column most commonly requested by users searching on "page_display_name."
• ENABLED_FLAG — indicates whether the flow page is active/enabled in configuration.
• OBJECT_VERSION_NUMBER — optimistic locking version stamp for the record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns describing record creation and last modification.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1..ATTRIBUTE15 — descriptive flexfield (DFF) context and segment columns available for extension.

Common Use Cases and Queries

Typical usages include reporting on configured flow pages by ID or translated name, validating the presence of translations per language, and integration lookups that must resolve the display name in the invoking user's language. Because the view auto-filters to USERENV('LANG'), a query returns only rows translated into the caller's session language.

List enabled flow pages with their translated names for a given flow:

• SELECT flow_id, flow_type_page_id, page_display_name FROM apps.cs_cf_flow_pages_vl WHERE flow_id = :p_flow_id AND enabled_flag = 'Y';

Locate a page by its display name, a common search when only the human-readable label is known:

• SELECT flow_id, flow_type_page_id, page_display_name FROM apps.cs_cf_flow_pages_vl WHERE page_display_name LIKE :keyword;

Audit recently changed configuration: SELECT flow_id, flow_type_page_id, page_display_name, last_updated_by, last_update_date FROM apps.cs_cf_flow_pages_vl WHERE last_update_date >= :since;

Because translations are filtered by session language, cross-language reporting requires querying CS_CF_FLOW_PAGES_TL directly, or explicitly setting the NLS_LANGUAGE session context before invoking the view.