Search Results ece_ino_line_tax_v




Overview
Explore in AI Chat

Overview

The ECE_INO_LINE_TAX_V view is a private, active database object owned by the APPS schema within the Oracle E-Business Suite e-Commerce Gateway (EC) product. It is classified under the AR_INVOICE business entity and carries the display name Invoice Line Tax View. Its documented purpose is to extract line-level tax information for the outbound Invoice transaction, specifically the 810 (ANSI X12) and INVOIC (EDIFACT) message formats.

In the Oracle EBS architecture, the e-Commerce Gateway relies on a series of extraction views to assemble the flat, transaction-oriented data structures required by outbound EDI and XML interfaces. Rather than reading directly from the base Receivables tables, the gateway selects from views such as this one, which pre-join, alias, and format the relevant columns. This abstraction allows the gateway to map internal column names (for example, TAX_EXEMPT_REASON_CODE) to the canonical fields defined in the EDI mapping for the invoice tax segment. The view therefore serves as the bridge between Oracle Receivables transaction data and the outbound invoice tax payload, and it is especially relevant to users searching for tax_exempt_reason_code, since that attribute is projected directly from the transaction line.

Underlying Base Objects

The documented base objects referenced by ECE_INO_LINE_TAX_V are:

  • RA_CUSTOMER_TRX — the Receivables transaction header table, providing the transaction identifier.
  • RA_CUSTOMER_TRX_LINES — the transaction line table, supplying line numbers, line types, tax amounts, tax rates, tax precedence, and the exemption attributes.
  • ZX_RATES_B and ZX_RATES_TL — the E-Business Tax rate definition tables (base and translation), used to resolve tax rate details.
  • ZX_TAXES_B — the E-Business Tax tax regime/configuration table, providing tax codes, tax types, descriptions, VAT transaction types, and descriptive flexfield attributes.

The view joins the transaction header in RA_CUSTOMER_TRX to two aliases of RA_CUSTOMER_TRX_LINES: one representing the inventory line (aliased RCTL1) and one representing the tax line (aliased RCTL2). Tax configuration attributes are drawn from the ZX tables. All base objects are accessed through synonyms in the APPS schema, consistent with standard EBS view definition practice.

Key Columns

Common Use Cases and Queries

This view is primarily consumed by the e-Commerce Gateway extraction program that builds the outbound 810/INVOIC file. Developers also query it directly to troubleshoot tax lines or to confirm exemption data before transmission.

To retrieve tax lines with exemption details for a transaction:

  • SELECT transaction_id, line_number, tax_line_number, tax_amount, tax_code, tax_exempt_flag, tax_exempt_reason_code FROM apps.ece_ino_line_tax_v WHERE transaction_id = :p_trx_id ORDER BY tax_line_number;

To audit exempt invoices for the outbound interface:

  • SELECT transaction_id, tax_line_number, tax_exempt_number, tax_exempt_reason_code FROM apps.ece_ino_line_tax_v WHERE tax_exempt_flag = 'Y';

These queries confirm that the view exposes the exemption reason code requested in the user's search, making it the correct object for resolving tax_exempt_reason_code at the invoice tax-line level.