Results for “jtot_object_code_new”

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

Overview

OKL_TXL_ITM_INSTS is a contract-line-level transaction table within the Oracle Lease and Finance Management (OKL) module. Its documented purpose is to record Install Base Module location attributes of an asset that the Install Base Module requires before a contract can be activated. In practical terms, the table bridges leasing contract data and Oracle Install Base / Inventory asset tracking by staging the physical and organizational attributes of leased items at the contract line granularity.

The object is owned by the OKL schema and resides in the ETRM (Enterprise Transaction Repository Model) layer, which consolidates transactional leasing structures for reporting and integration. The table carries 44 documented columns and is classified under a heuristic Data Vault modeling suggestion as a link entity. This classification reflects its role as an associative structure joining contract-lines, Install Base instances, and asset definitions rather than storing descriptive attributes of a single business entity.

Key Information Stored

The primary key of the table is the surrogate column ID, enforced by the constraint OKL_TXL_ITM_INSTS_PK and additionally supported by the unique index OKL_TXL_ITM_INSTS_U1 on the same column. ID is the sole documented business-key candidate; no composite natural key is defined in the metadata.

The most significant columns include:

• TAS_ID — foreign key to OKL_TRX_ASSETS, anchoring the record to the transaction asset.
• ASD_ID — foreign key to OKL_TXD_ASSETS_B, tying the row to the asset definition/master record.
• INSTANCE_ID — foreign key to CSI_ITEM_INSTANCES, linking the contract line to the Install Base item instance.
• TAL_ID — foreign key to OKL_TAL_TCL_MAP_T, associating the line with the transaction-line mapping.
• KLE_ID, TAL_TYPE, and LINE_NUMBER — identify the contract-line context of the record.
• INSTANCE_NUMBER_IB and SERIAL_NUMBER — human-readable identifiers for the tracked item in Install Base.
• INVENTORY_ITEM_ID, INVENTORY_ORG_ID, and INV_MASTER_ORG_ID — item and organization context required by Install Base.
• OBJECT_ID1_NEW, OBJECT_ID2_NEW, JTOT_OBJECT_CODE_NEW and the corresponding _OLD columns — capture the pre- and post-change object identifiers, supporting change tracking of asset location attributes.
• SELECTED_FOR_SPLIT_FLAG and DNZ_CLE_ID — control flags for contract splitting and downstream processing.
• ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive flexfield segment columns.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard concurrency and audit columns.

Common Use Cases and Queries

Typical usage centers on pre-activation validation and reconciliation between OKL contracts and Oracle Install Base. A recurring query pattern joins the table to CSI_ITEM_INSTANCES to confirm that instance attributes match the contract line before activation:

• Listing records pending Install Base activation by filtering on TAS_ID and INSTANCE_ID.
• Comparing OBJECT_ID1_NEW / OBJECT_ID2_NEW with the _OLD equivalents to audit asset location changes.
• Reporting by INVENTORY_ORG_ID or INV_MASTER_ORG_ID to summarize leased assets per inventory organization.
• Joining to OKL_TRX_ASSETS and OKL_TXD_ASSETS_B to produce asset-level lease reports.

A representative SQL skeleton is:

SELECT t.ID, t.TAS_ID, t.INSTANCE_ID, t.SERIAL_NUMBER FROM OKL.OKL_TXL_ITM_INSTS t WHERE t.TAS_ID = :p_tas_id;

Related Objects

Based on the documented foreign key relationships, the principal related objects are:

• OKL_TRX_ASSETS — joined via OKL_TXL_ITM_INSTS.TAS_ID.
• OKL_TXD_ASSETS_B — joined via OKL_TXL_ITM_INSTS.ASD_ID.
• CSI_ITEM_INSTANCES — joined via OKL_TXL_ITM_INSTS.INSTANCE_ID.
• OKL_TAL_TCL_MAP_T — joined via OKL_TXL_ITM_INSTS.TAL_ID.

These dependencies confirm the table's role as a link between leasing contract-line data and the Oracle Install Base asset instance framework.