Search Results fnd_lookup_type




Overview
Explore in AI Chat

Overview

APPS.CSD_REPAIR_TYPES_SAR_VL is a supplementary view in the Oracle E-Business Suite Depot Repair module (CSD). It presents a denormalized, user-facing representation of repair type definitions joined to their associated transaction billing types, transaction types, and billing categories. The "_VL" suffix indicates a translated view that exposes both the internal lookup code (for example, BILLING_TYPE) and its translatable meaning (BILLING_TYPE_MEANING), which is the attribute most frequently referenced when users search for the term "billing_type_meaning".

Oracle explicitly classifies this object as a supplementary view used to simplify Oracle Forms coding, and warns that it should not be queried or altered for transactional purposes, as its structure may change substantially across minor or major releases. Consequently, the view is best treated as a read-only reporting and integration surface rather than a data entry target. It is particularly relevant when building custom reports, concurrent programs, or integration extracts that must resolve the human-readable billing meaning attached to a given repair type.

Underlying Base Objects

The documented view metadata lists the following referenced base objects:

The view therefore acts as a convenience layer that hides the joins among repair types, transaction types, billing types, categories, and lookups behind a single queryable object.

Key Columns

Common Use Cases and Queries

Typical usage includes creating custom billing reports, validating billing type assignments on repair types, and feeding downstream systems with translated billing meanings. The following query is illustrative and reflects the documented column list:

  • SELECT rt.BILLING_TYPE, rt.BILLING_TYPE_MEANING, rt.BILLING_CATEGORY, rt.TXN_TYPE_NAME, rt.DEPOT_REPAIR_FLAG FROM APPS.CSD_REPAIR_TYPES_SAR_VL rt WHERE rt.REPAIR_TYPE_ID = :p_repair_type_id;
  • SELECT DISTINCT BILLING_TYPE, BILLING_TYPE_MEANING FROM APPS.CSD_REPAIR_TYPES_SAR_VL ORDER BY BILLING_TYPE_MEANING;
  • SELECT rt.REPAIR_TYPE_ID, rt.TXN_TYPE_NAME, rt.BILLING_TYPE_MEANING FROM APPS.CSD_REPAIR_TYPES_SAR_VL rt WHERE rt.DEPOT_REPAIR_FLAG = 'Y';

Because the view is a supplementary form-support view, developers should always prefer querying only its exposed columns, avoid DML operations against it, and rely on the documented FND lookup and WHO columns for meaning resolution and auditing.