Results for “counter_group”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_BPD_CNTR_LVLNG_SUMRY_UV is a read-only reporting view owned by the APPS schema in Oracle Lease and Finance Management (OKL). It presents a consolidated summary of counter leveling activity across lease contracts and their associated assets. Counter leveling is the mechanism by which ETRM tracks and rebalances usage counters (for example, meter readings, copies, or units produced) against contractual thresholds and billing schedules. The view flattens that relationship into a single denormalized row per counter, contract, and asset combination, exposing the counter group name, counter number, contract number, asset identifiers, and the effective date range over which the counter assignment applies.
Because the underlying counter leveling data model is highly normalized — spanning contract headers, contract lines, contract items, counters, and asset tables — the view exists primarily to support operational reporting, extract feeds, and diagnostic queries. Developers and analysts who search for the related base object okc_k_items typically arrive here while tracing how counters are linked to contract lines through the OKC_K_ITEMS association table. The view abstracts that join complexity, making it the preferred access point for BPD (Business Process Definition) style lease counter summary reporting.
Underlying Base Objects
The view is defined over a combination of views and base tables from the OKC, OKL, OKX, and CS modules:
- OKC_K_HEADERS_B — the contract header, supplying CONTRACT_NUMBER via the header ID.
- OKC_K_LINES_B — referenced multiple times (aliased USAGE, OKS, ASSET, ASSET_LINE, OKS_ASSET) to represent the different line roles: usage line, OKS line, and asset line.
- OKC_K_ITEMS — the contract line item association table, joined repeatedly (aliases ITEMS, ITEMS1, ITEMS2, ITEMOKS) to link usage lines to OKS lines, asset lines, and counters.
- OKC_K_LINES_TL — the translatable line table, restricted by
LANGUAGE = USERENV('LANG'), supplying the asset number. - CS_COUNTERS — the counter master, supplying the counter ID and counter name.
- OKL_CNTR_LVLNG_GRPS_V and OKL_CNTR_LVLNG_LNS_V — the counter leveling group and line views, providing the counter group name and the effective date range.
- OKX_ASSETS_V — the asset view, providing serial number and description.
The joins are driven primarily through OKC_K_ITEMS, which is why that object appears so frequently in the definition and in user searches related to this view.
Key Columns
- COUNTER_GROUP — name of the counter leveling group to which the counter belongs.
- COUNTER_NUMBER — the counter identifier from CS_COUNTERS.
- COUNTER_NAME — descriptive name of the counter.
- CONTRACT_NUMBER — the lease or finance contract number from OKC_K_HEADERS_B.
- ASSET_NUMBER — the asset line name, language-dependent via OKC_K_LINES_TL.
- ASSET_SERIAL_NUMBER and ASSET_DESCRIPTION — identifying attributes from OKX_ASSETS_V.
- EFFECTIVE_DATE_FROM and EFFECTIVE_DATE_TO — the validity window of the counter leveling assignment.
Common Use Cases and Queries
Typical scenarios include auditing which counters are leveled against which assets, reconciling counter leveling periods, and building extracts for external billing or usage systems. A representative query:
SELECT counter_group, counter_number, contract_number, asset_number, effective_date_from, effective_date_to FROM apps.okl_bpd_cntr_lvlng_sumry_uv WHERE contract_number = :p_contract_number;
Analysts tracing relationships back to okc_k_items can join on COUNTER_NUMBER and CONTRACT_NUMBER to reconcile the summarized rows against the underlying line item structure. Because it is a view, no DML is permitted; all access is read-only and should be filtered where possible for performance.
-
APPS.OKL_BPD_CNTR_LVLNG_SUMRY_UV·↳ CS_COUNTERS·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·Explore OKL module →
-
APPS.OKL_BPD_CNTR_READING_UV·↳ CS_COUNTERS·↳ MTL_UNITS_OF_MEASURE_TL·↳ OKC_K_HEADERS_B·Explore OKL module →
-
APPS.OKL_BPD_CNTR_LVLNG_SUMRY_UV·↳ CS_COUNTERS·↳ OKC_K_HEADERS_B·↳ OKC_K_ITEMS·Explore OKL module →
-
APPS.OKL_BPD_CNTR_READING_UV·↳ CS_COUNTERS·↳ MTL_UNITS_OF_MEASURE_TL·↳ OKC_K_HEADERS_B·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