Results for “okl_cnsld_ar_lines_b”

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

Overview

OKL_CNSLD_AR_LINES_B is a transactional table in the Oracle Leasing and Finance Management (OKL) module, owned by the OKL schema. It stores the detail lines that make up a consolidated invoice within Oracle E-Business Suite 12.1.1 and 12.2.2. Consolidated invoicing allows multiple contract or lease transactions to be grouped into a single receivable invoice presented to a customer; this table holds each individual line item that rolls up into that consolidated document. It therefore sits at the intersection of contract billing, lease accounting, and receivables generation.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It carries descriptive measures and attributes (amounts, tax amounts, line types) attached to parent business keys, rather than acting as an independent hub. Analysts designing a warehouse layer should treat OKL_CNSLD_AR_LINES_B as an effect or detail satellite hanging off the consolidated invoice and contract header structures, retaining the request/program and audit columns for change tracking.

Key Information Stored

The table contains 37 documented columns. The most significant are:

• ID — the surrogate primary key, enforced by OKL_CNSLD_AR_LINES_B_PK and mirrored by unique index OKL_CNSLD_AR_LINES_B_U1. This is the single business-key candidate and the column referenced by downstream tables.
• LLN_ID_PARENT — self-referencing parent line, supporting hierarchical or nested line structures within the consolidated invoice.
• KHR_ID — foreign key to OKL_K_HEADERS, tying the line to its contract/lease header.
• KLE_ID — foreign key to OKL_K_LINES, linking the consolidated AR line back to the originating contract line.
• CNR_ID — foreign key identifying the consolidated invoice the line belongs to.
• ILT_ID — foreign key to OKL_INVC_LINE_TYPES_B, defining the line type.
• LINE_TYPE — the descriptive line category used for grouping and reporting.
• AMOUNT and TAX_AMOUNT — the core financial measures for the line.
• SEQUENCE_NUMBER — ordering of lines within the consolidated document.
• ORG_ID — multi-org operating unit discriminator.
• ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield columns.
• OBJECT_VERSION_NUMBER — optimistic locking for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit Who columns, alongside REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE for concurrent program provenance.

Common Use Cases and Queries

Typical usage centers on reconciling consolidated invoices to contract lines and validating line amounts against receipts applied. A reporting pattern joins the line to its contract header and line to reproduce the invoice composition:

SELECT cl.id, cl.sequence_number, cl.line_type, cl.amount, cl.tax_amount
FROM okl.okl_cnsld_ar_lines_b cl
WHERE cl.cnr_id = :p_consolidated_invoice_id
AND cl.org_id = :p_org_id
ORDER BY cl.sequence_number;

To trace a line to its originating contract line: ... FROM okl_cnsld_ar_lines_b cl, okl_k_lines kl WHERE cl.kle_id = kl.kle_id. For receipt application analysis, join to OKL_TXL_RCPT_APPS_B on LLN_ID. Hierarchical reporting uses LLN_ID_PARENT in a recursive (CONNECT BY) query to reconstruct parent/child line groupings.

Related Objects

• OKL_K_HEADERS — joined via KHR_ID; provides the contract/lease header context.
• OKL_K_LINES — joined via KLE_ID; the source contract lines.
• OKL_INVC_LINE_TYPES_B — joined via ILT_ID; line type definitions.
• OKL_CNSLD_AR_LINES_B (self) — joined via LLN_ID_PARENT for line hierarchy.
• OKL_CNSLD_AR_STRMS_B — references this table via LLN_ID; streams/schedules for each line.
• OKL_TXL_RCPT_APPS_B and OKL_TXL_RCPT_APPS_ALL_B — reference this table via LLN_ID; receipt application details.

Together these relationships make OKL_CNSLD_AR_LINES_B the central detail object for consolidated lease invoicing, connecting contract data, line definitions, receipt applications, and stream schedules.