Results for “jai_wct_cert_dtls_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_WCT_CERT_DTLS_V is a reporting view owned by the APPS schema within the JA (Asia/Pacific Localizations) product family. It exposes withholding tax certificate details generated under the Withholding Tax (WCT) framework that Oracle E-Business Suite localizations provide for statutory compliance in countries such as India. Specifically, the view returns certificate line detail tied to Form 16 records, aggregating the tax deducted at source against vendor payments. The name and structure indicate that it is intended to support statutory certificate printing, reconciliation, and downstream reporting rather than transactional data entry.

The view is defined with a restrictive filter that limits output to records where a Form 16 header exists and where the underlying tax is classified as a WCT section. As a result, it functions as a pre-filtered, join-ready data source for certificate-level reporting and can be consumed by concurrent programs, BI Publisher data templates, or ad hoc SQL. The tds_section column exposed by the view corresponds to the tax deduction section under which each certificate line was withheld, which is a common reporting dimension for statutory returns.

Underlying Base Objects

The view is defined over two base objects, both referenced through public synonyms in the APPS schema:

• JAI_AP_TDS_INV_PAYMENTS — the primary source aliased as JATP, supplying invoice payment, certificate, and tax deduction detail.
• JAI_CMN_TAXES_ALL — the tax setup table aliased as JCTA, joined on TDS_TAX_ID = TAX_ID and filtered to SECTION_TYPE = 'WCT_SECTION'.

The join restricts results to tax definitions classified as withholding tax sections, while the predicate JATP.FORM16_HDR_ID IS NOT NULL ensures that only certificate records linked to a Form 16 header are returned. This makes the view effectively an inner join restricted to certificate-bearing transactions.

Key Columns

• ORG_TAN_NUM — Tax Account Number of the deducting organization.
• FIN_YEAR — Financial year to which the certificate pertains.
• CERTIFICATE_NUM / CERTIFICATE_LINE_NUM — Certificate identifier and line sequence.
• TDS_SECTION — Withholding tax section under which the deduction was made.
• CHECK_DATE / CHECK_AMOUNT — Payment check date and amount.
• PAYMENT_AMOUNT / TAXABLE_BASIS — Gross payment and basis on which tax was computed.
• TDS_TAX_RATE / TAX_AMOUNT — Applied rate and resulting tax amount.
• TAX_AUTHORITY_ID / TAX_AUTHORITY_SITE_ID — Tax authority and site identifiers.
• VENDOR_ID / VENDOR_SITE_ID — Supplier identifiers.
• OPERATING_UNIT_ID — Operating unit context.
• FORM16_HDR_ID — Form 16 header reference.
• INVOICE_ID / CHECK_ID / INVOICE_PAYMENT_ID — Links to invoice and payment transactions.
• PREPAY_INVOICE_ID / PARENT_INVOICE_ID / THRESHOLD_TRX_ID — Related transaction references.

Common Use Cases and Queries

Typical uses include preparing Form 16 certificate data, reconciling withheld tax to payments, and reporting by TDS section.

SELECT CERTIFICATE_NUM, CERTIFICATE_LINE_NUM, TDS_SECTION,
       PAYMENT_AMOUNT, TAXABLE_BASIS, TDS_TAX_RATE, TAX_AMOUNT
FROM   APPS.JAI_WCT_CERT_DTLS_V
WHERE  FIN_YEAR = :p_fin_year
AND    ORG_TAN_NUM = :p_tan;

SELECT TDS_SECTION, SUM(TAX_AMOUNT) TAX_TOTAL
FROM   APPS.JAI_WCT_CERT_DTLS_V
WHERE  FIN_YEAR = :p_fin_year
GROUP  BY TDS_SECTION;

The view is read-only and should be queried with appropriate org and financial year filters to bound result sets.