Search Results jai_mtl_trxs




Overview
Explore in AI Chat

Overview

The JAI_MTL_TRXS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed for the Asia/Pacific Localizations (product code JA). Its primary function is to store India-specific tax information associated with inter-organization inventory transfers. This table acts as a critical extension to standard inventory transaction data, ensuring compliance with Indian tax regulations by capturing and persisting tax-related attributes that are not part of the base Oracle Inventory tables. Its existence underscores the localization architecture of EBS, where country-specific legal requirements are implemented through supplementary schemas and objects.

Key Information Stored

The table's structure is centered around linking a standard inventory transaction to its corresponding Indian tax determinants. The primary key is the TRANSACTION_ID, which directly correlates to a transaction in the core inventory interface or transaction tables. Key columns include INVENTORY_ITEM_ID and FROM_ORGANIZATION, which identify the item and source organization involved in the transfer. Crucially, the TAXCATEGORY_ID column stores a reference to the applicable Indian tax category for the transaction, linking to the JAI_CMN_TAX_CTGS_ALL table. The TRANSACTION_TYPE_ID links to MTL_TRANSACTION_TYPES, classifying the nature of the inter-organization transfer for tax purposes.

Common Use Cases and Queries

The primary use case is the generation of tax-compliant documentation and reports for inter-organization stock transfers in India. This includes calculating excise duty, VAT, or GST liabilities based on the transfer value and the tax category. A common reporting query would join this table to inventory and tax master data. For example, to analyze transfers for a specific item, one might use a SQL pattern such as:

  • SELECT jmt.transaction_id, mtt.transaction_type_name, msib.segment1 item_code, jctc.tax_category_code FROM jai_mtl_trxs jmt JOIN mtl_system_items_b msib ON jmt.inventory_item_id = msib.inventory_item_id AND jmt.from_organization = msib.organization_id JOIN mtl_transaction_types mtt ON jmt.transaction_type_id = mtt.transaction_type_id JOIN jai_cmn_tax_ctgs_all jctc ON jmt.taxcategory_id = jctc.taxcategory_id WHERE msib.segment1 = '<ITEM>';

Data is typically populated by the localization's transaction processing logic during the completion of an inter-organization transfer.

Related Objects

JAI_MTL_TRXS is integrally connected to several key EBS objects via foreign key relationships, as documented in the ETRM. These relationships are essential for maintaining data integrity and enabling comprehensive queries.

  • MTL_SYSTEM_ITEMS_B: Joined via INVENTORY_ITEM_ID and FROM_ORGANIZATION to retrieve item master information.
  • JAI_CMN_TAX_CTGS_ALL: Joined via TAXCATEGORY_ID to obtain the specific Indian tax category details applicable to the transaction.
  • MTL_TRANSACTION_TYPES: Joined via TRANSACTION_TYPE_ID to classify the inventory transaction (e.g., Inter-organization Transfer).

The table's primary key constraint, JAI_MTL_TRXS_PK on TRANSACTION_ID, ensures each inventory transaction has a unique tax record in this localization table.