Results for “cr_dr_flag”

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

Overview

OKL_TRX_DISTRIBUTION_UV is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the OKL product family, commonly referenced as Oracle Leasing and Finance Management. The view consolidates transaction accounting distribution lines and presents them together with decoded, user-facing descriptions, which makes it suitable for accounting inquiry screens, reconciliation reports, and downstream integration extracts without requiring consumers to resolve lookup codes or perform multi-table joins.

Functionally, the view exposes one row per accounting distribution line, joined where applicable to an accounting event template. It bridges the technical distribution table and the presentation layer by invoking several helper functions from the OKL_ACCOUNTING_UTIL package to derive concatenated accounting flexfield segments and to translate coded values into descriptive meanings. Because it is a view and not a table, it carries no independent storage and reflects the current committed state of its underlying distribution data.

In the context of the user search term "okl_ae_line_type," the view is significant because AE_LINE_TYPE is one of its primary classification columns, and the view also surfaces its decoded form as AE_LINE_TYPE_MEANING.

Underlying Base Objects

Per the documented ETRM metadata, OKL_TRX_DISTRIBUTION_UV is defined over the following objects:

• OKL_TRNS_ACC_DSTRS (SYNONYM) — the primary driving table, aliased OTAD in the view text.
• OKL_AE_TEMPLATES_ALL (SYNONYM) — outer-joined to the distribution table on the condition OTAD.TEMPLATE_ID = OAT.ID(+).
• OKL_ACCOUNTING_UTIL (PACKAGE) — invoked repeatedly to decode segments and lookup values.

The distribution table supplies the transaction accounting lines, including the account combination, amounts, debit/credit indicators, and posting status. The templates table supplies the accounting event template name associated with each distribution line. Because the join to OKL_AE_TEMPLATES_ALL is an outer join, distribution rows without a matching template are still returned, with TEMPLATE_NAME null.

Key Columns

• ID — Surrogate identifier of the distribution row (OTAD.ID).
• AE_LINE_TYPE — The accounting event line type code that classifies the nature of the distribution line.
• AE_LINE_TYPE_MEANING — Decoded meaning of AE_LINE_TYPE using lookup type 'OKL_AE_LINE_TYPE'.
• CODE_COMBINATION_ID — Identifier of the accounting flexfield combination.
• CONCATE_SEGMENTS / CONCATE_SEGMENTS_DESC — Concatenated segment string and its description, resolved via OKL_ACCOUNTING_UTIL.
• CR_DR_FLAG / DR_CR_FLAG_MEANING — Debit or credit indicator and its decoded 'DR_CR' meaning.
• AMOUNT — Distribution amount.
• ACCOUNTING_DATE — The GL date (GL_DATE) applicable to the line.
• TEMPLATE_NAME — The accounting event template name, converted to initial-caps form.
• POSTED — Decoded 'YES_NO' posting status.
• SOURCE_ID / SOURCE_TABLE — Origin identifiers of the underlying business transaction.

Common Use Cases and Queries

Typical scenarios include preparing accounting reconciliation extracts, analyzing debit and credit distributions by event line type, and displaying readable account and lookup descriptions in custom reports.

Sample query by event line type:

SELECT ae_line_type_meaning, cr_dr_flag, amount
FROM   apps.okl_trx_distribution_uv
WHERE  ae_line_type = :p_line_type
AND    accounting_date BETWEEN :p_from AND :p_to;

Sample query to trace distributions to their source transaction:

SELECT id, source_table, source_id, concate_segments, template_name, posted
FROM   apps.okl_trx_distribution_uv
WHERE  source_id = :p_source_id
AND    source_table = :p_source_table;