Results for “termination_quote_type”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_SLA_TRX_INFO_V is an APPS-owned database view in the OKL (Leasing and Finance Management) product family. It is a subledger accounting (SLA) transaction information view whose stated purpose is to expose user-facing transaction identifiers for leasing transactions originating in Oracle Lease and Finance Management. In the EBS 12.1.1 and 12.2.2 architectures, this view serves as a bridge between the operational leasing tables and the Subledger Accounting engine, supplying the descriptive attributes that SLA uses when constructing accounting event entries, journal line descriptions, and reconciliation reports.
The view resolves a single row per leasing transaction drawn from OKL_TRX_CONTRACTS_ALL, enriched with contract, product, customer, currency, and quotation context. It is a reporting convenience layer: rather than joining seven or more operational tables manually, consumers query this view to obtain a denormalized transaction profile. Because the underlying data is transactional and not date-effective in the traditional key-flexfield sense, the view is most valuable for ad hoc operational reporting, SLA diagnostics, and integration extracts.
The user search term "cancellation_date" maps directly to the CANCELED_DATE column of OKL_TRX_CONTRACTS_ALL, aliased in this view as CANCELLATION_DATE. This is the view's principal mechanism for surfacing whether and when a leasing transaction was cancelled.
Underlying Base Objects
The documented referenced base objects are FND_GLOBAL (package), FND_LOOKUPS (view), HZ_CUST_ACCOUNTS, HZ_PARTIES, OKC_K_HEADERS_ALL_B, OKC_K_PARTY_ROLES_B, OKL_K_HEADERS, OKL_PRODUCTS, OKL_TRX_CONTRACTS_ALL, and OKL_TRX_QUOTES_ALL_B. The view text confirms these relationships:
- OKL_TRX_CONTRACTS_ALL (TCN) is the driving table, supplying ID, CURRENCY_CODE, TRX_NUMBER, DATE_TRANSACTION_OCCURRED, and CANCELED_DATE (aliased CANCELLATION_DATE).
- OKC_K_HEADERS_ALL_B (CHR) joins via TCN.KHR_ID = CHR.ID and provides CONTRACT_NUMBER, plus SCS_CODE used to classify investor versus lease contracts.
- OKL_K_HEADERS (KHR) links the contract header to OKL_PRODUCTS (PDT) for PRODUCT_NAME and supplies SECURITIZATION_TYPE.
- OKC_K_PARTY_ROLES_B and HZ_PARTIES/HZ_CUST_ACCOUNTS supply the LESSEE customer name and account number, restricted to PERSON or ORGANIZATION party types.
- OKL_TRX_QUOTES_ALL_B (TERM) provides the termination quote number.
- FND_LOOKUPS is outer-joined twice for investor agreement type and termination quote type meanings.
FND_GLOBAL appears in the referenced-object list, consistent with standard APPS view definitions that inherit security context.
Key Columns
- ID — Primary transaction identifier from OKL_TRX_CONTRACTS_ALL.
- CONTRACT_NUMBER — Lease or investor contract number, populated conditionally via DECODE on SCS_CODE.
- PRODUCT_NAME — Leasing product associated with the contract header.
- CUSTOMER_NAME / CUSTOMER_ACCOUNT — Lessee party name and receivable account number.
- CURRENCY_CODE, TRANSACTION_NUMBER, TRANSACTION_DATE — Core transaction attributes.
- CANCELLATION_DATE — The cancellation timestamp, mapped from OKL_TRX_CONTRACTS_ALL.CANCELED_DATE; NULL when the transaction remains active.
- INVESTOR_AGREEMENT_TYPE, TERMINATION_QUOTE_NUMBER, TERMINATION_QUOTE_TYPE — Securitization and termination-quote lookup meanings.
Common Use Cases and Queries
A frequent scenario is identifying cancelled leasing transactions for reconciliation or SLA reversal analysis:
SELECT transaction_number, contract_number, customer_name, cancellation_date FROM okl_sla_trx_info_v WHERE cancellation_date IS NOT NULL;SELECT contract_number, customer_account, currency_code, transaction_date FROM okl_sla_trx_info_v WHERE customer_account = :p_account;SELECT investor_agreement_type, COUNT(*) FROM okl_sla_trx_info_v GROUP BY investor_agreement_type;
Because the view is not indexed, filter predicates on CANCELLATION_DATE or TRANSACTION_DATE are pushed to the base transaction table; performance-sensitive extracts should therefore constrain by transaction date range or contract number wherever possible.
-
View: OKL_SLA_TRX_INFO_V 12.2.2
Transaction object for user transaction identifiers.
APPS.OKL_SLA_TRX_INFO_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
View: OKL_SLA_TRX_INFO_V 12.1.1
Transaction object for user transaction identifiers.
APPS.OKL_SLA_TRX_INFO_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore OKL module →
-
eTRM - OKL Tables and Views 12.1.1
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards
-
eTRM - OKL Tables and Views 12.2.2
Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards