Search Results orig_tax_code

Overview

ASO_TAX_DETAILS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, registered under the ASO - Order Capture product family. It is documented in ETRM as a view based on the ASO_TAX_DETAILS table, exposing the complete set of tax detail attributes stored for quotes and quote lines. The view is marked VALID in the data dictionary and is available in both 12.1.1 and 12.2.2 environments.

The view functions as a read-oriented projection of quote-level tax information. Its principal value in reporting and integration is that it presents party, tax code, tax rate, tax amount, exemption data, and the tax_date column in a single, stable structure that can be queried directly by custom reports, extracts, and interfaces without navigating the base transaction tables. Because it is a simple pass-through view rather than a join-heavy construct, it performs predictably under concurrent access and is suitable for operational reporting on quotation tax computations.

Underlying Base Objects

The documented object list for this view specifies three referenced base objects:

• ASO_TAX_DETAILS (SYNONYM) — the primary base object; the view text is a direct SELECT of all columns from this table.
• ZX_RATES_B (SYNONYM) — the tax rates base table referenced by the ETRM object list, providing rate definition and effective-dating context for TAX_RATE values.
• ZX_TAXES_VL (VIEW) — the multilingual tax definition view, supplying tax code and tax name context for ORIG_TAX_CODE and TAX_CODE.

Although the documented view text shows an unfiltered projection from ASO_TAX_DETAILS, the ETRM object list confirms a functional relationship to the ZX (E-Business Tax) rate and tax definition objects. In 12.2.2 with the E-Business Tax engine, tax codes are resolved against ZX configuration, so the ZX references are relevant when reconciling TAX_CODE, TAX_RATE, and TAX_DATE against the tax repository. The view itself does not enforce a join; consumers requiring tax descriptions or rate history typically join to ZX_TAXES_VL and ZX_RATES_B separately.

Key Columns

• TAX_DETAIL_ID — primary key and unique identifier for each tax detail record.
• QUOTE_HEADER_ID, QUOTE_LINE_ID, QUOTE_SHIPMENT_ID — foreign keys anchoring the tax line to a quote, quote line, and shipment.
• ORIG_TAX_CODE / TAX_CODE — the originating and current tax code applied to the quote line.
• TAX_RATE — the rate applied to the taxable basis.
• TAX_DATE — the effective tax date for the detail row; critical for rate and rule determination and for period-based tax reporting.
• TAX_AMOUNT — the calculated tax amount.
• TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE — exemption indicators and supporting values.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — DFF columns available for customer extension.
• Standard WHO and concurrent program columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include reconciling quote tax against the E-Business Tax repository, extracting tax detail for audit, and reporting tax amounts by date. A representative query filtering by tax_date:

SELECT quote_header_id, quote_line_id, tax_code, tax_rate, tax_amount, tax_date FROM aso_tax_details_v WHERE tax_date >= :from_date AND tax_date < :to_date;

To aggregate tax by quote and period:

SELECT quote_header_id, TRUNC(tax_date,'MM') tax_month, SUM(tax_amount) total_tax FROM aso_tax_details_v GROUP BY quote_header_id, TRUNC(tax_date,'MM');

Exemption reporting can be driven from the same view: SELECT quote_line_id, tax_code, tax_exempt_flag, tax_exempt_number FROM aso_tax_details_v WHERE tax_exempt_flag = 'Y';