Search Results jai_cmn_stform_hdrs_all




Overview
Explore in AI Chat

Overview

The JAI_CMN_STFORM_HDRS_ALL table is a core data object within the JA (Asia/Pacific Localizations) module of Oracle E-Business Suite, specifically designed for tax compliance in supported regions. It functions as the master repository for header-level information pertaining to sales tax discount forms. These forms are critical statutory documents used to claim tax benefits or discounts, and the table supports forms for both trading partners: vendors (suppliers) and customers. Its role is to maintain a unique, organization-specific header record for each form series or registration, which is then referenced by detailed transactional records to ensure accurate tax reporting and reconciliation.

Key Information Stored

The table's structure is centered on uniquely identifying a party's form registration within a specific operating unit. Its primary and unique keys reveal the critical business entities involved. The primary key is the surrogate ST_HDR_ID. The unique key is a composite of several columns: PARTY_ID (linking to HZ_PARTIES), PARTY_SITE_ID (linking to HZ_PARTY_SITES), FORM_TYPE, ORG_ID (the operating unit from HR_ALL_ORGANIZATION_UNITS), and PARTY_TYPE_FLAG. This unique constraint ensures that a given party at a specific location can have only one active form header record per form type per organization. Other columns typically found in such headers would include form series numbers, validity periods, status, and associated financial details.

Common Use Cases and Queries

This table is central to processes involving the generation, tracking, and application of statutory tax forms. Common operational and reporting scenarios include validating a trading partner's eligibility for a tax discount during transaction entry, reconciling issued forms with tax returns, and generating audit reports. A frequent query pattern retrieves the active form header for a given party to validate a transaction.

  • Retrieve Active Form for a Transaction: SELECT * FROM jai_cmn_stform_hdrs_all WHERE party_id = :p_party_id AND party_site_id = :p_site_id AND org_id = :p_org_id AND form_type = :p_form_type AND sysdate BETWEEN start_date AND end_date;
  • Report on All Form Headers by Organization: SELECT h.party_id, h.form_type, hz.party_name, ou.name org_name FROM jai_cmn_stform_hdrs_all h, hz_parties hz, hr_all_organization_units ou WHERE h.party_id = hz.party_id AND h.org_id = ou.organization_id ORDER BY ou.name, hz.party_name;

Related Objects

JAI_CMN_STFORM_HDRS_ALL sits at the apex of a hierarchy of related localization tables and integrates with core EBS entities. It is directly referenced by several detail tables, including JAI_CMN_ST_FORMS and JAI_CMN_ST_FORM_DTLS for form details, JAI_CMN_ST_MATCH_DTLS for matching transactions to forms, and JAI_AR_TRX_CM_T for customer transaction adjustments. Its foreign keys establish integrity with foundational application tables: HZ_PARTIES and HZ_PARTY_SITES for trading partner data, and HR_ALL_ORGANIZATION_UNITS for the operating unit structure. This network of relationships underscores its critical role in bridging localized tax logic with the standard EBS trading community and financial architecture.