Search Results okl_repair_costs_b

Overview

The table OKL_REPAIR_COSTS_B is a core setup table within the Oracle E-Business Suite (EBS) module for Lease and Finance Management (OKL). Its primary function is to serve as a reference repository for standard repair types and their associated recommended costs. This master data is essential for managing the financial and operational aspects of asset condition repairs, particularly within lease return and asset disposition processes. By centralizing this information, the table enables consistent cost estimation and billing for repairs required to bring leased assets back to a specified condition, thereby supporting accurate financial forecasting and contract compliance.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's description and primary key structure indicate the typical data it contains. The primary key column is ID, which uniquely identifies each repair type record. Based on its functional purpose, the table is expected to store columns such as REPAIR_TYPE, a code or name describing the nature of the repair (e.g., tire replacement, dent repair, engine service); RECOMMENDED_COST, a standard monetary value for that repair; and descriptive columns like ENABLED_FLAG and START_DATE/END_DATE for controlling record validity. It functions as a lookup or reference table, providing standardized data for downstream transactional processes.

Common Use Cases and Queries

The primary use case for OKL_REPAIR_COSTS_B is during the asset condition assessment at lease termination. When an inspector identifies required repairs on a returned asset, the system can reference this table to propose standard repair types and apply recommended costs to generate repair estimates or invoices. A common reporting query would involve joining this table to transactional lines to analyze estimated versus actual repair costs. A typical SQL pattern for retrieving active repair types would be:

SELECT ID, REPAIR_TYPE, RECOMMENDED_COST FROM OKL_REPAIR_COSTS_B WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE) AND ENABLED_FLAG = 'Y' ORDER BY REPAIR_TYPE;

This data is crucial for creating standard repair cost reports and ensuring consistency in chargeback calculations to lessees.

Related Objects

As documented in the ETRM metadata, OKL_REPAIR_COSTS_B has a direct parent-child relationship with the transactional table OKL_ASSET_CNDTN_LNS_B. The foreign key is explicitly defined from the column OKL_ASSET_CNDTN_LNS_B.RPC_ID to the primary key OKL_REPAIR_COSTS_B.ID. This relationship indicates that individual asset condition lines (which detail specific repairs needed on an asset) reference a master repair type and its recommended cost from this setup table. This design ensures data integrity and standardization, as all condition lines for repairs derive their type and suggested cost from a controlled list. No other foreign key relationships are documented in the provided metadata.