Results for “ap_awt_temp_distributions_v”

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

Overview

The AP_AWT_TEMP_DISTRIBUTIONS_V view is an Oracle Applications (APPS) schema database object residing in the Oracle E-Business Suite Payables (AP) module. It exposes withholding tax distribution data, combining temporary withholding tax distribution records with group, tax rate, and invoice information. The view is documented as a Release 10SC-only object, meaning it was introduced to support the automatic withholding tax (AWT) feature during that release cycle. It remains a VALID object in the APPS schema across EBS 12.1.1 and 12.2.2 environments where it has been carried forward.

The view presents, for each withholding tax distribution line, the invoice it belongs to, the accounting date, the tax code combination, the withholding group name, the tax name, the applicable tax rate, and rounded gross and withholding amounts expressed in the invoice currency. Its role is primarily reporting and integration: it furnishes a denormalized, ready-to-consume projection of withholding tax liability per invoice without requiring consumers to join four separate base objects themselves.

Underlying Base Objects

The view is defined over four synonym-referenced base tables and one PL/SQL package:

• AP_AWT_TEMP_DISTRIBUTIONS — the driving table (alias ATD), holding the temporary withholding tax distribution rows keyed by INVOICE_ID, GROUP_ID, and TAX_RATE_ID.
• AP_AWT_GROUPS — the withholding tax group definition (alias ATG), joined on GROUP_ID to supply the group NAME.
• AP_AWT_TAX_RATES — the withholding tax rate definition (alias ATR), joined on TAX_RATE_ID to supply TAX_RATE.
• AP_INVOICES — the invoice header (alias AI), joined on INVOICE_ID, used for the exchange rate and invoice currency code.
• AP_UTILITIES_PKG — a PL/SQL package whose AP_ROUND_CURRENCY function is invoked in the SELECT list for currency rounding.

The join logic is an inner join across all four tables, so a row appears only when the distribution, its group, its tax rate, and the parent invoice all resolve.

Key Columns

• INVOICE_ID — identifier of the parent invoice in AP_INVOICES.
• ACCOUNTING_DATE — accounting date of the withholding tax distribution.
• TAX_CODE_COMBINATION_ID — accounting flexfield combination identifying the withholding tax liability account.
• NAME — name of the withholding tax group from AP_AWT_GROUPS.
• TAX_NAME — descriptive name of the withholding tax.
• TAX_RATE — the withholding tax rate applied, sourced from AP_AWT_TAX_RATES.
• GROSS_AMOUNT — the gross amount converted to invoice currency and rounded via AP_ROUND_CURRENCY (ATD.GROSS_AMOUNT divided by NVL(AI.EXCHANGE_RATE,1)).
• WITHHOLDING_AMOUNT — the withholding amount similarly converted and rounded in the invoice currency.

Common Use Cases and Queries

Typical reporting needs include withholding tax liability by invoice, reconciliation of temporary AWT distributions against posted distributions, and audit extracts of tax rates applied per invoice. The invoice-currency rounding performed inside the view means consumers receive presentation-ready amounts without additional conversion logic.

A representative query retrieving withholding tax detail for a given invoice:

• SELECT invoice_id, accounting_date, tax_code_combination_id, name, tax_name, tax_rate, gross_amount, withholding_amount FROM ap_awt_temp_distributions_v WHERE invoice_id = :p_invoice_id;

A summary aggregation by withholding group and tax name supports liability roll-ups:

• SELECT name, tax_name, tax_rate, SUM(withholding_amount) FROM ap_awt_temp_distributions_v GROUP BY name, tax_name, tax_rate ORDER BY name, tax_name;

Because the object is documented as Release 10SC only, implementations should confirm its presence and continued population in the target release before relying on it for production reporting, and should validate results against the underlying AP_AWT_TEMP_DISTRIBUTIONS table.