Results for “book_basis_percent”

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

Overview

OKL_SIF_LINES_V is a reporting view owned by the APPS schema within the Oracle Leasing and Finance Management (OKL) module. The view holds asset line details used for external pricing, and in EBS 12.1.1 and 12.2.2 it functions primarily as an inbound stream interface construct. Stream interfaces in OKL support the pricing of complex lease contracts by passing asset-level and depreciation attributes to an external pricing engine, then receiving the priced streams back to generate the contract terms. Because this view is keyed to asset lines rather than to a single contract header, it is often queried during troubleshooting scenarios involving pricing failures, stream generation errors, and asset-level depreciation data validation. The view's name reflects its role: "SIF" denotes Stream Interface, and "LINES" indicates the granularity is at the asset line level rather than at the stream level.

Underlying Base Objects

According to ETRM metadata for 12.2.2, the view is defined over a single referenced base object identified as OKL_SIF_LINES, exposed through a synonym in the APPS schema. The packaged view text confirms this, since every projection references the alias SILB, which corresponds to OKL_SIF_LINES. The view is a straightforward one-to-one projection of the base table, selecting a subset of columns rather than performing joins or aggregations. It exposes additional stream interface aggregate columns, STREAM_INTERFACE_ATTRIBUTE01 through STREAM_INTERFACE_ATTRIBUTE08, which are not exposed on the source table in the documented excerpt but appear here for downstream consumer convenience. The ROWID of the base row is exposed as ROW_ID, and the base primary key is exposed as ID.

Key Columns

Given the user search term "fed_depre_method," the column of immediate interest is FED_DEPRE_METHOD, which carries the federal depreciation method associated with the asset line and is essential to the external pricing calculation. Related federal columns include FED_DEPRE_TERM, FED_DEPRE_SALVAGE, FED_DEPRE_BASIS_PERCENT, FED_DEPRE_DMNSHING_VALUE_RATE, FED_DEPRE_ADR_CONVE, and DATE_FED_DEPRE. Parallel state-level attributes are exposed as STATE_DEPRE_METHOD, STATE_DEPRE_TERM, STATE_DEPRE_SALVAGE, STATE_DEPRE_BASIS_PERCENT, STATE_DEPRE_ADR_CONVENT, STATE_DEPRE_DMNSHING_VALUE_RT, and DATE_STATE_DEPRE, and book-level attributes as BOOK_METHOD, BOOK_TERM, BOOK_SALVAGE, BOOK_BASIS_PERCENT, BOOK_ADR_CONVENTION, and BOOK_DEPRE_DMNSHING_VALUE_RT. Financial and timing values include ASSET_COST, RESIDUAL_AMOUNT, RESIDUAL_GUARANTEE_METHOD, RESIDUAL_GUARANTEE_AMOUNT, PURCHASE_OPTION, DATE_DELIVERY, DATE_FUNDING, and DATE_BOOK.

Common Use Cases and Queries

The view is typically used when diagnosing pricing behaviour on a lease, verifying that federal depreciation attributes are populated correctly before the pricing call is made, and reconciling asset line data returned from the external pricing service. The following query locates all line records associated with a specific contract and displays the federal depreciation method alongside related federal attributes.

• SELECT id, fed_depre_method, fed_depre_term, fed_depre_salvage, fed_depre_basis_percent, asset_cost FROM okl_sif_lines_v WHERE id = :p_line_id;
• SELECT id, fed_depre_method, state_depre_method, book_method FROM okl_sif_lines_v WHERE fed_depre_method IS NULL;
• SELECT id, fed_depre_method, date_fed_depre, date_delivery, date_funding FROM okl_sif_lines_v WHERE date_fed_depre > SYSDATE - 30;

Queries against this view should be executed with the APPS credentials or through a synonym granted to the calling schema. Because the view is defined only over OKL_SIF_LINES, no joins to OKL head or stream tables are required to reach the columns listed above; contract-level context is obtained separately by joining ID back to the appropriate stream interface header table. When querying in a multi-org or multi-lease context, filter by the ID or ROW_ID value already known to the caller rather than relying on a contract number column, which is not exposed here.