Results for “as_tax_lines_summary_v”

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

Overview

The AS_TAX_LINES_SUMMARY_V view belongs to the Oracle E-Business Suite Sales Foundation (AS) module and supports sales tax calculation within the Oracle Quoting / Sales application. Its documented purpose is to present summarized tax line information that the tax engine consumes when determining tax on quote lines. The view exposes a flattened, denormalized rowset combining quote header data, quote line data, ship-to and bill-to address attributes, currency formatting information, order type identifiers, and tax code definitions sourced from AR_VAT_TAX. This structure allows the tax calculation engine to evaluate applicable tax rules against the customer, location, item, and amount context of each quote line without needing to join the numerous transactional base tables directly.

The presence of the underlying AR_VAT_TAX table — the classic Oracle Receivables tax codes repository — explains why users searching for "ar_vat_tax" often surface this object. In EBS 12.1.1 and 12.2.2 the tax determination model still relies heavily on AR_VAT_TAX for legacy tax scenarios, and this view acts as an integration layer between the AS quoting tables and that repository.

Underlying Base Objects

The ETRM metadata records no formally documented base tables for this view, and it is noted as "Not implemented in this database," indicating it exists as a definition only in environments where the appropriate AS and AR objects are deployed. The view text in the documentation reveals the following referenced objects:

• RA_ADDRESSES (aliased BILL and SHIP) — invoice-to and ship-to postal addresses.
• RA_SITE_USES (aliased BILL_SITE and SHIP_SITE) — site-use relationships linking parties to addresses.
• FND_CURRENCIES — currency code and precision.
• AS_QUOTES — quote header, carrying tax exemption flags, exchange rate, FOB code, and organization.
• AS_QUOTE_LINES — line-level item, quantity, pricing, and tax code.
• SO_ORDER_TYPES — customer transaction type identifier.
• AR_VAT_TAX (aliased TG and V) — tax code definition, including the amount-includes-tax flag.
• PER_ASSIGNMENTS_F — employee assignment for organization derivation.

The outer joins (marked with (+)) on currency, site use, address, order type, and assignment tables ensure a quote line is still returned even when optional descriptive attributes are absent.

Key Columns

• Customer identifiers — SHIP.CUSTOMER_ID and BILL.CUSTOMER_ID for ship-to and bill-to parties.
• Quote identifiers — QUOTE_ID and QUOTE_LINE_ID.
• Tax code — V.TAX_CODE, drawn from AR_VAT_TAX.
• Location/postal data — POSTAL_CODE and LOCATION_ID for both addresses.
• Item and quantity — INVENTORY_ITEM_ID and QUANTITY.
• Exemption attributes — TAX_EXEMPT_FLAG, TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE.
• Amount basis — computed taxable amount from LINE_QUOTE_PRICE, LINE_LIST_PRICE, and TOTAL_DISCOUNT_PERCENT.
• Currency — CURRENCY_CODE and PRECISION.
• Tax inclusion flag — NVL(V.AMOUNT_INCLUDES_TAX_FLAG,'N').
• Organization — QL.ORGANIZATION_ID and a derived ORG_ID via PER_ASSIGNMENTS_F.
• Transaction type — SO.CUST_TRX_TYPE_ID.

Common Use Cases and Queries

This view is typically leveraged by the tax engine and by developers troubleshooting tax calculation on quotes. Common uses include reconciling the taxable amount applied to a quote line, verifying exemption handling, and mapping quote tax codes back to AR_VAT_TAX definitions. A representative query:

• SELECT TAX_CODE, QUOTE_ID, QUOTE_LINE_ID, CURRENCY_CODE, QUANTITY FROM AS_TAX_LINES_SUMMARY_V WHERE QUOTE_ID = :p_quote_id;
• SELECT TAX_CODE, SUM(QUANTITY) FROM AS_TAX_LINES_SUMMARY_V GROUP BY TAX_CODE;
• SELECT a.TAX_CODE, t.TAX_RATE FROM AS_TAX_LINES_SUMMARY_V a, AR_VAT_TAX t WHERE a.TAX_CODE = t.TAX_CODE;

Because the view spans multiple modules, always validate that the AS quoting tables are present in the target environment before relying on it for production reporting.