Search Results rul_lafreq_id




Overview
Explore in AI Chat

Overview

OKL_LA_SERVICE_LINES_UV is an APPS-owned database view within the Oracle Lease and Finance Management (OKL) module. It presents a denormalized, user-facing projection of service line data associated with lease contracts, joining contract line, contract item, inventory item, rule group, rule, and time-unit information into a single queryable structure. Its primary role is to expose service line attributes — including originating item references, validity dates, monetary amounts, descriptive flexfield attributes, and the associated lease accounting frequency and expense rules — without requiring downstream consumers to navigate the normalized OKC and OKL base tables individually.

The view is STATUS VALID and is documented as implemented under the APPS schema in ETRM 12.1.1 and 12.2.2. Because it is a view rather than a table, it holds no data of its own; it is refreshed on query against its underlying objects. It is commonly consumed by reporting tools, custom concurrent programs, and integration extracts that require service line detail together with lease accounting rule context.

Underlying Base Objects

The view is defined over eight documented base objects, referenced as synonyms from APPS:

All rule-related joins are outer joins, ensuring service lines without defined frequency or expense rules still appear in the result set.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling service lines against inventory items, extracting lease frequency rules for accounting interfaces, and auditing flexfield attribute values on service lines.

To retrieve all service lines for a given contract with their frequency rule:

  • SELECT cleb_svc_id, cim_svc_name, amount, rul_lafreq_id, frequency_name FROM okl_la_service_lines_uv WHERE dnz_chr_id = :p_contract_id;

To find service lines that have a LAFREQ rule but no resolved frequency name:

  • SELECT cleb_svc_id, rul_lafreq_id FROM okl_la_service_lines_uv WHERE rul_lafreq_id IS NOT NULL AND frequency_name IS NULL;

To locate lines by frequency rule identifier:

  • SELECT dnz_chr_id, cleb_svc_id, rul_lafreq_id FROM okl_la_service_lines_uv WHERE rul_lafreq_id = :p_rule_id;

Because the rule joins are outer joins, filters on RUL_LAFREQ_ID in the WHERE clause effectively convert the query to an inner join, restricting results to lines that carry a frequency rule.