Search Results jai_cmn_st_forms




Overview
Explore in AI Chat

Overview

The JAI_CMN_ST_FORMS table is a core data repository within the Oracle E-Business Suite Asia/Pacific Localizations module (product code JA). Its primary function is to store master reference information pertaining to Sales Tax (ST) forms used in specific regional implementations, such as those required for India. This table acts as a foundational lookup, defining the various types of statutory forms (e.g., Form C, Form F, Form H, Form I) that can be associated with transactions to comply with local tax regulations. It enables the system to validate, track, and report on transactions based on the applicable statutory form, which is critical for accurate tax determination and legal compliance in supported jurisdictions.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure centers on the unique identification and description of each form type. The primary key, FORM_ID, is the unique system identifier for each ST form record. Based on the table's purpose, other typical columns would include a form code (e.g., 'C'), a descriptive name, an effective date range (START_DATE, END_DATE), and status indicators to control active usage. The table also contains the foreign key column ST_HDR_ID, which links the form definition to specific transactional header records stored in the JAI_CMN_STFORM_HDRS_ALL table.

Common Use Cases and Queries

This table is primarily referenced during transaction entry and tax reporting processes. When a user applies a statutory form to an invoice or receipt, the system validates the form type against active records in JAI_CMN_ST_FORMS. Common reporting use cases include generating lists of all available forms or analyzing transaction volumes by form type. A typical query would join this table to transactional headers to retrieve form details.

SELECT stf.form_code,
       stf.description,
       hdr.transaction_number,
       hdr.customer_id
FROM   jai_cmn_st_forms stf,
       jai_cmn_stform_hdrs_all hdr
WHERE  stf.form_id = hdr.form_id
AND    stf.status = 'ACTIVE'
AND    hdr.creation_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

The table maintains defined relationships with other key localization objects, as documented in the provided metadata.

  • Primary Key: JAI_CMN_ST_FORMS_PK on column FORM_ID.
  • Foreign Key Relationship: The table JAI_CMN_STFORM_HDRS_ALL contains a foreign key referencing JAI_CMN_ST_FORMS.ST_HDR_ID. This establishes a one-to-many relationship where a single form definition (in JAI_CMN_ST_FORMS) can be associated with multiple transactional form headers (in JAI_CMN_STFORM_HDRS_ALL).

This relationship is fundamental, as the master form data in JAI_CMN_ST_FORMS is linked to the actual usage instances recorded in transactional tables.