Search Results l_taxable_amount

Overview

AX_MC_AP_TAXABLE_V is a reporting view belonging to the AX - Global Accounting Engine product (also referred to as AX or Global Accounting Engine, the multi-currency accounting engine used in Oracle E-Business Suite). The view consolidates tax-related Payables invoice distribution data across multiple sets of books, exposing taxable amounts in both entered and base currency form. Its name derives from "MC" (Multi-Currency) and "AP" (Accounts Payable), signalling its purpose: providing a taxable base for multi-currency AP tax reporting and downstream processing.

The view is relevant to the localisation and global accounting functions where tax and withholding amounts must be reported per set of books. The user-supplied search term l_taxable_amount corresponds directly to the primary derived column exposed by this view, which aggregates the taxable amount for tax and withholding lines. Because the ETRM metadata records "Not implemented in this database," the object may not be instantiated in every environment; it is typically seeded as part of the AX module's multi-currency tax reporting functionality.

Underlying Base Objects

The view is defined over three documented base objects, joined to establish the relationship between taxable item distributions and their associated tax/withholding charge distributions:

• AP_INVOICE_DISTRIBUTIONS_ALL AID2 — supplies the tax code and VAT code (TAX_CODE_ID, VAT_CODE) for the tax distribution line.
• AP_MC_INVOICE_DISTS AMD / AMD2 — the multi-currency invoice distributions table, referenced twice. AMD represents the taxable source (item) distribution; AMD2 represents the tax or withholding distribution. This self-join is the mechanism by which the taxable amount is linked to the tax line.
• AP_CHRG_ALLOCATIONS_ALL ACA — the charge allocation table that maps an item distribution (ITEM_DIST_ID) to a charge distribution (CHARGE_DIST_ID), completing the bridge between taxable items and tax lines.

The join conditions require that AMD.INVOICE_DISTRIBUTION_ID = ACA.ITEM_DIST_ID, ACA.CHARGE_DIST_ID = AMD2.INVOICE_DISTRIBUTION_ID, and AID2.INVOICE_DISTRIBUTION_ID = AMD2.INVOICE_DISTRIBUTION_ID, with a further restriction that AMD2.SET_OF_BOOKS_ID = AMD.SET_OF_BOOKS_ID. Only distributions whose LINE_TYPE_LOOKUP_CODE is 'TAX' or 'AWT' (withholding) are included.

Key Columns

• SET_OF_BOOKS_ID — identifies the ledger (set of books) to which the aggregated amounts belong.
• INVOICE_ID — the AP invoice header identifier.
• INVOICE_DISTRIBUTION_ID — the distribution identifier of the tax/withholding line being reported.
• TAX_CODE_ID — the tax code identifier from AP_INVOICE_DISTRIBUTIONS_ALL.
• VAT_CODE — the VAT code associated with the distribution.
• L_TAXABLE_AMOUNT — SUM(AMD.AMOUNT), the taxable amount in the entered currency.
• L_TAXABLE_BASE_AMOUNT — SUM(NVL(AMD.BASE_AMOUNT, AMD.AMOUNT)), the taxable amount in base currency, defaulting to the entered amount where no base amount is recorded.

Common Use Cases and Queries

This view is typically used to source taxable amounts for tax reporting, reconciliation and integrations. A representative query is:

• SELECT set_of_books_id, invoice_id, invoice_distribution_id, tax_code_id, vat_code, l_taxable_amount, l_taxable_base_amount FROM ax_mc_ap_taxable_v WHERE set_of_books_id = :p_sob AND invoice_id = :p_invoice;
• Summarising taxable amounts by tax code for a reporting period.
• Feeding multi-currency VAT and withholding analysis reports or AX subledger accounting extracts.

Because the object is documented as not implemented in the reference database, verify existence in the target instance before relying on it in custom code.