Search Results okl_asset_returns_all_b




Overview
Explore in AI Chat

Overview

The OKL_ASSET_RETURNS_ALL_B table is a core transaction table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for managing the disposition of assets that are no longer under lease. This occurs primarily following the termination of a contract or when assets have been preliminarily identified as candidates for return. The table facilitates the operational and financial tracking of these off-lease assets throughout the return process, which may involve inspection, refurbishment, sale, or return to inventory. Its multi-org structure, indicated by the "_ALL_B" suffix, supports implementations across multiple operating units.

Key Information Stored

The table's primary key is the ID column, which uniquely identifies each asset return record. Its structure is defined by critical foreign key relationships that link it to other master and transactional entities within EBS. The KLE_ID column establishes a link to the OKL_K_LINES table, connecting the returned asset to its specific lease line. The IMR_ID column references the MTL_SYSTEM_ITEMS_B table, identifying the inventory item master for the physical asset. For organizational context, the ORG_ID column ties the record to an operating unit. Additional key columns include RMR_ID, linking to the JTF_RS_TEAMS_B table for resource team management, and SECURITY_DEP_TRX_AP_ID, which references the OKL_TRX_AP_INVS_ALL_B table to associate any related security deposit or accounts payable transactions.

Common Use Cases and Queries

This table is central to post-termination asset lifecycle management. Common use cases include generating reports on all assets off-lease from terminated contracts within a date range, tracking the status of assets pending inspection or disposition, and reconciling financial transactions related to asset returns. A typical analytical query might join this table to lease lines and item master data to list returned assets by product category.

SELECT ar.id AS return_id,
       ar.kle_id,
       kl.line_number,
       msi.segment1 AS item_code,
       ar.creation_date
  FROM okl.okl_asset_returns_all_b ar,
       okl.okl_k_lines kl,
       inv.mtl_system_items_b msi
 WHERE ar.kle_id = kl.id
   AND ar.imr_id = msi.inventory_item_id
   AND msi.organization_id = <org_id>
   AND ar.creation_date BETWEEN :p_start_date AND :p_end_date;

Operational processes, such as initiating the asset return workflow or creating related AP invoices for charges/refunds, will also query and update records in this table.

Related Objects

OKL_ASSET_RETURNS_ALL_B is a hub within a network of related EBS objects. Its primary dependencies, as defined by its foreign keys, include:

  • OKL_K_LINES: The source lease line detail for the returned asset.
  • MTL_SYSTEM_ITEMS_B: The inventory definition and item master data.
  • JTF_RS_TEAMS_B: The team responsible for managing the return process.
  • OKL_TRX_AP_INVS_ALL_B (via ART_ID): Related accounts payable invoice transactions, often for security deposit settlements.

Furthermore, the table is referenced by its primary key constraint (OKL_ASSET_RETURNS_ALL_B_PK) and is likely accessed by various OKL APIs, concurrent programs, and user interfaces within the Lease Management module to drive the asset return business flow.