Results for “from_to_flag”

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

Overview

AR_CM_APP_DIST_LINES_L_V is a Receivables (AR) reporting view owned by the APPS schema. It is defined to expose interface line attribute data associated with credit memo (CM) applications and the corresponding distribution lines that arise from Subledger Accounting (SLA) extract processing. The view's purpose, as documented in ETRM, is "to fetch interface line attributes data for CM applications."

Functionally, the view serves as a join layer that flattens the interface-line context and the fifteen interface line attributes of a credit memo application line and pairs them with extract-level and distribution-level identifiers. It is used primarily for reporting and diagnostic purposes, allowing inquiry into how descriptive and reference attributes carried on Receivables transaction lines were propagated into the accounting extract for CM applications. Because many customers use INTERFACE_LINE_ATTRIBUTE1 through INTERFACE_LINE_ATTRIBUTE15 as context-driven flexfield segments, the view is a common entry point when reconciling or tracing a specific attribute value — for example, interface_line_attribute14 — back to its originating credit memo and its associated distribution.

Underlying Base Objects

The view is defined over the following documented base objects:

• AR_DISTRIBUTIONS_ALL (SYNONYM) — the Receivables distributions table, aliased in the view text as ARDIST. This supplies the distribution identifier and the literal CM_APP_DISTRIBUTION_TYPE value of 'AR_DISTRIBUTIONS_ALL'.
• AR_XLA_LINES_EXTRACT (SYNONYM) — the SLA lines extract table, aliased as CTLAF and, in a self-join, as CTLAF2. This is the primary source of interface line context and attributes.
• RA_CUSTOMER_TRX_LINES_ALL (SYNONYM) — the Receivables transaction lines table, providing the customer transaction line context used in the view's joins.

The view text also references L, an extract-lines alias supplying LINE_ID, PAIRED_CCID, EVENT_ID, LINE_NUMBER, LANGUAGE, LEDGER_ID and FROM_TO_FLAG. A hinted index, AR_XLA_LINES_EXTRACT_N1, is applied against the extract table to drive access along the extract line identifier. Notably, the attribute 14 exposure involves a self-join between CTLAF and CTLAF2, governed by a DECODE on LINE_TYPE and INTERFACE_LINE_CONTEXT.

Key Columns

• CM_APP_CUSTOMER_TRX_ID / CM_APP_CUSTOMER_TRX_LINE_ID / CM_APP_LINE_NUMBER / CM_APP_LINE_TYPE — the credit memo application transaction, line, line number, and line type taken from the extract.
• CM_APP_INTERFACE_LINE_CT — the interface line context (for example OKL_CONTRACTS or OKL_INVESTOR), which determines how attribute 14 is resolved.
• CM_APP_INTERFACE_LINE_ATTR1 through ATTR15 — the fifteen context-driven interface attributes carried on the application line. Attribute 14 is the most significant: rather than a direct passthrough, it is computed with a DECODE that returns CTLAF.INTERFACE_LINE_ATTRIBUTE14 when the line type is 'LINE', and for other contexts falls back to NVL(CTLAF.INTERFACE_LINE_ATTRIBUTE14, CTLAF2.INTERFACE_LINE_ATTRIBUTE14) where the self-joined context is OKL_CONTRACTS or OKL_INVESTOR.
• CM_APP_EXTRACT_LINE_ID / CM_APP_EXTRACT_PAIRED_CCID — extract line identifier and paired code combination identifier.
• EVENT_ID, LINE_NUMBER, LANGUAGE, LEDGER_ID, FROM_TO_FLAG — subledger event, line sequencing, language, ledger and accounting-entry direction indicators carried from the extract line.
• CM_APP_DISTRIBUTION_TYPE / CM_APP_DISTRIBUTION_ID — the distribution type (fixed literal 'AR_DISTRIBUTIONS_ALL') and the distribution line identifier.

Common Use Cases and Queries

The view is typically queried to trace an attribute-based reference, such as interface_line_attribute14, from a credit memo application to its distribution and extract context. A representative query follows:

• Attribute 14 tracing: SELECT CM_APP_CUSTOMER_TRX_ID, CM_APP_CUSTOMER_TRX_LINE_ID, CM_APP_INTERFACE_LINE_CT, CM_APP_INTERFACE_LINE_ATTR14, CM_APP_EXTRACT_LINE_ID, CM_APP_DISTRIBUTION_ID, LEDGER_ID FROM APPS.AR_CM_APP_DIST_LINES_L_V WHERE CM_APP_INTERFACE_LINE_ATTR14 = :attr14;
• Extract reconciliation: join the view to AR_XLA_LINES_EXTRACT on CM_APP_EXTRACT_LINE_ID to reconcile view attributes against the underlying extract record.
• Context-based filtering: restrict by CM_APP_INTERFACE_LINE_CT IN ('OKL_CONTRACTS','OKL_INVESTOR') to isolate the contexts where the attribute 14 fallback logic applies.
• Ledger-scoped reporting: filter by LEDGER_ID and EVENT_ID to report CM application distributions for a specific accounting event.

Because the view relies on an index hint and a self-join, queries should be constrained on the extract line identifier, transaction identifier, or attribute value to avoid full scans of the extract table.