Search Results amount_guaranteed




Overview
Explore in AI Chat

Overview

APPS.OKL_CS_GUARANTOR_AMOUNT_UV is a supplementary view owned by the APPS schema within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It is registered under the FND Design Data application OKL and carries a VALID status in both the 12.1.1 and 12.2.2 releases. The view is classified as a supplementary view intended to simplify coding within Oracle Forms, and Oracle explicitly warns that querying or altering data through it is not recommended because the definition may change significantly in subsequent minor or major releases.

Functionally, the view presents guarantor-related party information alongside the amount guaranteed for a given lease or financing contract. It joins contract header, party role, rule group, and trading community (HZ) data into a single flat result set, exposing the contract identifier, contract number, the guarantor's role name, and the amount guaranteed, together with descriptive party detail such as party type, company name, customer number, email, phone, and a fully structured postal address. This structure makes the object convenient for retrieving guarantor contact and financial commitment information in one pass, which explains its popularity as a search target for the column term "amount_guaranteed."

Underlying Base Objects

The view is defined over a documented set of base objects reached through APPS synonyms: OKC_K_HEADERS_B, OKC_K_PARTY_ROLES_B, OKC_RG_PARTY_ROLES, OKC_RG_ROLE_DEFS, OKC_RULES_B, OKC_RULE_GROUPS_B, OKC_SUBCLASS_RG_DEFS, OKC_SUBCLASS_ROLES, HZ_PARTIES, and HZ_CONTACT_POINTS. The OKC_* objects supply the contract, party role, and rule group framework that determines which parties play a guarantor role on a contract and the rule-based amounts associated with them. The HZ_* objects supply the trading community party attributes and contact point details, including the email and phone information surfaced by the view.

The view itself is referenced by several other APPS views — OKL_CS_ALL_PARTIES_W_AMOUNT_UV, OKL_CS_NON_VENDORS_UV, and OKL_CS_PARTIES_TAB_UV — indicating that it forms part of a layered set of party-related views used consistently across lease and finance screens and inquiries.

Key Columns

  • CONTRACT_ID — Numeric identifier of the contract; the principal join key.
  • CONTRACT_NUMBER — Human-readable contract number (VARCHAR2(120)).
  • ROLE_NAME — Name of the party role, identifying the guarantor position held on the contract.
  • AMOUNT_GUARANTEED — The guaranteed amount expressed as a VARCHAR2(450); the column matching the user's search term.
  • PARTY_TYPE — Classification of the party, distinguishing organizations from persons.
  • COMPANY — Organization or party name.
  • CUSTOMER_NUMBER — Trading community customer identifier.
  • EMAIL and RAW_PHONE_NUMBER — Contact details sourced from HZ_CONTACT_POINTS.
  • ADDRESS1–ADDRESS4, CITY, COUNTY, PROVINCE, STATE, POSTAL_CODE, COUNTRY — Full mailing address of the guarantor party.

Common Use Cases and Queries

Typical uses include guarantor reporting for lease portfolios, exposure analysis by guaranteed amount, and integration extracts that require guarantor contact and address data. Because AMOUNT_GUARANTEED is stored as a character string, arithmetic operations require an explicit numeric conversion, and callers should validate the format before conversion.

A simple query retrieving all guarantors for a contract is:

  • SELECT CONTRACT_NUMBER, ROLE_NAME, AMOUNT_GUARANTEED, COMPANY, CUSTOMER_NUMBER FROM APPS.OKL_CS_GUARANTOR_AMOUNT_UV WHERE CONTRACT_ID = :contract_id;
  • SELECT CONTRACT_NUMBER, ROLE_NAME, TO_NUMBER(AMOUNT_GUARANTEED) amt FROM APPS.OKL_CS_GUARANTOR_AMOUNT_UV WHERE TO_NUMBER(AMOUNT_GUARANTEED) > 100000 ORDER BY amt DESC;
  • SELECT CONTRACT_NUMBER, COMPANY, EMAIL, CITY, STATE, COUNTRY FROM APPS.OKL_CS_GUARANTOR_AMOUNT_UV WHERE ROLE_NAME = 'GUARANTOR';

Since the view is documented as subject to change, production code should ideally read from the underlying OKC and HZ tables rather than depending on this supplementary view.