Results for “okl_stream_type_purpose”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OKL_LINE_STREMS_SUM_UV is an Oracle E-Business Suite view belonging to the Oracle Lease and Finance Management (OKL) application module, also referred to as ETRM (Enterprise Transaction and Revenue Management). The view presents a summarized, de-normalized picture of contract line level revenue streams organized by stream type and stream purpose. It consolidates monetary amounts from OKL_STRM_ELEMENTS grouped to the contract, contract line, and stream type level, and exposes descriptive (translated) attributes for activity codes, stream type purposes, and stream purposes drawn from the OKL lookup framework.
Because it joins contract header, contract line, style, item, stream, and stream element data and returns translated descriptions via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING, the view functions as a reporting and integration layer. Reporting tools, BI Publisher extracts, and interface programs can query OKL_LINE_STREMS_SUM_UV rather than reconstructing the joins across OKC and OKL base tables. The presence of K_LINE_NAME as an exposed column makes the view particularly useful when users search by contract line name (k_line_name), since it surfaces the descriptive contract line name alongside the aggregated stream amounts.
Underlying Base Objects
The view is defined over a set of OKC (Contracts Core) and OKL (Leasing) synonyms and one package, as documented in the ETRM metadata:
- OKC_K_HEADERS_B — contract headers; supplies CONTRACT_ID and CONTRACT_NUMBER.
- OKC_K_LINES_B / OKC_K_LINES_TL — contract lines base and translated tables; the translated table provides the K_LINE_NAME in one branch of the UNION ALL.
- OKC_LINE_STYLES_B — line styles; the view filters LTY_CODE = 'FEE' to restrict to fee-type lines.
- OKC_K_ITEMS — contract line items; used to associate the stream type (STYA) via OBJECT1_ID1.
- OKL_STRM_TYPE_B / OKL_STRM_TYPE_TL — stream type base and translated tables; supply NAME (STYT) and K_LINE_NAME (STYA).
- OKL_STREAMS — stream records; supply SAY_CODE (activity), STREAM_TYPE_PURPOSE, and PURPOSE_CODE.
- OKL_STRM_ELEMENTS — stream element amounts; SUM(AMOUNT) is aggregated here.
- OKL_ACCOUNTING_UTIL — package providing GET_LOOKUP_MEANING for lookup translated values.
- OKX_SYSTEM_ITEMS_V — referenced for item details in the union/join set.
The view is a UNION ALL of at least two branches, each aggregating SELB.AMOUNT (OKL_STRM_ELEMENTS) with GROUP BY on contract, contract number, activity code, K_LINE_NAME, stream type name, stream type purpose, purpose code, and lookup meanings. Usages of language-sensitive columns are filtered to USERENV('LANG').
Key Columns
- CONTRACT_ID / CONTRACT_NUMBER — identifier and number of the OKC contract header.
- ACTIVITY_CODE (SAY_CODE) and ACTIVITY — coded and translated stream activity.
- K_LINE_NAME — the contract line (or stream type) descriptive name; the column users commonly search on.
- NAME — translated stream type name.
- STREAM_TYPE_PURPOSE_CODE / STREAM_TYPE_PURPOSE — coded and translated stream type purpose.
- PURPOSE_CODE / PURPOSE — coded and translated stream general purpose.
- AMOUNT — SUM of stream element amounts for the grouping key.
- STYB.ID — stream type identifier from the base stream type table.
Common Use Cases and Queries
Typical uses include revenue stream summaries by contract line, fee-line reporting, and reconciliation of stream elements to contract headers. To find rows by k_line_name:
SELECT contract_number, k_line_name, activity, stream_type_purpose, purpose, amount
FROM apps.okl_line_strms_sum_uv
WHERE k_line_name LIKE :line_name_bind
ORDER BY contract_number, k_line_name;
To summarize amounts per contract:
SELECT contract_number, k_line_name, SUM(amount) total_amount
FROM apps.okl_line_strms_sum_uv
GROUP BY contract_number, k_line_name;
Because lookups are resolved at query time through OKL_ACCOUNTING_UTIL, results reflect the session language (USERENV('LANG')), so callers should set NLS appropriately when translated descriptions are required.
-
Stream Type Purpose
-
Stream Type Purpose
-
View: OKL_LINE_STRMS_SUM_UV 12.1.1
This view contains the sum of Service, Fee and Insurance streams.
APPS.OKL_LINE_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·Explore OKL module →
-
View: OKL_LINE_STRMS_SUM_UV 12.2.2
This view contains the sum of Service, Fee and Insurance streams.
APPS.OKL_LINE_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·Explore OKL module →
-
View to display all the stream template all types
APPS.OKL_STRM_TMPT_TYPES_ALL_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STRM_TYPE_V·↳ OKL_ST_GEN_TMPT_LNS_ALL·Explore OKL module →
-
View to display all the stream template all types
APPS.OKL_STRM_TMPT_TYPES_ALL_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STRM_TYPE_V·↳ OKL_ST_GEN_TMPT_LNS_ALL·Explore OKL module →
-
View that holds the stream templates
APPS.OKL_STRM_TMPT_SET_TYPE_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TMPT_SETS_ALL·↳ OKL_STRM_TYPE_V·Explore OKL module →
-
View to display all the stream template all types
APPS.OKL_STRM_TMPT_ALL_TYPES_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STRM_TYPE_V·↳ OKL_ST_GEN_TMPT_LNS·Explore OKL module →
-
View to display all the stream template all types
APPS.OKL_STRM_TMPT_ALL_TYPES_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STRM_TYPE_V·↳ OKL_ST_GEN_TMPT_LNS·Explore OKL module →
-
View that holds the stream templates
APPS.OKL_STRM_TMPT_SET_TYPE_UV·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TMPT_SETS_ALL·↳ OKL_STRM_TYPE_V·Explore OKL module →
-
Contract Streams Sum
APPS.OKL_CNTRCT_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STREAMS·Explore OKL module →
-
Contract Streams Sum
APPS.OKL_CNTRCT_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKL_ACCOUNTING_UTIL·↳ OKL_STREAMS·Explore OKL module →
-
View: OKL_ASST_STRMS_SUM_UV 12.1.1
Asset Streams Sum
APPS.OKL_ASST_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
APPS.OKL_BPD_RECEIPT_ASSET_UV·↳ FA_ADDITIONS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
APPS.OKL_BPD_RECEIPT_ASSET_UV·↳ FA_ADDITIONS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
Investor Agreement Investor Details View
APPS.OKL_SEC_INVESTOR_DTLS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
Investor Agreement Investor Details View
APPS.OKL_SEC_INVESTOR_DTLS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
View: OKL_ASST_STRMS_SUM_UV 12.2.2
Asset Streams Sum
APPS.OKL_ASST_STRMS_SUM_UV·↳ OKC_K_HEADERS_B·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View to display all the stream types for a miscellaneous transaction
APPS.OKL_STRM_TMPT_CONTRACTS_UV·↳ OKC_K_HEADERS_ALL_B·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TMPT_SETS_ALL·Explore OKL module →
-
View to display all the stream types for a miscellaneous transaction
APPS.OKL_STRM_TMPT_CONTRACTS_UV·↳ OKC_K_HEADERS_ALL_B·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AE_TMPT_SETS_ALL·Explore OKL module →