Search Results ar_ll_freight_charges_v




Overview
Explore in AI Chat

Overview

AR_LL_FREIGHT_CHARGES_V is an APPS-owned, VALID view in the Oracle E-Business Suite Receivables (AR) module. It is a supporting database object for the Line-Level Cash Application functionality in Oracle Receivables. The view exposes freight and charges activity information at the cash receipt level, aggregated across the underlying transaction lines on which those freight and charges amounts were applied. The Line-Level Cash Application form uses this view, together with related line-level views (such as AR_LL_LINES_GROUPS_V), to present the user with a consolidated picture of how a receipt has been applied against freight and charges lines on a transaction.

In the context of a search for freight_amount, this view is the primary repository object that surfaces the FREIGHT_AMOUNT column. It allows the application—and any reporting or integration layer that queries it—to retrieve the total freight amount applied against a receipt without having to join or aggregate the underlying activity and transaction line tables directly.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, AR_LL_FREIGHT_CHARGES_V is defined over two base objects, both referenced as synonyms in the APPS schema:

The two are joined on CUSTOMER_TRX_LINE_ID. The inner query restricts the result set to lines whose LINE_TYPE is either 'FREIGHT' or 'CHARGES', whose NVL(SOURCE_TABLE,'RA') equals 'RA', and whose NVL(CURRENT_ACTIVITY_FLAG,'Y') equals 'Y'. The outer query then aggregates the joined rows by CASH_RECEIPT_ID, CUSTOMER_TRX_ID, and APPLY_TO, producing one summarized row per receipt/transaction/apply-to combination.

Key Columns

  • CASH_RECEIPT_ID — identifier of the cash receipt; the primary grouping key.
  • FREIGHT_AMOUNT — sum of freight amounts applied (LL.FREIGHT). This is the column most directly associated with the "freight_amount" search term.
  • CHARGES_AMOUNT — sum of charges amounts applied (LL.CHARGES).
  • AMOUNT — a DECODE-driven amount that resolves to the freight value when LINE_TYPE is 'FREIGHT' and to the charges value when LINE_TYPE is 'CHARGES'.
  • ALLOCATED_RECEIPT_AMOUNT — total receipt amount allocated to the included lines.
  • LINE_DISCOUNT — sum of freight discounts (LL.FREIGHT_DISCOUNT).
  • LINE_BALANCE — sum of AMOUNT_DUE_REMAINING from the transaction lines.
  • CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, LINE_NUMBER — transaction and line identifiers for the underlying document.
  • APPLY_TO — grouping attribute indicating the application target.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, CREATED_BY_MODULE, OBJECT_VERSION_NUMBER; aggregated with MAX/MIN functions.

Common Use Cases and Queries

The view supports reconciliation and reporting of freight and charges applied during line-level cash application. Typical uses include verifying total freight applied against a receipt, feeding custom Receivables reports, and supporting integration extracts that must reconcile receipt application detail to transaction lines.

To retrieve freight charges for a specific receipt:

  • SELECT cash_receipt_id, customer_trx_id, freight_amount, charges_amount, amount, line_balance FROM apps.ar_ll_freight_charges_v WHERE cash_receipt_id = :receipt_id;

To total freight applied across all receipts for a given transaction:

  • SELECT customer_trx_id, SUM(freight_amount) total_freight FROM apps.ar_ll_freight_charges_v WHERE customer_trx_id = :trx_id GROUP BY customer_trx_id;

Because the view performs aggregation, queries should filter on grouped columns (CASH_RECEIPT_ID, CUSTOMER_TRX_ID, APPLY_TO) for efficient retrieval.