Results for “from_subinventory”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_MTL_TRXS is an Oracle E-Business Suite table owned by the JA (Asia/Pacific Localizations) schema that stores India-specific tax data associated with inter-organization inventory transfers. The table captures the fiscal attributes required by Indian excise, VAT, and GST legislation whenever material moves between inventory organizations, ensuring that statutory documents such as excise invoices, VAT invoices, and GST invoices can be generated and reconciled against the underlying material transaction. Because inter-org transfers are treated as taxable events in the Indian localization, this table acts as the bridge between standard Oracle Inventory transactions and the India tax reporting engine.

From a dimensional modeling perspective, the ETRM metadata assigns a heuristic Data Vault classification of link. This suggests that JAI_MTL_TRXS functions primarily as an associative structure that connects a source organization, a destination organization, an inventory item, a transaction type, and a tax category. In a Data Vault 2.0 implementation it would most naturally be modeled as a link table with references to the underlying hubs for organization, item, and transaction type, rather than as a standalone hub or satellite.

Key Information Stored

The table contains 30 documented columns. The most significant are the following:

• TRANSACTION_ID — the surrogate primary key, enforced by the unique index JAI_MTL_TRXS_U1 and the JAI_MTL_TRXS_PK constraint.
• TRANSACTION_HEADER_ID and TRANSACTION_TEMP_ID — identifiers linking the tax record back to the corresponding inventory transaction header and the temporary staging record used during transaction processing.
• TRANSACTION_TYPE_ID — foreign key to MTL_TRANSACTION_TYPES, identifying the specific inter-org movement type.
• FROM_ORGANIZATION and TO_ORGANIZATION — the source and destination inventory organizations for the transfer.
• INVENTORY_ITEM_ID — foreign key to MTL_SYSTEM_ITEMS_B, identifying the item being transferred.
• FROM_SUBINVENTORY and TO_SUBINVENTORY — the subinventories involved in the movement.
• QUANTITY, TRANSACTION_UOM, and TRANSACTION_DATE — the quantity moved, the unit of measure, and the effective transaction date.
• TAXCATEGORY_ID — foreign key to JAI_CMN_TAX_CTGS_ALL, defining the tax category applied to the transfer.
• TAX_AMOUNT, ASSESSABLE_VALUE, and SELLING_PRICE — the computed tax and valuation amounts used on the statutory invoice.
• EXCISE_INVOICE_NO, VAT_INVOICE_NO, and GST_INVOICE_NO — the document numbers of the generated tax invoices.
• VAT_ASSESSABLE_VALUE and GST_ASSESSABLE_VALUE — separate assessable values maintained for VAT and GST reporting regimes.
• QTY_REGISTER and AMT_REGISTER — the quantities and amounts posted to the statutory registers.

Common Use Cases and Queries

Typical use cases include reconciling inter-org transfers against excise and GST registers, regenerating missing tax invoices, and auditing tax amounts by organization or item. A representative query joins the table to the item master and tax category to report GST liability:

• Reporting total GST assessable value and tax amount by FROM_ORGANIZATION and transaction date.
• Identifying transfers missing a GST_INVOICE_NO for statutory compliance follow-up.
• Reconciling QTY_REGISTER against MTL_MATERIAL_TRANSACTIONS quantities for the same period.
• Extracting EXCISE_INVOICE_NO and ASSESSABLE_VALUE feeds for excise return preparation.

A typical join pattern is:

SELECT t.TRANSACTION_ID, i.SEGMENT1, t.FROM_ORGANIZATION, t.TAX_AMOUNT, t.GST_INVOICE_NO FROM JA.JAI_MTL_TRXS t, MTL_SYSTEM_ITEMS_B i WHERE t.INVENTORY_ITEM_ID = i.INVENTORY_ITEM_ID AND t.TRANSACTION_DATE BETWEEN :p_from AND :p_to;

Related Objects

The following objects are the most significant related to JAI_MTL_TRXS, based on documented foreign key relationships and localization dependencies:

• MTL_SYSTEM_ITEMS_B — joined on INVENTORY_ITEM_ID to resolve item attributes.
• JAI_CMN_TAX_CTGS_ALL — joined on TAXCATEGORY_ID to retrieve tax category definitions.
• MTL_TRANSACTION_TYPES — joined on TRANSACTION_TYPE_ID to identify the movement type.
• MTL_MATERIAL_TRANSACTIONS — the parent inventory transaction table, used for quantity and cost reconciliation.
• JAI_CMN_TAX_RATES — provides the rate definitions applied to the tax category.
• JAI_AR_TRXS — the India localization table for AR-related tax transactions, sharing a similar structure for reporting integration.
• ORG_ORGANIZATION_DEFINITIONS — resolves FROM_ORGANIZATION and TO_ORGANIZATION to organization names.