Search Results ap_awt_group_taxes_pk

Overview

The AP_AWT_GROUP_TAXES_ALL table is a core data object within the Oracle E-Business Suite Payables module (AP). It functions as the master repository for defining the relationship between Withholding Tax Groups and the specific withholding tax codes assigned to them. In Oracle Payables, Automatic Withholding Tax (AWT) groups are used to efficiently apply multiple tax rates to a single invoice line. This table, therefore, is critical for the configuration and operation of the AWT functionality, enabling the system to determine which taxes are applicable when a specific withholding group is selected on an invoice or invoice line. Its ALL suffix indicates it is a multi-organization access control (MOAC) enabled table, storing data for all operating units.

Key Information Stored

The table's structure is defined by its primary key, which consists of two columns. The GROUP_ID column is a foreign key that links to the AP_AWT_GROUPS table, uniquely identifying a specific withholding tax group. The TAX_NAME column stores the name of the specific withholding tax code (e.g., a tax authority or rate name) that is a member of that group. The combination of these two fields ensures that a given tax is assigned to a specific group only once. While the provided metadata does not list additional columns, typical related data might include creation dates, last update dates, and identifiers for the user who created the record, which are standard in Oracle EBS tables.

Common Use Cases and Queries

This table is primarily accessed for setup validation, troubleshooting, and reporting on AWT group assignments. A common operational query is to list all tax codes assigned to a specific group for verification purposes. For example: SELECT tax_name FROM ap_awt_group_taxes_all WHERE group_id = :group_id ORDER BY tax_name;. Conversely, to find all groups a specific tax code belongs to, one would query: SELECT group_id FROM ap_awt_group_taxes_all WHERE tax_name = :tax_name;. During invoice processing, the Payables engine references this table to identify which tax calculations to perform when a group is applied. Reporting use cases often involve joining this table to AP_AWT_GROUPS and AP_AWT_TAX_CODES_ALL to generate summaries of group composition by operating unit.

Related Objects

AP_AWT_GROUP_TAXES_ALL has a fundamental relationship with the AP_AWT_GROUPS table, as defined by its sole foreign key constraint (AP_AWT_GROUP_TAXES_ALL.GROUP_ID references AP_AWT_GROUPS). The tax codes stored in the TAX_NAME column typically correspond to codes defined in the AP_AWT_TAX_CODES_ALL table. The primary key constraint AP_AWT_GROUP_TAXES_PK enforces data integrity for the GROUP_ID and TAX_NAME combination. This table is also a key reference for the underlying PL/SQL logic in the Payables tax engine and is often joined in views that present consolidated withholding tax information for users and other application processes.