Results for “ilt_ilt_uk”

6 results




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

Overview

OKL_INVC_LINE_TYPES_B is a foundational setup table in the OKL (Lease and Finance Management) product of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It defines the "type" of an invoice line — the classification under which transactions, stream types, and cash flows are grouped when an invoice is generated. Invoice line types therefore act as the controlling taxonomy that determines how lease accounting events are aggregated, presented, and posted to downstream receivables and general ledger processes.

The table resides in the OKL schema and carries 25 documented columns in the 12.2.2 physical schema. Its structure follows the standard EBS multilingual (_B) base-table convention: the _B table holds language-independent setup rows, with translated descriptive columns typically held in a corresponding _TL table. Heuristic Data Vault classification derived from the foreign-key structure identifies this object as hub-leaning, meaning it is best modeled as a reference or hub entity — a stable, uniquely keyed business concept referenced by transactional and configuration tables — rather than as a link or satellite.

Key Information Stored

The most important columns are the identifiers and the standard EBS auditing and extension attributes:

  • ID — the surrogate primary key of the table. The unique index OKL_INVC_LINE_TYPES_B_U1 enforces uniqueness on this column, and it is the value referenced by all child foreign keys.
  • ITY_ID — foreign key to OKL_INVOICE_TYPES_B, associating each invoice line type with its parent invoice type. This column participates in the ILT_ILT_UK unique index, making the combination of ID and ITY_ID a documented business-key candidate.
  • SEQUENCE_NUMBER — controls the display or processing order of invoice line types within their invoice type grouping.
  • OBJECT_VERSION_NUMBER — the standard EBS optimistic-locking column, incremented on each row update to prevent concurrent-update conflicts.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flexfield-style descriptive columns available for customer-specific extension without schema modification.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the audit columns recording who created and last modified each row, and when.

Because the _B table carries no language-dependent name column in the documented column list, descriptive text is expected to be sourced from the corresponding translated table.

Common Use Cases and Queries

Typical scenarios include listing the valid invoice line types for a given invoice type, validating configuration during implementation, and joining line types to invoice formats or consolidated receivables lines for reporting. A representative query joining to the parent invoice type is:

SELECT ilt.ID, ilt.ITY_ID, ilt.SEQUENCE_NUMBER
FROM OKL.OKL_INVC_LINE_TYPES_B ilt, OKL.OKL_INVOICE_TYPES_B it
WHERE ilt.ITY_ID = it.ID
ORDER BY ilt.ITY_ID, ilt.SEQUENCE_NUMBER;

To identify which invoice formats and consolidated receivable lines reference each line type, union or join the child tables on ILT_ID:

SELECT f.ILT_ID, f.ID AS FORMAT_ID
FROM OKL.OKL_INVOICE_FORMATS_B f
WHERE f.ILT_ID = :p_ilt_id;

From a reporting standpoint, the audit and OBJECT_VERSION_NUMBER columns support change-tracking and concurrency diagnostics, while the ATTRIBUTE columns support customer-specific reporting extensions.

Related Objects

The following objects are the most significant participants in this table's relationship network:

  • OKL_INVOICE_TYPES_B — parent table referenced by OKL_INVC_LINE_TYPES_B.ITY_ID, grouping line types under an invoice type.
  • OKL_INVOICE_FORMATS_B — references OKL_INVC_LINE_TYPES_B.ILT_ID, defining invoice formats per line type.
  • OKL_INV_FORMATS_ALL_B — also references OKL_INVC_LINE_TYPES_B.ILT_ID, providing the all-organization view of invoice formats.
  • OKL_CNSLD_AR_LINES_B — references OKL_INVC_LINE_TYPES_B.ILT_ID, holding consolidated receivables lines that inherit the line type classification.

Together these relationships establish OKL_INVC_LINE_TYPES_B as the central reference point connecting invoice types, invoice formats, and consolidated receivables processing within Lease and Finance Management.