Results for “covered_amount”

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

Overview

OKL_INS_POLICIES_UV is an Oracle E-Business Suite view owned by the APPS schema and defined within the OKL (Leasing and Finance Management) product. It presents a consolidated, user-facing representation of insurance policy data held in the Oracle Lease and Finance Management insurance subsystem. The view joins the base insurance policy entity and its translation table to lookup-driven descriptions and reference data, exposing policy status, coverage terms, premiums, and agency information in a single denormalized result set. Because of this consolidation, it functions as the primary read interface for insurance policy reporting, inquiry screens, and downstream integrations in EBS 12.1.1 and 12.2.2, and is referenced from within the library of APIs returned by the ETRM metadata repository under the same object name.

Underlying Base Objects

The documented referenced base objects are:

• OKL_INS_POLICIES_B — the base table storing core policy attributes.
• OKL_INS_POLICIES_TL — the translation table holding descriptive and comment fields.
• OKL_INS_PRODUCTS_TL — supplies insurance product names.
• FND_LOOKUPS — resolves lookup codes into display meanings.
• FND_TERRITORIES_TL — territory and site reference data.
• JTF_RS_SALESREPS — the sales representative reference used to relate policies to a resource.
• OKX_INSURANCE_AGENT_V, OKX_INSURER_V, OKX_INS_PROVIDER_V — insurer, agent, and provider views.
• FND_GLOBAL — package supplying session context.

Columns are projected from these objects with aliases (for example, IPYB for OKL_INS_POLICIES_B, IPYT for OKL_INS_POLICIES_TL, IPTT for OKL_INS_PRODUCTS_TL, FLPF/FLPS/FLPT/FIFC for FND_LOOKUPS). The view is therefore read-only and inherits the row-level security behavior of its constituent base objects.

Key Columns

Prominent exposed columns include:

• ROW_ID, ID, OBJECT_VERSION_NUMBER — row identifier and optimistic locking version.
• STATUS — a DECODE-derived lifecycle value of ACTIVE, EXPIRED, or CONVERTED.
• POLICY_NUMBER, POLICY_TYPE, IPY_TYPE — policy identification and classification.
• INSURANCE_PROVIDER, INSURANCE_AGENT, INSURANCE_PRODUCT_NAME — display names from the provider, agent, and product objects.
• INSURANCE_STATUS, PAYMENT_FREQUENCY1, INSURANCE_FACTOR, INSURANCE_PRODUCT_NAME — lookup-derived meanings.
• PREMIUM, CALCULATED_PREMIUM, COVERED_AMOUNT, DEDUCTIBLE — financial and coverage amounts.
• DATE_FROM, DATE_TO, DATE_QUOTED, DATE_QUOTE_EXPIRY, ACTIVATION_DATE — policy dates.
• SALES_REP_ID — the sales representative associated with the policy, resolved in relation to the JTF_RS_SALESREPS synonym.
• QUOTE_YN, AGENT_YN, LESSOR_INSURED_YN, ON_FILE_YN — indicator flags.

Common Use Cases and Queries

The view supports insurance policy inquiry and reporting, including tracking status transitions, expiry monitoring, premium analysis, and reporting by sales representative or provider.

A representative query followed by rows for a specific sales representative is:

• SELECT policy_number, insurance_provider, status, premium, date_from, date_to FROM apps.okl_ins_policies_uv WHERE sales_rep_id = :p_sales_rep_id;

Additional common patterns include filtering on status = 'ACTIVE' for in-force policies, using MONTHS_BETWEEN(date_to, SYSDATE) to identify approaching expirations, and joining the result set to OKL_K_LEASES or contract tables on KLE_ID to report insured leased assets. Because the view exposes ROW_ID and OBJECT_VERSION_NUMBER, it is suitable for consumption by Oracle Forms-based inquiry screens that require accurate concurrency control.