Search Results asset_category_name




Overview
Explore in AI Chat

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

Overview

The OKL_EXT_AP_LINE_SOURCES_B table is a Payables transactions line extension table within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Leasing and Finance Management (OKL) product module. It stores supplementary, lease-specific descriptive information about individual lines that are destined for or derived from Oracle Payables transactions. The suffix _B denotes that this is a base table, typically paired with a corresponding _TL translation table for any user-enterable multilingual columns. The table is owned by the OKL schema and carries a VALID status in the ETRM data dictionary.

The object functions as an extension surface: it augments the standard Payables line structure with leasing attributes such as asset identity, stream type, accounting template, and vendor context. Relationships to header-level extension data, contract lines, stream types, and suppliers confirm its role as a connector between lease contracts and their financial disbursement lines. From a heuristic Data Vault modeling perspective, the metadata suggests this object behaves as a link, since its structure comprises foreign keys pointing outward to multiple parent hubs (contract lines, stream types, suppliers) and a header extension table, rather than acting as a standalone descriptive satellite.

Key Information Stored

The table is physically defined with 43 columns. The following are the most significant:

Common Use Cases and Queries

Typical scenarios include reconciling lease contract lines with Payables invoice lines, reporting on asset acquisition by vendor, and validating that stream types and accounting templates are correctly propagated.

A common pattern joins this table to its header and contract line parents:

  • Query lines by contract: join OKL_EXT_AP_LINE_SOURCES_B to OKC_K_LINES_B on KLE_ID and filter by contract or line number.
  • Aggregate asset purchases: join to AP_SUPPLIERS on ASSET_VENDOR_ID to report spend by vendor.
  • Stream reporting: join to OKL_STRM_TYPE_B on STY_ID, or use the denormalized STREAM_TYPE_CODE directly.
  • Source tracing: filter on SOURCE_ID and SOURCE_TABLE to locate the originating record.
  • Flexfield reporting: select LINE_ATTRIBUTE_CATEGORY with the relevant LINE_ATTRIBUTEn columns.

Related Objects

  • OKL_EXT_AP_HEADER_SOURCES_B — parent header extension table, joined via HEADER_EXTENSION_ID.
  • OKC_K_LINES_B — contract line base table, joined via KLE_ID.
  • OKL_STRM_TYPE_B — stream type definition table, joined via STY_ID.
  • AP_SUPPLIERS — Oracle Payables supplier table, joined via ASSET_VENDOR_ID.
  • AP_INVOICE_LINES_ALL — the Payables line table that ultimately consumes or reconciles this extension data (lineage association).
  • OKL_EXT_AP_LINE_SOURCES_TL — translation table paired with the _B base table.