Search Results jai_cmn_tax_ctg_lines




Overview
Explore in AI Chat

Overview

The JAI_CMN_TAX_CTG_LINES table is a core data object within the Asia/Pacific Localizations (product JA) of Oracle E-Business Suite releases 12.1.1 and 12.2.2. It functions as a junction table that establishes and stores the association between defined tax categories and specific tax rates. Its primary role is to support the complex tax configuration requirements common to many jurisdictions in the Asia/Pacific region by enabling a single tax category to be linked to multiple applicable taxes. This structure is fundamental for accurate tax determination and calculation on transactions such as invoices and purchase orders within the localized modules.

Key Information Stored

The table's structure is defined by a composite primary key, which ensures a unique combination of a tax category and a tax. The key columns are the primary data points stored:

  • TAX_CATEGORY_ID: A foreign key column that stores the unique identifier for a tax category, as defined in the parent table JAI_CMN_TAX_CTGS_ALL. This represents a classification or grouping (e.g., "Standard Rated Goods," "Exempt Services").
  • TAX_ID: A foreign key column that stores the unique identifier for a specific tax rate or regime, as defined in the related table JAI_CMN_TAXES_ALL. This links the actual tax percentage or rule to the category.

Together, these two columns form the primary key (JAI_CMN_TAX_CTG_LINES_PK), meaning each record represents a distinct, valid pairing of a category to a tax.

Common Use Cases and Queries

This table is central to tax setup and inquiry processes. A primary use case is during transaction entry, where the system queries this table to determine all taxes applicable to a selected tax category. It is also critical for tax configuration reports and validation scripts. Common SQL patterns involve joining to the related master tables to retrieve descriptive information.

Sample Query: Listing All Taxes for a Specific Tax Category
This query retrieves the tax names and codes associated with a given tax category name.

SELECT ctg.tax_category_code,
       ctg.tax_category_name,
       tx.tax_name,
       tx.tax_code
FROM   jai_cmn_tax_ctg_lines ctl,
       jai_cmn_tax_ctgs_all  ctg,
       jai_cmn_taxes_all     tx
WHERE  ctl.tax_category_id = ctg.tax_category_id
AND    ctl.tax_id = tx.tax_id
AND    ctg.tax_category_code = 'STANDARD'; -- Example category code

Related Objects

The JAI_CMN_TAX_CTG_LINES table sits between two key master data tables, as defined by its foreign key constraints:

  • JAI_CMN_TAX_CTGS_ALL: The parent table for tax categories. The relationship is maintained via the column JAI_CMN_TAX_CTG_LINES.TAX_CATEGORY_ID, which references JAI_CMN_TAX_CTGS_ALL. This join provides the descriptive details of the tax category.
  • JAI_CMN_TAXES_ALL: The parent table for tax definitions. The relationship is maintained via the column JAI_CMN_TAX_CTG_LINES.TAX_ID, which references JAI_CMN_TAXES_ALL. This join provides the detailed tax rate, type, and other regulatory attributes.

These relationships are integral, ensuring that only valid, pre-defined categories and taxes can be linked, maintaining referential integrity within the tax configuration subsystem.