Search Results amount_cr

Overview

OKL_AR_DIST_UV is an APPS-owned database view within the Oracle Lease and Finance Management (OKL) product module. It presents a consolidated, union-based projection of Accounts Receivable distribution lines that arise from lease and finance transactions, exposing both customer transaction GL distributions and generic AR distributions in a single reporting structure. Because the view pivots on the "autogl_type" lookup (implemented through ACCOUNT_CLASS and SOURCE_TYPE), it is the standard presentation layer for reviewing the accounting event line types and their associated General Ledger accounting entries generated by the AR sub-ledger for leased assets.

The view's role is primarily reporting and integration: it abstracts the underlying AR tables into a uniform shape of distribution identifiers, account classifications, concatenated accounting flexfield segments, debit/credit indicators, amounts, accounting dates, and posting status. This makes it suitable for upstreaming into custom reconciliation reports, sub-ledger to GL tie-outs, and third-party extract processes without requiring consumers to understand the differing column semantics of the two sourcing branches.

Underlying Base Objects

The documented metadata identifies the following referenced base objects, most accessed under APPS synonyms: AR_CASH_RECEIPT_HISTORY, AR_DISTRIBUTIONS, AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST, and RA_CUST_TRX_TYPES. The OKL_ACCOUNTING_UTIL package is referenced as a program unit and provides the descriptive helper functions used throughout the view text.

The first branch of the union selects from RA_CUST_TRX_LINE_GL_DIST joined to RA_CUSTOMER_TRX and RA_CUST_TRX_TYPES, filtered to rows where ACCOUNT_SET_FLAG = 'N'. The second branch selects from a generic distribution source (aliased AD) that exposes AMOUNT_CR, AMOUNT_DR, SOURCE_TYPE, and CODE_COMBINATION_ID — corresponding to AR_DISTRIBUTIONS — leveraging the remaining AR-related synonyms for context. The union combines these into a single logical distribution stream.

Key Columns

• ID — The distribution surrogate key, mapped either from CUST_TRX_LINE_GL_DIST_ID or from LINE_ID in the generic branch.
• AE_LINE_TYPE / AE_LINE_TYPE_MEANING — The "autogl_type" account class (for example REC) or the AR source type, resolved to a meaning via OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('AUTOGL_TYPE', ...).
• CODE_COMBINATION_ID — The GL accounting flexfield combination referenced by the distribution.
• CONCATE_SEGMENTS / CONCATE_SEGMENTS_DESC — Human-readable concatenated segment string and its description, produced by GET_CONCAT_SEGMENTS and GET_CONCATE_DESC.
• CR_DR_FLAG / DR_CR_FLAG_MEANING — Debit/credit indicator and its lookup meaning ('D' or 'C'), with credit/debit inversion applied for credit memos (CM) versus invoices (INV).
• AMOUNT — Signed distribution amount; credit memos are negated in the first branch.
• ACCOUNTING_DATE — The GL_DATE from the customer transaction line distribution.
• TEMPLATE_NAME — The auto-accounting template label coinciding with the account class meaning.
• POSTED — 'Y'/'N' derived from GL_POSTED_DATE via the YES_NO lookup.
• SOURCE_ID / SOURCE_TABLE / CUSTOMER_TRX_ID — Traceability back to RA_CUSTOMER_TRX_LINES and the originating customer transaction.

Common Use Cases and Queries

Typical uses include reconciling lease AR distributions to GL postings, identifying unposted distributions, and auditing the autogl_type classifications produced for lease billing events. A representative query filtering by account class:

• SELECT id, ae_line_type_meaning, concate_segments, dr_cr_flag_meaning, amount, accounting_date, posted FROM okl_ar_dist_uv WHERE ae_line_type = 'REC' AND posted = 'N';
• SELECT source_id, customer_trx_id, SUM(amount) FROM okl_ar_dist_uv GROUP BY source_id, customer_trx_id;
• SELECT ae_line_type, au.ae_line_type_meaning, COUNT(*) FROM okl_ar_dist_uv au GROUP BY ae_line_type, au.ae_line_type_meaning;

These queries support distribution-level drill-downs, exception reporting for unposted accounting, and summarization by autogl_type for lease revenue and receivable analysis.