Results for “sec_type_code”

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

Overview

OKL_SEC_AGREEMENTS_UV is a user interface view owned by the APPS schema in Oracle E-Business Suite, defined within the OKL (Lease and Finance Management) product family. In Oracle EBS 12.1.1 and 12.2.2 it serves as the presentation-layer query object that surfaces securitization agreements — the contractual structures through which lease and finance receivables are pooled, sold, or otherwise transferred to a securitization vehicle. The view does not hold data of its own; it is a denormalized projection that joins the central contract header tables in OKC with the securitization-specific extension table OKL_K_HEADERS, together with descriptive lookup and vendor sources, producing a flat, human-readable record set for forms, concurrent programs, OAF pages, and ad hoc reporting.

Because the object is a view rather than a table, it provides read-only access and inherits the security and row-level behavior of its base objects. It is commonly referenced when users need to reconcile agreement-level attributes such as status, currency, product, pool, and trustee details without navigating multiple EBS windows. The presence of the AFTER_TAX_YIELD column makes the view particularly relevant for analyzing the economic return of securitized portfolios, since after-tax yield is a core metric in securitization structuring and investment appraisal.

Underlying Base Objects

The documented definition joins the following base objects: OKC_K_HEADERS_B (synonym) supplies the contract/agreement header and start, end, and approval dates; OKC_K_HEADERS_TL supplies the translated short description used as the note; OKC_STATUSES_B and OKC_STATUSES_TL provide status codes and their meanings; OKL_K_HEADERS (synonym) is the securitization extension carrying securitization type, recourse code, lessor servicing organization, currency conversion attributes, after-tax yield, and the DFF attribute columns; OKL_PRODUCTS and OKL_POOLS_ALL deliver product and pool context; FND_CURRENCIES_VL yields currency code and name; three FND_LOOKUPS aliases (SECL, SERL, RECL) resolve the securitization type, lessor servicing organization, and recourse meanings; OKC_K_PARTY_ROLES_B exposes the trustee role with its OBJECT1_ID1/ID2 keys; and OKX_VENDORS_V resolves the trustee name. FND_GLOBAL is also referenced in the implementation metadata for session context.

Key Columns

• ID / AGREEMENT_NUMBER — internal header ID and the user-facing contract number.
• START_DATE, END_DATE, DATE_APPROVED — agreement lifecycle dates.
• STS_CODE / STATUS — status code and translated meaning.
• CURRENCY_CODE / CURRENCY — functional currency of the agreement.
• PDT_ID / PRODUCT_NAME, POL_ID / POOL_NUMBER — product and pool identifiers.
• SEC_TYPE_CODE / SEC_TYPE — securitization type code and meaning.
• RECOURSE_CODE / RECOURSE — recourse classification.
• LESSOR_SERV_ORG_CODE / LESSOR_SERV_ORG — servicing organization.
• CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — conversion inputs.
• AFTER_TAX_YIELD — the after-tax yield recorded on the securitization header; the column matching the search term.
• CPL_TRUSTEE_ID, TRUSTEE_ID1, TRUSTEE_ID2, TRUSTEE_NAME — trustee party identification and vendor name.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — descriptive flexfield context and segments.
• LEGAL_ENTITY_ID — owning legal entity from OKL_POOLS_ALL.

Common Use Cases and Queries

Typical scenarios include portfolio yield analysis, recourse exposure reporting, trustee/vendor reconciliation, currency conversion review for cross-border securitizations, and status tracking across agreements. A representative query to retrieve agreements with their after-tax yield is:

• SELECT agreement_number, sec_type, recourse, after_tax_yield FROM apps.okl_sec_agreements_uv WHERE after_tax_yield IS NOT NULL;
• SELECT agreement_number, status, currency, pool_number, after_tax_yield FROM apps.okl_sec_agreements_uv WHERE start_date >= :p_from_date — filtered yield report by period.
• SELECT sec_type, AVG(after_tax_yield) FROM apps.okl_sec_agreements_uv GROUP BY sec_type — average yield by securitization type.
• SELECT agreement_number, trustee_name, legal_entity_id FROM apps.okl_sec_agreements_uv WHERE recourse = :p_recourse — trustee and recourse review.

As with any APPS view, queries should be executed with the appropriate MO operating unit context where the underlying OKL tables enforce multi-org or security policies.