Search Results credit_class_meaning




Overview
Explore in AI Chat

Overview

APPS.OKL_CUS_CREDIT_CLASSES_UV is a customer-facing reporting view within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It exposes the set of credit classification values that are available for use in credit management processing, such as trade rating assignment at the customer or contract level. The view is defined entirely over Oracle Receivables lookup data, filtering the AR_LOOKUPS repository to the lookup type 'AR_CMGT_TRADE_RATINGS'. Its role is to present a simple, denormalized list of credit classification codes together with their translated meanings and descriptive text, allowing lease and credit analysts, reporting tools, and integration interfaces to retrieve valid credit classes without joining to the base lookup tables directly.

Because the object is a view rather than a table, it carries no independent storage and always reflects the current state of the underlying lookup definitions. This makes it a lightweight and reliable access point for validation lists, list-of-values (LOV) definitions, and lookup-driven report parameters.

Underlying Base Objects

The view is defined over a single documented base object, AR_LOOKUPS, which itself is a view in the Receivables schema. The defining SQL restricts the rows returned to those where LOOKUP_TYPE equals 'AR_CMGT_TRADE_RATINGS'. This lookup type corresponds to the trade rating / credit classification seeded values used by Oracle Credit Management.

  • AR_LOOKUPS (VIEW): The sole referenced object. The view reads from it and applies the LOOKUP_TYPE filter.
  • Credit Management lookup type: 'AR_CMGT_TRADE_RATINGS' is the discriminator that isolates credit classification values from all other lookup types stored in AR_LOOKUPS.

No other base tables, joins, or aggregation logic are documented. The view is effectively a filtered projection of AR_LOOKUPS columns.

Key Columns

  • CREDIT_CLASSIFICATION_CODE: Derived from AR_LOOKUPS.LOOKUP_CODE. This is the stored, internal credit classification identifier used in credit management and lease processing.
  • CREDIT_CLASS_MEANING: Derived from AR_LOOKUPS.MEANING. This is the translatable display name presented to users, typically reflecting the language of the current session.
  • CREDIT_CLASS_DESC: Derived from AR_LOOKUPS.DESCRIPTION. This provides the fuller descriptive text for the credit class. It is this column, surfaced through the view, that answers the common search term "credit_class_desc".

Common Use Cases and Queries

The view is most commonly used to populate LOVs, report parameters, and validation queries that require a list of valid credit classifications. It is also used in integration extracts where an external credit scoring system needs the code and description pairing.

Retrieve all credit classes with their descriptions:

  • SELECT credit_classification_code, credit_class_meaning, credit_class_desc FROM apps.okl_cus_credit_classes_uv ORDER BY credit_classification_code;

Resolve a specific credit class description:

  • SELECT credit_class_desc FROM apps.okl_cus_credit_classes_uv WHERE credit_classification_code = :p_code;

Build a lookup list of values for a credit class field:

  • SELECT credit_class_meaning, credit_classification_code FROM apps.okl_cus_credit_classes_uv ORDER BY credit_class_meaning;

Because the view depends only on AR_LOOKUPS, query performance is generally good, and results reflect any additions or modifications made to the seeded trade rating lookups. Restrictions on the view follow standard APPS synonym and grant conventions in EBS 12.1.1 and 12.2.2.