Search Results jai_crm_quote_taxes_pk




Overview
Explore in AI Chat

Overview

The JAI_CRM_QUOTE_TAXES table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed for the Asia/Pacific (JA) Localizations module. Its primary function is to store detailed tax information associated with quotations created within the Order Management cycle. This table acts as a critical junction, linking tax calculations from the localization's tax engine to specific quote headers, lines, and shipments in the standard Oracle Advanced Pricing (ASO) tables. By maintaining this relationship, it enables the accurate application of region-specific tax rules—such as India's GST or other APAC tax regimes—to sales quotes before they are converted into final orders, ensuring compliance and correct financial forecasting.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign key relationships define its essential structure. The table's composite primary key (JAI_CRM_QUOTE_TAXES_PK) is based on SHIPMENT_ID and TAX_ID, indicating that tax records are uniquely identified per shipment and tax type. The critical foreign key columns are QUOTE_HEADER_ID, QUOTE_LINE_ID, SHIPMENT_ID, and TAX_ID. These columns store the references that anchor the tax record to the main quote document (ASO_QUOTE_HEADERS_ALL), a specific line item (ASO_QUOTE_LINES_ALL), a shipment detail (ASO_SHIPMENTS), and the precise tax code and rules from the localization's tax master table (JAI_CMN_TAXES_ALL). Additional columns likely store calculated tax amounts, tax rates, tax recovery flags, and jurisdictional information.

Common Use Cases and Queries

This table is central to tax reporting and audit trails for the quotation process. Common operational and analytical queries involve joining this table with standard ASO and localization tables to retrieve comprehensive tax details. For instance, a report summarizing all taxes applied to a specific quote would join JAI_CRM_QUOTE_TAXES with ASO_QUOTE_HEADERS_ALL on QUOTE_HEADER_ID and with JAI_CMN_TAXES_ALL on TAX_ID to fetch tax names and rates. Another typical use case is validating tax calculations during quote creation or modification via personalized diagnostics. A sample SQL pattern to list tax details for a quote header would be:

  • SELECT qh.quote_number, qt.*, ct.tax_code
  • FROM jai_crm_quote_taxes qt,
  • aso_quote_headers_all qh,
  • jai_cmn_taxes_all ct
  • WHERE qt.quote_header_id = qh.quote_header_id
  • AND qt.tax_id = ct.tax_id
  • AND qh.quote_header_id = <P_QUOTE_HEADER_ID>;

Related Objects

The JAI_CRM_QUOTE_TAXES table is integrally connected to both standard Oracle EBS objects and JA localization tables through its foreign key constraints. The documented relationships are as follows:

  • ASO_QUOTE_HEADERS_ALL: Linked via JAI_CRM_QUOTE_TAXES.QUOTE_HEADER_ID. This ties tax records to the parent quote document.
  • ASO_QUOTE_LINES_ALL: Linked via JAI_CRM_QUOTE_TAXES.QUOTE_LINE_ID. This associates taxes with individual line items on the quote.
  • ASO_SHIPMENTS: Linked via JAI_CRM_QUOTE_TAXES.SHIPMENT_ID. This connects taxes to specific shipment schedules within the quote.
  • JAI_CMN_TAXES_ALL: Linked via JAI_CRM_QUOTE_TAXES.TAX_ID. This is the critical link to the localization's master tax definitions and rules.

These relationships ensure data integrity and enable the flow of tax information from the localized setup through the quotation process.