Search Results rgp_lafexp

Overview

APPS.OKL_LA_SERVICE_LINES_UV is a reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes sold-service contract lines together with their associated lease-financing rule data. The view joins the OKC contract-line core (OKC_K_LINES_B), the OKL lease-line extension (OKL_K_LINES), contract items, inventory item descriptions, line styles, time units, and the OKC rule/rule-group structures used for LAFEXP and LAFREQ rule categories. Its principal purpose is to return a flattened result set per sold-service line in which the service amount, item identity, frequency rule, and expense rule information are aligned, allowing downstream reporting and integration processes to read lease-financing rule data without navigating the normalized OKC_RULES_B / OKC_RULE_GROUPS_B model directly.

The name reflects its scope: OKL (Oracle Lease Management) LA (lease accounting) service lines. The rule-group alias RGP_LAFEXP is the source of the user search term "rgp_lafexp"; the rule-group code LAFEXP and the rule category LAFEXP both appear explicitly in the view predicates.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is owned by APPS and references the following objects, all as synonyms except where noted:

• OKC_K_LINES_B — the base contract line (aliased CLEB_SVC), supplying line id, header id, and start/end dates.
• OKL_K_LINES — the OKL line extension (aliased KLE_SVC), supplying the service amount and the ATTRIBUTE_CATEGORY through ATTRIBUTE15 descriptive flexfield columns.
• OKC_K_ITEMS — the contract item (aliased CIM_SVC), restricted to jtot_object1_code = 'OKX_SERVICE'.
• MTL_SYSTEM_ITEMS_TL — the translated item description (aliased MSIT), joined on inventory item id and organization id with language matched to the user session.
• OKC_RULE_GROUPS_B — the rule group (aliased RGP_LAFEXP), filtered by rgd_code = 'LAFEXP'.
• OKC_RULES_B — used twice, as RUL_LAFREQ (rule_information_category = 'LAFREQ') and as RUL_LAFEXP (rule_information_category = 'LAFEXP').
• OKC_LINE_STYLES_B — line style definition (aliased LNSTYLE).
• OKL_TIME_UNITS_V — a view providing the frequency unit-of-measure name (aliased TUOM).

All rule-related joins and the time-unit join are outer joins (denoted by (+)), so a service line is returned even when no LAFEXP rule group or LAFREQ rule exists. The join to MTL_SYSTEM_ITEMS_TL and the line-style filter are inner joins, and the presence of LTY_CODE='SOLD_SERVICE' in the WHERE clause restricts output to sold-service lines.

Key Columns

• cleb_svc_id, dnz_chr_id, cim_svc_id — line identifier, contract header identifier, and contract item identifier, returned as character strings via TO_CHAR.
• cim_svc_name, cim_svc_object1_id1, cim_svc_object1_id2, cim_svc_object1_code — the item description and the item's object reference (inventory item id, organization id, and object code).
• start_date, end_date — the service line period from OKC_K_LINES_B.
• amount — the service line amount from OKL_K_LINES.
• attribute_category, attribute1–attribute15 — the service line descriptive flexfield context and segment values.
• rgp_lafexp_id — identifier of the LAFEXP rule group; null where no such group exists.
• rul_lafreq_id, rul_lafreq_object1_id1, rul_lafreq_object1_id2, rul_lafreq_object1_code — the frequency rule identifier and its referenced object.
• frequency_name — the time-unit name resolved from OKL_TIME_UNITS_V.
• rul_lafexp_id, rule_information1, rule_information2 — the LAFEXP rule identifier and its rule information payload.
• An additional to_char(lnstyle.id) column exposes the line style identifier.

Common Use Cases and Queries

The view is typically used to report sold-service lines with their lease accounting frequency and expense rules, and to supply integration extracts. A representative query returns the core identifiers, amount, frequency name, and rule information:

SELECT cleb_svc_id, dnz_chr_id, cim_svc_name,
       start_date, end_date, amount,
       frequency_name, rul_lafexp_id, rgp_lafexp_id
FROM   apps.okl_la_service_lines_uv
WHERE  dnz_chr_id = :p_contract_id;

Because the rule joins are outer, a query that filters on rule data still returns lines lacking rules when the predicate targets the outer-joined columns. To audit which service lines carry a LAFREQ frequency rule versus those without, use:

SELECT cleb_svc_id, cim_svc_name, frequency_name
FROM   apps.okl_la_service_lines_uv
WHERE  rul_lafreq_id IS NULL
ORDER  BY cleb_svc_id;

For extracts that mirror the underlying lease accounting setup, selecting the flexfield attributes alongside the LAFEXP rule information provides a single-row-per-line feed suitable for concurrent programs or interfaces.