Search Results okl_cus_credit_classes_uv




Overview
Explore in AI Chat

Overview

The OKL_CUS_CREDIT_CLASSES_UV view is a user interface (UI) view owned by the APPS schema within Oracle E-Business Suite. It is delivered as part of the OKL — Leasing and Finance Management product family, and its designated purpose is to supply the list of values (LOV) for the customer credit class field. In practice, the view exposes the set of credit classification codes and their associated meanings and descriptions that a user may select when assigning a credit classification to a customer or lease-related entity. The suffix _UV follows the EBS convention for "User View," indicating that the object is intended primarily for UI and reference consumption rather than as a transactional store. Because it resolves credit classifications from Oracle Receivables lookups, it serves as a lightweight, read-only presentation layer that keeps the Leasing application aligned with the centrally maintained credit rating values. The view carries no data of its own; it is a projection over the underlying lookup repository, and consequently its values reflect whatever is currently defined for the relevant lookup type. This makes it a convenient reference point for reporting, validation, and integration scenarios where the descriptive text of a credit classification code is required without directly navigating the base lookup table.

Underlying Base Objects

The view is defined over a single documented base object: AR_LOOKUPS, which is itself exposed in the environment as a view. The view definition applies an aliasing convention, referring to the base object as CCC and filtering it with the predicate CCC.LOOKUP_TYPE = 'AR_CMGT_TRADE_RATINGS'. This restriction is significant: it confines the result set to the credit management trade ratings lookup category, ensuring that only credit-relevant codes are returned. Because the effective source is AR_LOOKUPS, the credit classifications presented by OKL_CUS_CREDIT_CLASSES_UV are shared with Oracle Receivables credit management functionality. Any insertion, update, or end-dating of trade rating lookup values performed through the Receivables lookup maintenance interface is therefore immediately reflected in the Leasing credit class LOV. The dependency also means that the view inherits the standard lookup attributes — enabled flag, start and end dates, and meaning — subject to the column projection defined in the view text.

Key Columns

  • CREDIT_CLASSIFICATION_CODE — Maps to AR_LOOKUPS.LOOKUP_CODE. This is the stored code value that identifies a credit classification and is the column most commonly referenced by the search term credit_classification_code. It is the value persisted against a customer or credit record.
  • CREDIT_CLASS_MEANING — Maps to AR_LOOKUPS.MEANING. Provides the translatable, user-facing label displayed in the LOV and in reports, giving the readable form of the classification code.
  • CREDIT_CLASS_DESC — Maps to AR_LOOKUPS.DESCRIPTION. Supplies the longer descriptive text associated with the classification, useful for explanatory reporting and downstream documentation.

The projection omits most other AR_LOOKUPS attributes, so consumers needing enabled flags or date ranges must query AR_LOOKUPS directly. The three exposed columns are sufficient for display-oriented use.

Common Use Cases and Queries

Typical applications include populating LOV components, joining descriptive credit class text onto customer or lease extracts, and validating incoming credit classification values during integration loads. A straightforward retrieval of all available credit classes is shown below:

  • SELECT credit_classification_code, credit_class_meaning, credit_class_desc FROM apps.okl_cus_credit_classes_uv ORDER BY credit_classification_code;
  • SELECT credit_classification_code, credit_class_meaning FROM apps.okl_cus_credit_classes_uv WHERE credit_class_meaning LIKE 'A%';
  • SELECT c.credit_classification_code, c.credit_class_meaning FROM apps.okl_cus_credit_classes_uv c WHERE c.credit_classification_code = :p_code;

These queries support LOV rendering, lookup translation validation, and the enrichment of credit-related reporting extracts within the Leasing and Finance Management module.