Search Results agreement_sts_code

Overview

APPS.OKL_POOL_HEADER_UV is a union-based reporting view in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, exposing the header attributes of lease funding pools defined in OKL_POOLS. The "_UV" suffix indicates a user-facing validation/reporting view designed for inquiry screens, concurrent-program extracts, and integration feeds rather than for direct DML. Its distinguishing characteristic is that it deliberately unifies two populations of pool records: "standalone" pools that carry no associated contract (KHR_ID IS NULL), and "contract-linked" pools that are tied to a lease agreement through KHR_ID.

The view is delivered in both EBS 12.1.1 and 12.2.2 and is owned by the APPS schema. Because the column list is normalized across both branches of the UNION, the view presents a consistent header record regardless of whether the pool is contract-anchored or independent.

Underlying Base Objects

The documented base objects referenced by OKL_POOL_HEADER_UV are:

• OKL_POOLS (synonym) — the primary table supplying pool header data such as POOL_NUMBER, CURRENCY_CODE, principal and receivable amounts, KHR_ID, STATUS_CODE, descriptive flexfield attributes, and LEGAL_ENTITY_ID.
• OKC_K_HEADERS_ALL_B (synonym) — the contract header table, joined in the second UNION branch to supply CONTRACT_NUMBER (exposed as AGREEMENT_NUMBER) and its status/STE information.
• OKC_STATUSES_B / OKC_STATUSES_TL (synonyms) — the status code and translation tables used both to resolve the pool's own STATUS_CODE into a MEANING and to resolve the linked contract's status.
• FND_LOOKUPS (view) — used to translate the DISPLAY_IN_LEASE_CENTER flag value (OKL_YES_NO lookup type) into a readable meaning.
• FND_GLOBAL (package) — referenced for session context, including the USERENV('LANG') language setting applied to the translated status records.

The join against OKC_K_HEADERS_ALL_B is central to the view's contract-aware behavior; in the first UNION branch the agreement-related columns are supplied as literal NULLs, preserving column alignment.

Key Columns

• ID — pool identifier, sourced from OKL_POOLS.ID.
• POOL_NUMBER, CURRENCY_CODE, DESCRIPTION, SHORT_DESCRIPTION — core pool header descriptors.
• TOTAL_PRINCIPAL_AMOUNT, TOTAL_RECEIVABLE_AMOUNT — aggregate financial amounts maintained on the pool, with DATE_TOTAL_PRINCIPAL_CALC recording the last recalculation.
• KHR_ID — the contract header identifier; NULL for standalone pools, populated for contract-linked pools.
• STATUS_CODE / STATUS — the pool status code and its translated meaning via OKC_STATUSES_TL.
• AGREEMENT_NUMBER, AGREEMENT_STE_CODE, AGREEMENT_STS_CODE, AGREEMENT_STATUS — contract-side attributes. Only the contract-linked branch populates these; the standalone branch returns NULL for all four.
• DISPLAY_IN_LEASE_CENTER / DISP_IN_LEASE_CNTR_MEANING — controls whether the pool appears in the Lease Center UI, with the lookup meaning supplied by FND_LOOKUPS (OKL_YES_NO).
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard descriptive flexfield columns for extensibility.
• LEGAL_ENTITY_ID — owning legal entity, relevant for multi-org reporting and accounting derivation.

The user's search term agreement_ste_code maps directly to the AGREEMENT_STE_CODE column, which carries the short-term-extendable flag of the associated contract header (OKC_K_HEADERS_ALL_B.STE_CODE). Because it is populated only in the second UNION branch, it returns NULL for pools without an attached agreement.

Common Use Cases and Queries

The view is typically queried to reconcile pool balances, list pools by status, or expose pools and their governing agreement in a single row. Because AGREEMENT_STE_CODE is NULL for standalone pools, callers should anticipate and filter accordingly.

SELECT pool_number, khr_id, agreement_number,
       agreement_ste_code, status, total_principal_amount
FROM   apps.okl_pool_header_uv
WHERE  agreement_ste_code IS NOT NULL;

A second common pattern joins the view back to OKC_K_HEADERS_ALL_B or OKC_K_HEADERS_ALL_TL to enrich contract-level attributes, or filters on DISPLAY_IN_LEASE_CENTER to build Lease Center tile queries. Reporting extracts frequently use the UNION-normalized shape to load pool header staging tables without branching on the presence of an agreement.