Search Results okl_cnsld_ar_lines_b

Overview

The table OKL_CNSLD_AR_LINES_B is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the primary repository for line-level detail of consolidated invoices. In the context of leasing operations, a consolidated invoice aggregates multiple billing streams or charges from a contract into a single, unified customer invoice. This table is fundamental to the billing and accounts receivable processes, enabling the system to track individual line items—such as rent, interest, fees, or taxes—that comprise the final invoice sent to the lessee. Its role is critical for maintaining the granular financial data necessary for accurate revenue recognition, customer statements, and audit trails.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's primary key and foreign key relationships define its essential structure. The primary key is the ID column, uniquely identifying each consolidated invoice line. The table stores foreign key references that link each line to its associated master records. These include the CNR_ID (linking to the consolidated invoice header), the KHR_ID (linking to the lease contract header in OKL_K_HEADERS), and the KLE_ID (linking to the specific contract line in OKL_K_LINES). It also holds an ILT_ID to reference the invoice line type from OKL_INVC_LINE_TYPES_B, defining the nature of the charge. A self-referencing relationship via LLN_ID_PARENT supports hierarchical line structures, such as a parent line for a charge with child lines for associated tax calculations.

Common Use Cases and Queries

A primary use case is generating detailed invoice reports or troubleshooting billing discrepancies. Financial analysts may query this table to analyze the composition of invoices for a specific lease contract or period. A common reporting pattern involves joining to the contract and header tables to retrieve a full invoice view. For instance, to list all lines for a consolidated invoice, one might use a query such as: SELECT * FROM OKL.OKL_CNSLD_AR_LINES_B WHERE CNR_ID = <invoice_header_id> ORDER BY ID;. Another critical scenario is during month-end close, where accounting teams might aggregate line amounts by type (via the ILT_ID) for revenue and receivable reconciliations. The table is also central to processes that apply cash receipts or tax calculations to specific invoice lines, as indicated by its relationship with OKL_TXL_RCPT_APPS_B.

Related Objects

OKL_CNSLD_AR_LINES_B is centrally connected to numerous other EBS tables through documented foreign key relationships. Key related objects include:

• OKL_CNSLD_AR_STRMS_B: Linked via LLN_ID, this table stores the detailed payment streams associated with each invoice line.
• OKL_K_HEADERS (KHR_ID): The master lease contract header.
• OKL_K_LINES (KLE_ID): The specific line item from the lease contract being invoiced.
• OKL_INVC_LINE_TYPES_B (ILT_ID): The type definition for the invoice line (e.g., Rent, Service Fee).
• OKL_TXL_RCPT_APPS_B / OKL_TXL_RCPT_APPS_ALL_B (LLN_ID): Track applications of tax payments and cash receipts against this specific invoice line.
• Self-Reference (LLN_ID_PARENT): Enables a parent-child hierarchy within the invoice lines themselves.

These relationships underscore the table's integral position in the leasing module's data model, connecting contract terms, billing calculations, and financial applications.