Search Results jl_zz_ap_supp_awt_types




Overview
Explore in AI Chat

Overview

The JL.JL_ZZ_AP_SUPP_AWT_TYPES table is a Latin America Localizations (JL) object that stores withholding applicability information at the supplier level for Argentina and Colombia. It serves as the driver table that determines whether a given supplier is subject to a specific withholding regime, and under what tax authority, exemption, or multilateral agreement conditions. In the Oracle EBS 12.1.1 and 12.2.2 data model, this is a customization/localization table layered over Oracle Payables (AP), linked to supplier records through VENDOR_ID and consumed downstream by withholding code assignments and tax calculation logic.

From the documented ETRM relationship data, the table is classified heuristically as standalone in a Data Vault sense. In practical terms, this suggests it functions closest to a satellite attached to the supplier (vendor) hub, since each row describes descriptive withholding attributes keyed primarily by supplier. There is no mined FK from this table outward, but the table is referenced by JL_ZZ_AP_SUP_AWT_CD_ALL, making it a parent/master record for detailed withholding code lines.

Key Information Stored

The table contains 32 documented columns, but the following are the most significant for functional and reporting purposes:

The distinction between the surrogate key (SUPP_AWT_TYPE_ID) and the business key (VENDOR_ID, AWT_TYPE_CODE) is important for integrations: external systems should reference the business key where possible, while EBS internal joins typically use the surrogate.

Common Use Cases and Queries

Typical scenarios include supplier withholding eligibility reporting, exemption validity checks, and multilingual/multilateral agreement rate lookups for Argentina and Colombia. A common query pattern joins supplier withholding types to their associated withholding codes:

  • Determine whether a supplier is subject to withholding for a given tax: filter on VENDOR_ID and WH_SUBJECT_FLAG = 'Y'.
  • Identify suppliers with active exemptions as of an accounting date: EXEMPTION_START_DATE <= :p_date AND (EXEMPTION_END_DATE IS NULL OR EXEMPTION_END_DATE >= :p_date).
  • Report multilateral agreement rates by joining on SUPP_AWT_TYPE_ID to JL_ZZ_AP_SUP_AWT_CD_ALL.

These queries are frequently used in payment auditing, tax reporting extracts, and reconciliation of withholding entries in the Payables subledger.

Related Objects

  • JL_ZZ_AP_SUP_AWT_CD_ALL — Child table; joins on SUPP_AWT_TYPE_ID to retrieve withholding code detail rows.
  • JL_ZZ_AP_SUPP_AWT_TYPES_PK — Primary key constraint on SUPP_AWT_TYPE_ID.
  • JL_ZZ_AP_SUPP_AWT_TYPES_U1 — Unique index on SUPP_AWT_TYPE_ID.
  • JL_ZZ_AP_SUPP_AWT_TYPES_U2 — Unique business key index on (VENDOR_ID, AWT_TYPE_CODE).
  • Oracle Payables Supplier tables (e.g., suppliers via VENDOR_ID) — parent supplier context.