Results for “arbv_taxes”

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

Overview

ARBV_TAXES is an Oracle E-Business Suite (EBS) view owned by the APPS schema in the Oracle Receivables (AR) module. Its documented purpose is to expose detailed tax information associated with transaction line items, presenting tax records that would otherwise require filtering and decoding of the underlying transaction line table. The view is declared valid in both the 12.1.1 and 12.2.2 releases and is referenced by the ETRM (E-Business Suite Technical Reference Manual) as a reporting and integration object.

Because the view restricts its output to tax lines only, it provides a focused data set that simplifies the construction of tax-related reports, extracts, and interface queries without requiring the caller to re-implement the tax-line predicate. This makes it useful for reconciliation of tax amounts, audit of tax-exempt transactions, and feeds into downstream reporting or conversion programs.

Underlying Base Objects

The view is defined over a single documented base object, RA_CUSTOMER_TRX_LINES_ALL, accessed through a synonym. The defining query selects from this table with the alias CTL and applies a filter restricting rows to those where LINE_TYPE equals 'TAX'. Consequently, ARBV_TAXES returns one row for each tax line on a Receivables transaction, and its columns are drawn directly from the corresponding columns of RA_CUSTOMER_TRX_LINES_ALL, with certain attributes transformed into descriptive lookups.

Several columns in the view extract meaning values from Oracle Receivables lookups rather than returning raw codes. The source columns for the reason code, tax-exempt reason code, and amount-includes-tax flag are mapped through AR_LOOKUPS to their MEANING values, so the view presents human-readable descriptions in place of internal lookup codes.

Key Columns

• TRANSACTION_LINE_ID — Unique identifier of the tax line; corresponds to CUSTOMER_TRX_LINE_ID in the base table and serves as the view's unique attribute.
• AMOUNT — The extended amount of the tax line (EXTENDED_AMOUNT).
• _LA:REASON — Descriptive meaning of the invoicing reason code, derived from AR_LOOKUPS.
• TAX_RATE — The tax rate applied to the line.
• TAX_EXEMPTION_CERTIFICATE_NUM — The tax exemption certificate number associated with the tax line.
• _LA:TAX_EXEMPT_REASON — Descriptive meaning of the tax-exempt reason code, derived from the TAX_REASON lookup type.
• _LA:TAX_INCLUSIVE_FLAG — Descriptive meaning of the amount-includes-tax flag (Yes/No), derived from AR_LOOKUPS.
• CUSTOMER_TRX_ID — Identifier of the parent transaction header.
• PREVIOUS_CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_LINE_ID — References to the prior transaction and line, supporting credit and adjustment relationships.
• INITIAL_CUSTOMER_TRX_LINE_ID, LINK_TO_CUST_TRX_LINE_ID — References to the originating line and any linked line used for tracking transaction lineage.
• ORG_ID — Operating unit identifier, enabling multi-org filtering.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY provide audit information.

Common Use Cases and Queries

Typical usage includes extracting total tax by transaction, validating exemption certificates, and reconciling tax lines to general ledger entries. The following query retrieves tax lines for a given transaction:

• SELECT transaction_line_id, amount, tax_rate, tax_exemption_certificate_num FROM arbv_taxes WHERE customer_trx_id = :p_trx_id;
• SELECT customer_trx_id, SUM(amount) FROM arbv_taxes WHERE org_id = :p_org_id GROUP BY customer_trx_id;
• SELECT transaction_line_id, amount, "_LA:TAX_EXEMPT_REASON" FROM arbv_taxes WHERE tax_exemption_certificate_num IS NOT NULL;

Note that the descriptive lookup columns carry names containing colons and therefore require double quotation marks when referenced in SQL.