Search Results ap_awt_buckets_v




Overview
Explore in AI Chat

Overview

AP_AWT_BUCKETS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, residing in the Payables (AP) product family. Its documented purpose is to expose withholding tax bucket balances accumulated against suppliers, presented with descriptive supplier attributes to facilitate reporting and reconciliation. The view joins the withholding tax bucket base table to the supplier master to resolve the vendor name and vendor number, allowing a report or concurrent program to display human-readable supplier information alongside tax withholding totals without requiring additional lookup logic in the calling code.

The ETRM metadata records this object as VALID in both Oracle EBS 12.1.1 and 12.2.2, although the original documentation excerpt carries the notation "Release 10SC only." That notation reflects the vintage of the source documentation rather than a restriction on the current release; the view remains present and valid in the APPS schema in the supported 12.x releases. Because withholding tax bucket data is maintained at the supplier and tax level, the view serves primarily as a denormalized read interface for withholding analysis, supplier tax reporting, and downstream extracts.

Underlying Base Objects

The view is defined over two documented base objects:

  • AP_AWT_BUCKETS (SYNONYM) — The withholding tax bucket table, which stores accumulated gross and withheld amounts per supplier, period, and tax. This is the driving table and supplies the transactional and audit columns.
  • PO_VENDORS (VIEW) — The supplier master, referenced to resolve VENDOR_NAME and SEGMENT1 (the supplier number) for each VENDOR_ID.

The join condition documented in the view text is V.VENDOR_ID = AB.VENDOR_ID, an inner join between PO_VENDORS and AP_AWT_BUCKETS. Because it is an inner equi-join on VENDOR_ID, records in AP_AWT_BUCKETS whose supplier does not resolve through PO_VENDORS are excluded from the result set. The view exposes the vendor identifier from the bucket table (AB.VENDOR_ID) rather than from the supplier master, which is functionally equivalent given the join predicate.

Key Columns

Common Use Cases and Queries

The view is typically queried to report withholding tax accumulations by supplier and period, and to reconcile bucket balances before generating withholding tax reporting or certification. A representative query restricting to a specific period and operating unit is shown below:

  • Withholding tax by supplier and period:
    SELECT vendor_name, segment1, period_name, tax_name, withheld_amount_to_date, gross_amount_to_date FROM ap_awt_buckets_v WHERE period_name = :period AND org_id = :org_id ORDER BY vendor_name, tax_name;
  • Supplier-level withholding summary across periods:
    SELECT vendor_name, segment1, tax_name, SUM(withheld_amount_to_date) total_withheld FROM ap_awt_buckets_v GROUP BY vendor_name, segment1, tax_name;
  • Audit and extract queries filtering on LAST_UPDATE_DATE or PROGRAM_ID track which concurrent request refreshed bucket rows for downstream ETL and reconciliation.

Because the underlying bucket table is populated by the withholding tax processing programs, query results should be interpreted in the context of the operating unit (ORG_ID) and period in which the withholding was accrued. Reports querying this view should always filter by ORG_ID in multi-organization implementations to avoid aggregating balances across operating units.