Search Results ar_lookup_types




Overview
Explore in AI Chat

Overview

AR_LOOKUP_TYPES is a read-only view owned by the APPS schema in Oracle E-Business Suite Receivables. Its documented purpose is to store and expose the standard lookup types used by Receivables QuickCodes — the extensible code-and-meaning lists that drive list-of-values, validation, and reference data throughout the Receivables module. Rather than maintaining a private lookup repository, Receivables defines its QuickCode types against the shared Oracle Application Object Library (FND) lookup infrastructure. AR_LOOKUP_TYPES therefore acts as an application-scoped window onto the centralized FND lookup definitions, filtered to the Receivables application (VIEW_APPLICATION_ID = 222).

For reporting and integration purposes, the view answers the recurring question of which lookup types are registered for Receivables and what their descriptive meaning and user-customization status are. Because the definition resolves against the current session's security context, it returns the correct lookup types for the environment in which it is queried, making it suitable for both online EBS forms driving QuickCode validation and external extracts that must reflect the same reference data.

Underlying Base Objects

The documented base objects referenced by the view are FND_LOOKUP_TYPES (SYNONYM) and FND_LOOKUP_TYPES_VL (VIEW). The view text selects from FND_LOOKUP_TYPES_VL, the translated (VL) variant of the lookup type table, which supplies the MEANING column in the session's language. The WHERE clause restricts rows to VIEW_APPLICATION_ID = 222 (Receivables) and binds SECURITY_GROUP_ID to the maximum security group identifier available to the lookup type among value 0 and the value derived from the client's user environment (USERENV('CLIENT_INFO')). This construction follows the standard Oracle seed-data pattern: it ensures that the user-specific translated row is chosen when one exists, falling back to the shared row otherwise. The synonym FND_LOOKUP_TYPES provides the underlying reference used in the subquery, and the CUSTOMIZATION_LEVEL attribute of the lookup type is decoded to yield the USER_MAINTAINABLE_FLAG.

Key Columns

  • LOOKUP_TYPE — the unique internal name identifying a Receivables QuickCode lookup type.
  • MEANING — the user-facing description of the lookup type, sourced from the translated view.
  • USER_MAINTAINABLE_FLAG — derived by decoding CUSTOMIZATION_LEVEL: 'Y' when the level is 'U' (user-extensible), otherwise 'N'.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording who last touched the record and in which login session.
  • CREATION_DATE, CREATED_BY — audit columns recording initial creation of the lookup type.

Note that the view's exposed DESCRIPTION column corresponds in the underlying select list to the decoded customization value, reflecting the view's internal mapping rather than a free-text description field.

Common Use Cases and Queries

Typical uses include driving QuickCode list-of-values in custom forms, validating lookup values before inserting Receivables data, and enumerating available lookup types for documentation or migration analysis. A common query lists the Receivables lookup types with their maintainability:

  • SELECT lookup_type, description, meaning FROM ar_lookup_types ORDER BY lookup_type;
  • SELECT lookup_type FROM ar_lookup_types WHERE description = 'Y' ORDER BY 1; — returns user-maintainable lookup types only.

Because the view depends on the session security context, it is best queried from within an EBS session or a properly initialized connection; direct database access without the correct client info may return only the shared (security group 0) rows.