Search Results jai_cmn_st_form_dtls




Overview
Explore in AI Chat

Overview

The table JAI_CMN_ST_FORM_DTLS is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves a critical compliance function by storing detailed transactional records for Sales Tax (ST) Forms tracking. This tracking is mandated in several Asia/Pacific jurisdictions and is integrated directly into Payables and Receivables transaction flows. The table operates as a child entity, holding specific line-level or transaction-level details that are linked to a parent ST Form header, enabling granular reporting and audit trails for tax authorities.

Key Information Stored

The table's primary key is the ST_DTL_ID, a unique identifier for each detail record. Its structure is defined by a series of foreign key columns that link it to major EBS transactional entities. Key columns include ST_HDR_ID, which ties the detail line to its parent record in JAI_CMN_STFORM_HDRS_ALL. The INVOICE_ID column links to AP_INVOICES_ALL for supplier invoices, while TRX_TYPE_ID connects to OE_TRANSACTION_TYPES_ALL for order management transactions. For procurement and receiving processes, it references PO_LINE_LOCATIONS_ALL via PO_LINE_LOCATION_ID and RCV_TRANSACTIONS via RCV_TRANSACTION_ID. Additional context is provided by ORGANIZATION_ID (HR_ALL_ORGANIZATION_UNITS), LOCATION_ID (HR_LOCATIONS_ALL), and TAX_ID for the specific tax being tracked.

Common Use Cases and Queries

The primary use case is generating statutory reports detailing ST Form utilization against specific purchases, sales, or inventory movements. Auditors and tax accountants query this table to reconcile claimed tax deductions or collections with the corresponding government-issued form numbers and amounts. A common reporting pattern involves joining the detail lines to the header, invoice, and supplier or customer information. For example, to analyze all ST Form details for a specific invoice, one might use a query joining JAI_CMN_ST_FORM_DTLS to AP_INVOICES_ALL on INVOICE_ID and to JAI_CMN_STFORM_HDRS_ALL on ST_HDR_ID. Another critical scenario is during transaction entry, where the application validates and updates this table to ensure form details are captured for eligible tax lines.

Related Objects

JAI_CMN_ST_FORM_DTLS has a tightly integrated relationship with several fundamental EBS tables, as documented by its foreign keys. Its primary relationship is with the header table JAI_CMN_STFORM_HDRS_ALL via the ST_HDR_ID column. Its transactional relationships are extensive:

  • JAI_CMN_STFORM_HDRS_ALL (ST_HDR_ID): Parent header record.
  • AP_INVOICES_ALL (INVOICE_ID): Payables invoice being tracked.
  • PO_LINE_LOCATIONS_ALL (PO_LINE_LOCATION_ID): Purchase order shipment line.
  • RCV_TRANSACTIONS (RCV_TRANSACTION_ID): Receiving transaction.
  • OE_TRANSACTION_TYPES_ALL (TRX_TYPE_ID): Order Management transaction type.
  • HR_ALL_ORGANIZATION_UNITS (ORGANIZATION_ID): Inventory or operating organization.
  • HR_LOCATIONS_ALL (LOCATION_ID): Physical location.
  • Self-referencing on TAX_ID: Likely references a tax record, potentially within a related localization table.