Search Results ap_tax_codes




Overview
Explore in AI Chat

Overview

AP_TAX_LINES_SUMMARY_V is a Payables (AP) reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes summarized tax line information associated with invoice distributions. It is designed to present tax-related amounts and attributes at the invoice distribution level, combining invoice header information (invoice number, date, currency, exchange rate, vendor) with distribution-level detail (distribution line number, line type, set of books) and computed tax amounts derived from the Tax Engine. The view is used primarily in reporting and integration scenarios where tax lines must be reconciled, extracted for tax reporting, or passed to downstream systems such as ETRM, tax engines, and data warehouses.

Because the view contains a significant amount of embedded PL/SQL logic—calls to AP_UTILITIES_PKG, AP_TAX_ENGINE_PKG, and DECODE-driven calculations based on amount-includes-tax flags, tax type, and offset tax flags—it is intended for read-only reporting and extraction rather than transactional processing. In the documented metadata the view is marked as "Not implemented in this database," indicating that availability depends on the specific environment and patch level.

Underlying Base Objects

The documented metadata for this view does not enumerate explicit base objects. However, the view text references several core Payables and tax-related tables and packages, including AP_INVOICES_ALL (aliased AI), AP_INVOICE_DISTRIBUTIONS_ALL (aliased AID), PO_VENDORS (aliased POV), PO_VENDOR_SITES_ALL (aliased POVS), and tax setup entities such as AP_TAX_CODES (ATC1) and AP_TAX_GROUPS (ATG). The view also invokes AP_UTILITIES_PKG.AP_ROUND_CURRENCY, AP_TAX_ENGINE_PKG.GET_AMOUNT, and AP_TAX_ENGINE_PKG.SUM_TAX_GROUP_RATE to compute tax amounts and rounding at query time.

Because tax computation is performed dynamically, the view reflects the state of tax configuration at the time of query execution. It does not store tax amounts; instead it derives them from the invoice distribution amount, tax group rates, and vendor site settings.

Key Columns

Common Use Cases and Queries

Typical use cases include tax reconciliation, extracting tax lines for reporting, and analyzing tax by vendor, vendor site, or ledger. The view supports queries that compare computed tax against recorded tax and that break down tax by invoice date and vendor location.

SELECT invoice_num,
       invoice_date,
       vendor_name,
       distribution_line_number,
       line_type_lookup_code,
       set_of_books_id
FROM   ap_tax_lines_summary_v
WHERE  invoice_date BETWEEN :start_date AND :end_date
ORDER BY invoice_num, distribution_line_number;

Aggregation queries are also common, for example summing tax amounts by vendor or by currency to support reporting and analysis. Because the view performs dynamic tax computation, queries should be restricted by date and ledger to avoid excessive processing. Environments where the view is not implemented will return an invalid object error, so its availability should be confirmed against the ETRM metadata before use.