Search Results jai_ap_tds_distribution_v

Overview

JAI_AP_TDS_DISTRIBUTION_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the JA (Asia/Pacific Localizations) product family. Its documented purpose is to expose Tax Deducted at Source (TDS) distributions originating from Oracle Payables invoice distributions. In EBS 12.1.1 and 12.2.2 the view acts as a filtered, reporting-oriented abstraction over AP_INVOICE_DISTRIBUTIONS_ALL, presenting distribution rows that are relevant to TDS processing while suppressing lines that represent tax, prepayment, or reverse-charge constructs. It is typically consumed by India localization reporting, reconciliation, and downstream integration logic that needs a stable, denormalized picture of deductible distribution lines without directly querying the transactional distribution table.

Underlying Base Objects

The documented referenced base objects are AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICES_ALL, JAI_AP_MATCH_INV_TAXES, and JAI_CMN_TAXES_ALL (all accessed via synonyms in the APPS schema). The view is a UNION ALL of two branches:

• Branch 1: Selects distribution rows from AP_INVOICE_DISTRIBUTIONS_ALL where LINE_TYPE_LOOKUP_CODE is not in ('PREPAY','TIPV','TERV','TAX','MISCELLANEOUS') and no parent invoice in AP_INVOICES_ALL carries SOURCE = 'INDIA TDS'.
• Branch 2: Selects 'MISCELLANEOUS' distributions only when they are not attributed to excise or customs tax types (EXCISE, ADDL. EXCISE, OTHER EXCISE, EXCISE_EDUCATION_CESS, EXCISE_SH_EDU_CESS, CUSTOMS, CUSTOMS_EDUCATION_CESS, CUSTOMS_SH_EDU_CESS) defined in JAI_CMN_TAXES_ALL and matched via JAI_AP_MATCH_INV_TAXES, again excluding INDIA TDS sourced invoices.

Both branches project the same column list, using AID.ROWID / AIDA.ROWID as ROW_ID.

Key Columns

• ROW_ID — ROWID of the underlying AP_INVOICE_DISTRIBUTIONS_ALL row, useful as a pseudo-key for updates or correlation.
• INVOICE_ID / INVOICE_LINE_NUMBER / DISTRIBUTION_LINE_NUMBER — Identify the parent invoice and its structural position.
• INVOICE_DISTRIBUTION_ID — Primary surrogate key of the distribution, the standard join path to JAI_AP_MATCH_INV_TAXES.
• DIST_CODE_COMBINATION_ID — The distribution accounting flexfield combination; this is the column most commonly searched (dist_code_combination_id) for reconciling TDS postings to specific GL accounts.
• AMOUNT — Distribution amount entering TDS computation.
• DESCRIPTION, MATCH_STATUS_FLAG, LINE_TYPE_LOOKUP_CODE — Descriptive and status context; MATCH_STATUS_FLAG distinguishes matched versus unmatched lines.
• TAX_CATEGORY_ID, SECTION_CODE, TAX_CATEGORY_OVERRIDEN — Exposed as literal NULL placeholders, preserved for interface consistency.

Common Use Cases and Queries

Typical uses include TDS distribution reconciliation, account-level analysis by code combination, and integration extracts feeding India statutory reports. Because the view already excludes prepayments, TAX lines, and INDIA TDS sourced distributions, queries remain lightweight.

Distribution lines by accounting combination:

• SELECT INVOICE_ID, INVOICE_DISTRIBUTION_ID, DIST_CODE_COMBINATION_ID, AMOUNT, LINE_TYPE_LOOKUP_CODE FROM JAI_AP_TDS_DISTRIBUTION_V WHERE DIST_CODE_COMBINATION_ID = :p_ccid;
• SELECT DIST_CODE_COMBINATION_ID, SUM(AMOUNT) FROM JAI_AP_TDS_DISTRIBUTION_V GROUP BY DIST_CODE_COMBINATION_ID;
• Join to invoice headers for supplier context: SELECT v.INVOICE_ID, v.DIST_CODE_COMBINATION_ID, v.AMOUNT, i.vendor_id FROM JAI_AP_TDS_DISTRIBUTION_V v, AP_INVOICES_ALL i WHERE v.INVOICE_ID = i.INVOICE_ID AND v.INVOICE_ID = :p_invoice;
• Join to JAI_AP_MATCH_INV_TAXES on INVOICE_DISTRIBUTION_ID to overlay matched tax identifiers for localization reporting.