Search Results cim_svc_object1_id1

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:

• OKC_K_LINES_B — supplies the core contract line record, aliased CLEB_SVC, providing the line ID, the contract header ID (DNZ_CHR_ID), and the service start and end dates.
• OKL_K_LINES — the OKL extension of the contract line, aliased KLE_SVC, contributing AMOUNT and Attribute1 through Attribute15.
• OKC_K_ITEMS — aliased CIM_SVC, providing the item reference (OBJECT1_ID1 and OBJECT1_ID2) and the JTOT object code, filtered to 'OKX_SERVICE'.
• MTL_SYSTEM_ITEMS_TL — aliased MSIT, joined on inventory item ID and organization ID to supply the translated item DESCRIPTION, restricted to the user's session language.
• OKC_RULE_GROUPS_B — aliased RGP_LAFEXP, outer-joined on contract header and line with RGD_CODE 'LAFEXP'.
• OKC_RULES_B — used twice, as RUL_LAFREQ (RULE_INFORMATION_CATEGORY 'LAFREQ') and RUL_LAFEXP (RULE_INFORMATION_CATEGORY 'LAFEXP'), sharing the same rule group ID.
• OKL_TIME_UNITS_V — aliased TUOM, providing the frequency name.
• OKC_LINE_STYLES_B — aliased LNSTYLE, providing the line style ID.

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

Key Columns

• CLEB_SVC_ID / DNZ_CHR_ID — the contract line ID and contract header ID, forming the primary linkage back to the lease.
• CIM_SVC_ID, CIM_SVC_NAME, CIM_SVC_OBJECT1_ID1/ID2, CIM_SVC_OBJECT1_CODE — the service item identity, its inventory item and organization reference, and the OKX_SERVICE object code.
• START_DATE / END_DATE — the effective service period on the contract line.
• AMOUNT — the line amount from OKL_K_LINES.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the descriptive flexfield context and values for the service line.
• RUL_LAFREQ_ID, RUL_LAFREQ_OBJECT1_ID1/ID2, RUL_LAFREQ_OBJECT1_CODE, FREQUENCY_NAME — the lease accounting frequency rule and its lookup-derived name. RUL_LAFREQ_ID is the column most frequently targeted by the search term "rul_lafreq_id".
• RGP_LAFEXP_ID, RUL_LAFEXP_ID, RULE_INFORMATION1, RULE_INFORMATION2 — the lease accounting expense rule group and rule with its free-form rule information.

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.