Search Results excise_education_cess

Overview

APPS.JAI_AP_TDS_DISTRIBUTION_V is a reporting view delivered as part of the Oracle E-Business Suite India Localization (JAI) module. It exposes eligible Accounts Payable invoice distribution lines for Tax Deducted at Source (TDS) processing and reporting. The view consolidates rows from AP_INVOICE_DISTRIBUTIONS_ALL into a uniform projection that includes a synthetic ROW_ID, the invoice and distribution identifiers, the accounting flexfield combination, the distribution amount, and the line type classification, while normalizing three additional attributes (TAX_CATEGORY_ID, SECTION_CODE, and TAX_CATEGORY_OVERRIDEN) to NULL placeholders so downstream TDS logic can consume a consistent column set.

The view is defined as a UNION ALL of two branches. The first branch selects all invoice distributions whose LINE_TYPE_LOOKUP_CODE is not one of PREPAY, TIPV, TERV, TAX, or MISCELLANEOUS. The second branch selectively re-includes MISCELLANEOUS lines, but only where no associated India excise or customs tax exists in JAI_AP_MATCH_INV_TAXES / JAI_CMN_TAXES_ALL. Both branches exclude any invoice whose header SOURCE is 'INDIA TDS', preventing self-referential reprocessing of TDS-generated invoices. The result is a curated set of distribution lines that are appropriate candidates for TDS assessment under the India localization.

Underlying Base Objects

The documented view metadata identifies four referenced base objects, each exposed to APPS through synonyms: AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, JAI_AP_MATCH_INV_TAXES, and JAI_CMN_TAXES_ALL. AP_INVOICE_DISTRIBUTIONS_ALL supplies the primary driver rows, providing the invoice identifier, line and distribution numbering, distribution identifier, code combination, amount, description, match status, and line type. AP_INVOICES_ALL is referenced twice: once through the correlated NOT EXISTS against SOURCE = 'INDIA TDS' to exclude TDS invoices, and implicitly as the parent of the distributions. JAI_AP_MATCH_INV_TAXES provides the link between a distribution and its matched tax, and JAI_CMN_TAXES_ALL supplies the tax type used to identify excise and customs taxes. The join across these two localization tables allows the SECOND UNION branch to suppress miscellaneous distributions already covered by excise or customs treatment.

Key Columns

• ROW_ID — the source ROWID from AP_INVOICE_DISTRIBUTIONS_ALL, useful for correlation back to the underlying distribution.
• INVOICE_ID — the AP invoice header identifier linking to AP_INVOICES_ALL.
• INVOICE_LINE_NUMBER / DISTRIBUTION_LINE_NUMBER — the line and distribution sequence numbers, enabling line-level drill-down.
• INVOICE_DISTRIBUTION_ID — the unique distribution identifier used to join tax-match records (for example, JAI_AP_MATCH_INV_TAXES).
• DIST_CODE_COMBINATION_ID — the accounting flexfield combination for the distribution charge account.
• AMOUNT — the distribution amount subject to potential TDS evaluation.
• DESCRIPTION — the user-entered line description.
• MATCH_STATUS_FLAG — indicates the matching state of the distribution against purchasing documents.
• LINE_TYPE_LOOKUP_CODE — the AP line type classification; this column drives the view's inclusion logic and is the anchor for filtering and reporting.
• TAX_CATEGORY_ID, SECTION_CODE, TAX_CATEGORY_OVERRIDEN — exposed as NULL placeholders to complete the projection contract expected by the consuming TDS process.

Common Use Cases and Queries

This view is typically queried to produce TDS candidate line listings, to reconcile distributions against tax matches, or to feed TDS computation and reporting structures. A representative query retrieving candidate lines for a specific invoice is:

SELECT invoice_id, invoice_line_number, distribution_line_number, invoice_distribution_id, dist_code_combination_id, line_type_lookup_code, amount FROM apps.jai_ap_tds_distribution_v WHERE invoice_id = :p_invoice_id ORDER BY invoice_line_number, distribution_line_number;

To group candidate amounts by line type across an accounting period, the view can be joined to AP_INVOICES_ALL on invoice_id and filtered by INVOICE_DATE. Because the view already excludes prepayments, tax lines, India TDS sourced invoices, and excise/customs-covered miscellaneous lines, reports built on it avoid re-implementing the exclusion rules themselves. When reconciling against tax records, the INVOICE_DISTRIBUTION_ID should be used to correlate with JAI_AP_MATCH_INV_TAXES, since the view does not expose the matched tax identifier directly.