Results for “okl_ae_tmpt_lnes_v”

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

Overview

OKL_AE_TMPT_LNES_V is a security-enabled reporting view within the Oracle Leasing and Finance Management (OKL) module of Oracle E-Business Suite. Its documented purpose is to expose accounting template lines — the individual debit and credit distribution rows that make up an accounting template used by the OKL accounting engine (the Account Generator and related subledger routines). In the context of the search term "Onelab R100 Service Request," this view is relevant to the R100-style accounting and journal-generation logic in the leasing module, where template lines drive how contract-related accounting entries are constructed and posted.

The view is documented as "Not implemented in this database" in the source ETRM metadata, meaning that in the specific instance captured it was not present or instantiated, even though its definition exists. The view is owned by the OKL (Leasing and Finance Management) product and carries no documented referenced base objects in the metadata excerpt, though the view text clearly indicates it is defined over OKL_AE_TMPT_LNES.

Underlying Base Objects

Although the documented metadata records "Referenced base objects: none documented," the view SQL is an alias-based SELECT against a single table, OKL_AE_TMPT_LNES (aliased ATLB). All columns are projected directly from that table, plus a ROWID exposed as ROW_ID. There are no joins, unions, or aggregations, so the view is effectively a filtered, security-wrapped projection of the accounting template lines table.

The defining characteristic is the ORG_ID predicate implementing Multi-Org Access Control (MOAC). The WHERE clause compares NVL(ORG_ID, ...) to the organization identifier derived from USERENV('CLIENT_INFO'), decoding the first ten bytes of the client information string into an organization number, defaulting to -99 when unavailable. This enforces operating-unit-level row security on the template lines.

Key Columns

• ID — Primary identifier of the accounting template line.
• AVL_ID — Identifier linking the line to its accounting template/version or related accounting object.
• CRD_CODE — Code associates the line with the relevant credit/debit or accounting code context.
• CODE_COMBINATION_ID — Reference to the GL code combination (account) used when the line posts.
• AE_LINE_TYPE — Identifies the accounting entry line type (for example, debit or credit designation).
• SEQUENCE_NUMBER — Ordering of lines within the template.
• PERCENTAGE — Distribution percentage applied to the line.
• ACCOUNT_BUILDER_YN — Indicates whether the line uses the Account Builder to derive the account.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield context and segments for extensible line attributes.
• ORG_ID — Operating unit, used for MOAC filtering.
• ROW_ID — Rowid of the underlying table row.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER for concurrency control.

Common Use Cases and Queries

Typical usage is diagnostic and reporting-driven: inspecting how accounting templates are configured for lease contracts, validating line distributions, and troubleshooting subledger accounting generation in OKL. Example query listing template lines for the current operating unit:

• SELECT id, avl_id, ae_line_type, sequence_number, percentage, code_combination_id FROM okl_ae_tmpt_ln es_v ORDER BY avl_id, sequence_number;
• SELECT id, account_builder_yn, attribute_category, attribute1 FROM okl_ae_tmpt_ln es_v WHERE account_builder_yn = 'Y';
• SELECT code_combination_id, SUM(percentage) FROM okl_ae_tmpt_ln es_v GROUP BY code_combination_id;

Because MOAC filtering is embedded, queries return only lines for organizations the session is authorized to access.