Search Results default_ussgl_trx_code_context

Overview

The ICX_RA_CUSTOMER_TRX_LINES_V view is an Oracle E-Business Suite (EBS) reporting object owned by the APPS schema and registered under the ICX (Oracle iProcurement) product. Despite its placement within the iProcurement module, the view exposes customer transaction line details sourced from the Oracle Receivables (AR) transaction schema. Its documented description, "Customer Transactions Details View," indicates that it is intended to present a denormalized, presentation-ready projection of transaction line data — including quantities, pricing, line types, tax attributes, and revenue accounting information — for consumption by iProcurement or other dependent applications.

The view is particularly relevant to users searching on the column QUANTITY_CREDITED, which appears explicitly in the underlying view text. In this view, QUANTITY_CREDITED is exposed as a native column, while a separate derived column named QUANTITY applies the logic NVL(CTL.QUANTITY_CREDITED, CTL.QUANTITY_INVOICED), meaning credit quantities take precedence over invoiced quantities when both are present. The view carries a VALID status in APPS and is available in both 12.1.1 and 12.2.2 environments.

Underlying Base Objects

The view is defined over five documented base objects: RA_CUSTOMER_TRX_LINES (synonym), RA_CUSTOMER_TRX (synonym), AR_LOOKUPS (view), MTL_UNITS_OF_MEASURE (synonym), and the FND_CURRENCY package.

• RA_CUSTOMER_TRX_LINES (CTL) — the primary source, supplying nearly all columns including line number, description, UOM code, quantities, amounts, line type, tax attributes, and revenue accounting fields.
• RA_CUSTOMER_TRX (CT) — joined to provide the invoice currency code, which drives the currency format mask.
• AR_LOOKUPS (AL_LINE_TYPE) — joined on the line type to resolve the lookup meaning for display.
• MTL_UNITS_OF_MEASURE (UOM) — joined on UOM code to return the descriptive unit of measure.
• FND_CURRENCY — a package referenced via SAFE_GET_FORMAT_MASK to format unit selling price and extended amount according to the invoice currency.

Key Columns

• CUSTOMER_TRX_LINE_ID — primary identifier of the transaction line.
• LINE_NUMBER / DESCRIPTION / UOM_CODE / UNIT_OF_MEASURE — descriptive line attributes.
• QUANTITY_CREDITED — the credited quantity for the line, used for credit memo and return processing.
• QUANTITY_INVOICED / QUANTITY_ORDERED — invoiced and ordered quantities, respectively.
• QUANTITY — derived as NVL(QUANTITY_CREDITED, QUANTITY_INVOICED), providing a unified quantity measure.
• UNIT_SELLING_PRICE / EXTENDED_AMOUNT — currency-formatted monetary values.
• LINE_TYPE / MEANING — the code and its decoded lookup meaning.
• REVENUE_AMOUNT, ACCOUNTING_RULE_ID, RULE_START_DATE — revenue recognition attributes.
• TAXABLE_FLAG, TAX_RATE, TAX_EXEMPT_FLAG — tax-related attributes.
• PREVIOUS_CUSTOMER_TRX_LINE_ID / INITIAL_CUSTOMER_TRX_LINE_ID — linkage for credit and return chains.

Common Use Cases and Queries

This view is typically used to report on credit and invoice line detail, particularly for reconciling credited versus invoiced quantities. A representative query is:

• SELECT customer_trx_line_id, line_number, quantity_credited, quantity_invoiced, quantity FROM apps.icx_ra_customer_trx_lines_v WHERE quantity_credited IS NOT NULL; — isolates lines with credit activity.
• SELECT sales_order, description, extended_amount FROM apps.icx_ra_customer_trx_lines_v WHERE line_type = 'LINE'; — lists standard transaction lines by order reference.
• Reporting joins by CUSTOMER_TRX_ID back to RA_CUSTOMER_TRX to obtain header-level customer and date information.