Results for “csd_repair_types_sar_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSD_REPAIR_TYPES_SAR_VL is an APPS-owned view within the Oracle E-Business Suite Depot Repair (CSD) module. It is classified as a report view, a type of database object that joins related tables and views to provide a single, denormalized result set for reporting and integration purposes. Its central function is to associate Depot Repair types with the service billing arrangements that govern how repair transactions are charged to a customer. Specifically, the view links transaction types and their billing types to repair types, enabling reporting on which combination of repair types and billing mechanisms is valid and available.

This view is relevant when querying or reporting on transaction types in the Depot Repair context. A common search entry point for this data is cs_transaction_types_vl, which is one of the underlying objects in the view definition. The view consolidates that data with billing type categories, billing type lookup meanings, and repair type definitions, making it possible to report on the transactional behavior of Depot Repair without navigating multiple base objects individually.

Underlying Base Objects

According to the documented ETRM 12.2.2 metadata, the view is defined over the following objects:

• CSD_REPAIR_TYPES_SAR (synonym) — provides the repair transaction billing type association and primary key information.
• CSD_REPAIR_TYPES_VL (view) — supplies the repair type definition and its translatable name and description.
• CS_TRANSACTION_TYPES_VL (view) — supplies the transaction type name, description, and Depot Repair flag.
• CS_TXN_BILLING_TYPES (synonym) — the transaction-to-billing-type mapping.
• CS_BILLING_TYPE_CATEGORIES (synonym) — the billing category associated with each billing type.
• FND_LOOKUP_VALUES_VL (view) — resolves the billing type flag into a meaning and description using the MTL_SERVICE_BILLABLE_FLAG lookup type.
• FND_GLOBAL (package) — used for session context, such as the current user and login information.

Internally, the view joins these objects on transaction type ID, billing type, billing category, billing type lookup code, and repair type ID. This join structure is what produces a consolidated record that connects a repair type to its permitted billing behavior.

Key Columns

The view exposes both business and technical columns:

• ROW_ID — the unique row identifier of the underlying CSD_REPAIR_TYPES_SAR record.
• REPAIR_TXN_BILLING_TYPE_ID — primary association identifier for the repair billing type combination.
• REPAIR_TYPE_ID and TXN_BILLING_TYPE_ID — foreign keys to the repair type and transaction billing type definitions.
• TRANSACTION_TYPE_ID, TXN_TYPE_NAME, and TXN_TYPE_DESCRIPTION — identify the transaction type and its translatable name and description.
• BILLING_TYPE, BILLING_TYPE_MEANING, and BILLING_TYPE_DESCRIPTION — describe how the transaction is billable or non-billable.
• BILLING_CATEGORY — the category grouping for the billing type.
• FND_LOOKUP_TYPE — indicates the lookup type used to resolve the billing flag.
• DEPOT_REPAIR_FLAG — signifies whether the transaction type is used within Depot Repair.
• Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

This view is typically used for reporting on the valid combinations of Depot Repair types and their billing arrangements, and for validating configuration across transaction types. A representative query follows:

SELECT repair_type_id, txn_type_name, billing_type, billing_type_meaning, billing_category, depot_repair_flag FROM apps.csd_repair_types_sar_vl WHERE depot_repair_flag = 'Y';

Analysts may also filter by transaction type name or billing category to audit the billing configuration applicable to specific repair types. Because the view includes translatable name and description columns, it is suitable for multilingual reporting environments.