Search Results okl_cs_guarantor_amount_uv




Overview
Explore in AI Chat

Overview

The APPS.OKL_CS_GUARANTOR_AMOUNT_UV view is a reporting and integration object within the Oracle E-Business Suite Leasing and Finance Management module (OKL). It exposes guarantor-level information associated with lease contracts, combining contract header data, party role assignments, guarantor rule amounts, and the guarantor's address and contact details. The view is defined in the APPS schema and holds VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its name, containing the "UV" suffix, follows the Oracle convention indicating a user-facing view intended for inquiry, extraction, or downstream reporting rather than for transactional maintenance. The view is not a base table; it derives all of its data at runtime from the Oracle Contracts (OKC) core and Oracle Trading Community Architecture (HZ) tables, presenting a flattened, denormalized result set that is convenient for reporting tools, concurrent programs, and integration extracts.

Underlying Base Objects

The view is constructed over the following documented base objects, all accessed through APPS synonyms:

The join path begins at the contract header, follows the rule group and party role linkages, and terminates at the HZ party and its contact point, ensuring that only contracts with a GUARANTOR role and an associated guarantor amount rule are returned.

Key Columns

Common Use Cases and Queries

Typical uses include guarantor exposure reporting, lease portfolio risk analysis, and extraction of guarantor contact data for correspondence or interfaces. A sample query retrieving guarantees above a threshold is shown below:

SELECT g.contract_number,
       g.company,
       g.amount_guaranteed,
       g.customer_number
FROM   apps.okl_cs_guarantor_amount_uv g
WHERE  g.amount_guaranteed > 100000
ORDER BY g.amount_guaranteed DESC;

A second common pattern retrieves contact and address details for a specific contract:

SELECT g.role_name,
       g.company,
       g.raw_phone_number,
       g.email,
       g.city,
       g.state,
       g.country
FROM   apps.okl_cs_guarantor_amount_uv g
WHERE  g.contract_number = :contract_number;

Because the view already resolves the GUARANTOR role filter, the rule category LAGRNT, and the primary phone contact point, it eliminates the need for consumers to reproduce the complex OKC rule group and HZ joins themselves. This makes it well suited to operational reports, BI Publisher datasets, and outbound integration extracts in Oracle EBS 12.1.1 and 12.2.2.