Search Results source_doc_line_id




Overview
Explore in AI Chat

Overview

APPS.JAI_AP_STANDALONE_TAXES_V is an Oracle E-Business Suite view that exposes tax lines associated with standalone (manual) invoices processed through the Oracle Financials for India localization. The view is defined over the JAI_CMN_DOCUMENT_TAXES table and filters that table to a single document classification: SOURCE_DOC_TYPE = 'STANDALONE_INVOICE'. Because standalone invoices are captured directly in Payables rather than generated from a registered sourcing document, their tax lines lack the parent transaction context found in GST or excise-driven flows; this view isolates those records for reporting and integration.

The view does not carry transaction data of its own. It is a projection and aggregation layer: it collapses multiple tax rows for the same logical tax line into a single summarized row using aggregate functions and a GROUP BY. This makes it suitable for reporting surfaces, custom concurrent programs, and interface extracts where one row per tax line is required rather than the raw multiplicity stored in the base table. The primary key DOC_TAX_ID is not exposed directly; instead it is surfaced through MAX(DOC_TAX_ID), which identifies a representative row for the grouped tax line.

Underlying Base Objects

The view is defined exclusively over a synonym, JAI_CMN_DOCUMENT_TAXES, which resolves to the common document tax table used across the India localization modules. All columns in the SELECT list originate from this single object; no joins are present. Consequently, the view inherits the partitioning, indexing, and audit characteristics of JAI_CMN_DOCUMENT_TAXES without introducing additional access paths.

The SOURCE_DOC_TYPE = 'STANDALONE_INVOICE' predicate is the sole row filter. Every other transformation is either an aggregate or a pass-through column in the GROUP BY. The grouping key comprises TAX_LINE_NO, TAX_ID, TAX_TYPE, CURRENCY_CODE, TAX_RATE, QTY_RATE, UOM, TAX_CATEGORY_ID, SOURCE_DOC_TYPE, SOURCE_DOC_ID, SOURCE_TABLE_NAME, TAX_MODIFIED_BY, ADHOC_FLAG, the ten PRECEDENCE_n columns, the audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), and SOURCE_DOC_PARENT_LINE_NO.

Key Columns

  • DOC_TAX_ID – Aggregated as MAX(); a surrogate identifier for the underlying tax record.
  • TAX_LINE_NO – Sequence of the tax line within the document; part of the grouping key.
  • TAX_ID / TAX_TYPE / TAX_RATE / QTY_RATE / UOM – Define the tax regime, rate basis, and unit of measure applied.
  • TAX_AMT / FUNC_TAX_AMT – Summed tax amounts in entered and functional currency respectively.
  • TAX_CATEGORY_ID – Classification of the tax (e.g., recovery, non-recoverable).
  • MODVAT_FLAG – Surfaced via MAX(); indicates modvat eligibility.
  • TAX_MODIFIED_BY – The user or process that last modified the tax line; central to audit and to the "tax_modified_by" search.
  • SOURCE_DOC_TYPE / SOURCE_DOC_ID / SOURCE_DOC_LINE_ID / SOURCE_DOC_PARENT_LINE_NO – Document linkage; SOURCE_DOC_LINE_ID is exposed as MAX().
  • ADHOC_FLAG – Distinguishes ad-hoc tax lines from predefined ones.
  • PRECEDENCE_1 through PRECEDENCE_10 – Ordering attributes controlling tax computation sequence.

Common Use Cases and Queries

Typical consumers use this view to report tax charged on independently entered invoices, to reconcile tax amounts to the Payables distributions, and to audit who changed tax attributes.

Listing tax lines for a specific standalone invoice:

SELECT tax_line_no, tax_id, tax_rate, tax_amt, func_tax_amt, tax_modified_by
FROM   apps.jai_ap_standalone_taxes_v
WHERE  source_doc_id = :p_invoice_id
ORDER  BY tax_line_no;

Auditing modifications attributed to a specific user:

SELECT source_doc_id, tax_line_no, tax_id, tax_amt, tax_modified_by, last_update_date
FROM   apps.jai_ap_standalone_taxes_v
WHERE  tax_modified_by = :p_user
ORDER  BY last_update_date DESC;

Summarizing tax by category and currency:

SELECT tax_category_id, currency_code, SUM(tax_amt), SUM(func_tax_amt)
FROM   apps.jai_ap_standalone_taxes_v
GROUP  BY tax_category_id, currency_code;