Search Results externally_visible_flag




Overview
Explore in AI Chat

Overview

APPS.OE_AR_LOOKUPS_V is a reporting and integration view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the reference lookup definitions used across the Order Management and Receivables product families. The view is defined as a direct, unfiltered projection of AR_LOOKUPS, the foundational lookup table in the Receivables schema. Its primary role is to provide a read-consistent interface through which external systems, concurrent programs, and custom reports can retrieve lookup values — meanings, codes, and enabled status — without querying the base table directly. Because the view retains every column of the underlying table, including descriptive flexfield (DFF) attributes and the EXTERNALLY_VISIBLE_FLAG, it is well suited to both functional reference queries and technical integration scenarios requiring the complete lookup record.

Underlying Base Objects

The ETRM metadata documents a single referenced base object for this view: AR_LOOKUPS. Notably, AR_LOOKUPS is itself catalogued in the same metadata as a VIEW, which reflects the Oracle EBS layering where the public object resolves through synonym and approval layers. The view's SELECT list is a one-to-one mapping of the AR_LOOKUPS columns, with no joins, filters, or transformations applied. Consequently, OE_AR_LOOKUPS_V inherits the row population, security, and org-independence characteristics of its base. There is no WHERE clause narrowing the result set; every lookup defined for the exposed lookup types is returned, so the view is effectively a naming alias for the underlying table as seen from the APPS schema.

Key Columns

The view exposes the standard lookup anatomy, which can be grouped as follows:

  • LOOKUP_TYPE and LOOKUP_CODE — The composite key identifying each lookup value within its lookup type; these drive all joins to application data.
  • MEANING and DESCRIPTION — The user-facing display text and longer descriptive text associated with the code.
  • ENABLED_FLAG — Indicates whether the lookup value is active and selectable; codes with a value of N are retained for historical data but should not be offered in new transactions.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — Effective-dating columns that bound when a lookup value is valid; they must be evaluated alongside ENABLED_FLAG for accurate date-sensitive queries.
  • EXTERNALLY_VISIBLE_FLAG — The column of interest in the user's search. This flag governs whether the lookup value may be surfaced outside the internal EBS application boundary, for example in external interfaces and partner-facing integrations. Values marked as not externally visible should be excluded from outbound feeds.
  • ATTRIBUTE_CATEGORY through ATTRIBUTE15 — The descriptive flexfield segment columns, providing extensible metadata attached to each lookup value.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY support auditing and incremental extraction.

Common Use Cases and Queries

Typical usage includes embedding lookup validation in custom concurrent programs, populating LOVs in custom forms and OAF pages, and driving external integration mappings where only externally visible codes should be transmitted. A common query for users investigating the externally_visible_flag is:

  • SELECT lookup_type, lookup_code, meaning, enabled_flag, externally_visible_flag FROM apps.oe_ar_lookups_v WHERE lookup_type = :p_lookup_type ORDER BY lookup_code;
  • To restrict to externally publishable values: SELECT lookup_code, meaning FROM apps.oe_ar_lookups_v WHERE lookup_type = :p_type AND enabled_flag = 'Y' AND externally_visible_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
  • For incremental extracts, filter on last_update_date to capture newly added or modified lookup values since the previous run.

Because the view performs no filtering, callers must apply ENABLED_FLAG, effective-date, and externally-visible predicates themselves to obtain business-correct results.