Search Results jai_inv_itm_setups




Overview
Explore in AI Chat

Overview

The JAI_INV_ITM_SETUPS table is a core data repository within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module (product code JA). It functions as a master table for storing country-specific, or localized, item attributes that are defined at the organization level. This table is critical for enabling region-specific legal and tax compliance, particularly for countries like India, where statutory reporting requirements necessitate extended item data beyond the standard Oracle Inventory definitions. Its role is to extend the standard item master (MTL_SYSTEM_ITEMS_B) by providing a mandatory, organization-specific context for localization attributes, ensuring that item-level localization rules are correctly applied in transactional and reporting processes.

Key Information Stored

The table's structure is anchored by a composite primary key consisting of INVENTORY_ITEM_ID and ORGANIZATION_ID. This design enforces a one-to-one relationship with the item master at the organization level, meaning each item-organization combination can have only one set of localization setups. While the provided metadata does not list specific attribute columns, the table's description indicates it holds "localization item attributes." Based on the module's context, these attributes typically include critical regulatory details such as Excise Tariff Codes, CENVAT credit eligibility flags, VAT classifications, and other statutory identifiers mandated by specific Asia/Pacific jurisdictions. The foreign key relationship to MTL_SYSTEM_ITEMS_B validates that the item and organization exist in the core inventory system.

Common Use Cases and Queries

This table is primarily accessed for configuring items for localized transactions and for generating statutory reports. A common operational use case is verifying if an item has been set up for localization before processing a transaction like a goods receipt or invoice. For reporting, data from this table is often joined with transactional tables to compile excise or VAT registers. A fundamental query pattern retrieves the localization setup for a specific item in a given organization:

  • SELECT * FROM jai.jai_inv_itm_setups js WHERE js.inventory_item_id = :p_item_id AND js.organization_id = :p_org_id;

Another typical query joins with the item master to list all items with their localization status:

  • SELECT msi.segment1 item_code, msi.description, js.* FROM mtl_system_items_b msi LEFT JOIN jai.jai_inv_itm_setups js ON msi.inventory_item_id = js.inventory_item_id AND msi.organization_id = js.organization_id WHERE msi.organization_id = :p_org_id;

Related Objects

The JAI_INV_ITM_SETUPS table is a central reference point for numerous transactional and compliance tables within the JA localization schema, as evidenced by its extensive foreign key relationships. The documented child tables that reference its primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID) include:

These relationships indicate that the item-level setups are directly used in recording transactions for various excise (RG) registers, component details, and shipping line integrations. The primary parent table is MTL_SYSTEM_ITEMS_B, which supplies the valid item and organization master data.