Search Results unformatted_unit_price

Overview

APPS.ARBPA_CUSTOMER_TRX_LINE is a reporting and integration view in Oracle E-Business Suite that exposes customer transaction line data from the Receivables (AR) module. Its name reflects its association with the ARBPA (Oracle Receivables Business Process Accelerator / reporting) layer, which provides denormalized access to invoice line detail for downstream analytics, custom reports, and interfaces. The view consolidates core line attributes from RA_CUSTOMER_TRX_LINES and RA_CUSTOMER_TRX with reference lookups, tax information from ZX_LINES, item and unit-of-measure descriptions from inventory synonyms, and currency attributes from FND_CURRENCY. Within ETRM 12.1.1 and 12.2.2, the view is documented under owner APPS and is commonly used where reporting requires line-level invoice detail combined with flexfield context, tax attributes, sales order references, and multi-reporting-currency (MRC) amounts. Notably, it exposes the column unformatted_unit_price, which returns the raw numeric unit price unaffected by currency formatting or display rounding — a value frequently sought when users require the true stored selling price for calculations, reconciliations, or exports.

Underlying Base Objects

The documented ETRM metadata lists the following referenced base objects: AR_BPA_UTILS_PKG (PACKAGE), AR_INVOICE_SQL_FUNC_PUB (PACKAGE), FND_CURRENCY (PACKAGE), MTL_PARAMETERS (SYNONYM), MTL_SYSTEM_ITEMS_KFV (SYNONYM), MTL_UNITS_OF_MEASURE (SYNONYM), RA_CUSTOMER_TRX (SYNONYM), RA_CUSTOMER_TRX_LINES (SYNONYM), and ZX_LINES (SYNONYM). The primary transactional sources are RA_CUSTOMER_TRX_LINES (line-level detail such as quantity, unit price, extended amount, line type) joined to RA_CUSTOMER_TRX (transaction header context including trx_number and transaction_date). Tax columns (line_tax_rate, tax_code, printed_tax_name, tax_exists_for_this_line_flag) are derived through ZX_LINES, the EBS tax engine lines table. Item and UOM descriptive attributes come from the inventory synonyms MTL_SYSTEM_ITEMS_KFV and MTL_UNITS_OF_MEASURE, while MTL_PARAMETERS supplies operating-unit/org context. FND_CURRENCY and the AR packages AR_BPA_UTILS_PKG and AR_INVOICE_SQL_FUNC_PUB provide currency conversion and Receivables business logic used to populate derived amounts and MRC columns such as mrc_extended_acctd_amount.

Key Columns

• customer_trx_id / customer_trx_line_id — Primary keys linking the line to its transaction header and unique line record.
• line_number / line_type / description — Descriptive identification of the invoice line.
• quantity / unit_of_measure_name / uom_code — Quantity billed and the associated unit of measure.
• unit_price / unformatted_unit_price — The unit selling price; unformatted_unit_price provides the raw, non-display-formatted numeric value used for precise calculations.
• extended_amount / revenue_amount / extended_acctd_amount / mrc_extended_acctd_amount — Line totals, recognized revenue, accounted amounts, and multi-reporting-currency equivalents.
• gross_unit_selling_price / gross_extended_amount / unit_standard_price — Gross and standard pricing attributes.
• sales_order / sales_order_line / sales_order_date / sales_order_source — Order-origination references for drop-ship and order-to-cash flows.
• tax_exists_for_this_line_flag / line_tax_rate / tax_code / printed_tax_name / tax_exempt_flag — Tax determination, rate, and exemption data from ZX_LINES.
• interface_line_attribute1..15 / interface_line_context / item_context / attribute_category — Descriptive flexfield and interface extensibility columns.
• set_of_books_id / org_id — Ledger and operating unit security context.
• global_attribute1..20 / attribute1..15 — Additional flexfield/global descriptive segments.

Common Use Cases and Queries

Typical use cases include invoice line reporting, price and revenue reconciliation, tax audit extracts, and integration feeds. A common requirement is retrieving the true unit price for calculation, which the view satisfies directly:

SELECT trx_number, line_number, description,
       quantity, uom_code,
       unformatted_unit_price, extended_amount
FROM   apps.arbpa_customer_trx_line
WHERE  customer_trx_id = :p_trx_id
ORDER BY line_number;

Tax-focused extracts join the same view filtered on the tax flag and rate columns. For ledger-scoped reporting, filtering by org_id and set_of_books_id enforces operating unit and ledger security. Because unformatted_unit_price is the raw numeric value, it is preferable to unit_price whenever the query feeds downstream computations, conversions, or exports where display formatting must not interfere.