Results for “sts_meaning”

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

Overview

OKL_CREDITLINES_UV is a user interface (UV) view owned by the APPS schema within the OKL – Lease and Finance Management product of Oracle E-Business Suite. It is defined as a presentation-layer view that drives the Credit Line Contract page, exposing credit line contract data in a form suitable for that specific UI. The view is documented as VALID and is the primary reporting and page-rendering construct for credit line contracts in both 12.1.1 and 12.2.2. Because it is a view, it holds no data of its own; instead it joins header, status, party, customer account, rule, currency, and conversion-type information from multiple base objects into a single, denormalized row set.

Underlying Base Objects

The view is built on a join of the following documented base objects: OKC_K_HEADERS_B (contract header, aliased CHRB), OKC_K_HEADERS_TL (translated header description, CHRT), OKL_K_HEADERS (credit line header extension, KHR), OKC_K_PARTY_ROLES_B (party roles, CPL), OKC_RULES_B (rules, RUL), OKC_STATUSES_V (status meaning), OKX_CUSTOMER_ACCOUNTS_V, OKX_PARTIES_V, OKX_CUST_SITE_USES_V, FND_CURRENCIES_VL (aliased CURR), and GL_DAILY_CONVERSION_TYPES_V (aliased DCT). It also invokes OKL_SEEDED_FUNCTIONS_PVT (CREDITLINE_TOTAL_LIMIT and CREDITLINE_TOTAL_REMAINING) and queries OKL_CHECKLISTS in scalar subqueries. The core join connects OKC_K_HEADERS_B.ID to OKC_K_HEADERS_TL.ID (restricted to the user language) and to OKL_K_HEADERS.ID, with the significant filter CHRB.SCS_CODE = 'CREDITLINE_CONTRACT' ensuring only credit line contracts are surfaced.

Key Columns

• ID, CONTRACT_NUMBER, DESCRIPTION, STS_CODE, STS_MEANING – Contract identity and status.
• SCS_CODE, START_DATE, END_DATE – Contract subtype and validity period.
• CURRENCY_CODE and CURRENCY_NAME – The operating currency. CURRENCY_NAME is drawn from FND_CURRENCIES_VL.NAME and is the column most frequently referenced by users searching this view.
• CURRENCY_CONVERSION_TYPE, USER_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE – Conversion parameters sourced from OKL_K_HEADERS and GL_DAILY_CONVERSION_TYPES_V.
• REVOLVING_CREDIT_YN – Indicates whether the credit line revolves.
• PARTY_ROLES_ID, CUSTOMER_ID1, CUSTOMER_ID2, CUSTOMER_NAME, CUSTOMER_NUMBER – Customer and party role details.
• CUST_ACCT_ID, CUST_ACCT_NAME, CUST_ACCT_NUMBER, LEGAL_ADDRESS – Customer account and site information.
• CREDITLINE_CKL_ID/NUMBER, FUNDING_CKL_ID/NUMBER, CHKLST_TPL_RGP_ID, CHKLST_TPL_RULE_ID – Checklist rule references.
• TOTAL_LIMIT and REMAINING – Computed through OKL_SEEDED_FUNCTIONS_PVT, defaulting to 0.

Common Use Cases and Queries

The view supports credit line dashboards, contract inquiries, and integration extracts. A typical query returning credit line contracts with their currency and limits:

• SELECT contract_number, description, currency_code, currency_name, total_limit, remaining FROM okl_creditlines_uv;
• SELECT contract_number, customer_name, currency_name, remaining FROM okl_creditlines_uv WHERE revolving_credit_yn = 'Y' AND remaining > 0;
• SELECT currency_code, currency_name, SUM(total_limit) FROM okl_creditlines_uv GROUP BY currency_code, currency_name;

Because CURRENCY_NAME is provided directly, reports avoid an additional join to FND_CURRENCIES_VL. The view applies no additional data-security predicate beyond its base objects, so callers relying on FND_DATA_SECURITY should apply appropriate filters.