ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C3D5E7F9B1D3F5A71921B3D5E7F91B3DY select xatdt.crs_number, xatdt.invoice_id, xatdt.invoice_num, xatdt.invoice_description, xatdt.invoice_date, xatdt.vendor_code, xatdt.vendor_name, xatdt.vendor_site_code, xatdt.vendor_site_id, xatdt.address_line1, xatdt.address_line2, xatdt.address_line3, xatdt.city, xatdt.state, xatdt.zip, xatdt.vendor_pan_no, xatdt.invoice_amount, xatdt.gl_date, xatdt.tax_id, xatdt.tax_name, xatdt.tax_rate, xatdt.basic_tax_rate, xatdt.surcharge_rate, xatdt.cess_rate, xatdt.section_code, xatdt.basic_tax_amount, xatdt.surcharge_amount, xatdt.cess_amount, xatdt.tax_amount, xatdt.gl_ac_number, xatdt.gl_ac_desc, xatdt.tax_invoice_date, xatdt.tax_invoice_due_date, xatdt.tax_authority_vendor_code, xatdt.tax_authority_name, xatdt.tax_authority_site_name, xatdt.tax_vendorsite_id, xatdt.payment_date, xatdt.check_id, xatdt.check_deposit_date, xatdt.deposit_bank_name, xatdt.challan_number, xatdt.payquick_check_number, xatdt.tds_account, xatdt.tds_acct_desc, xatdt.paid, xatdt.tax_invoice_gl_date, decode(aia.attribute_category,'Petty Cash',aia.attribute2,'HR Details',aia.attribute7,'Courier Details',aia.attribute7,'India VAT',aia.attribute7,aia.attribute5) additional_detail, aia.supplier_tax_invoice_number, aia.attribute1, aia.global_attribute15, xatdt.paygroup, xatdt.tax_cat_name, sum(xatdt.pv_number) pv_number, sum(xatdt.tax_cat_id) tax_cat_id from hdfc.xxhdfc_ap_tds_details_tbl xatdt, ap_invoices_all aia where xatdt.invoice_id=aia.invoice_id and :p_tax_inv_due_date=:p_tax_inv_due_date group by xatdt.crs_number, xatdt.invoice_id, xatdt.invoice_num, xatdt.invoice_description, xatdt.invoice_date, xatdt.vendor_code, xatdt.vendor_name, xatdt.vendor_site_code, xatdt.vendor_site_id, xatdt.address_line1, xatdt.address_line2, xatdt.address_line3, xatdt.city, xatdt.state, xatdt.zip, xatdt.vendor_pan_no, xatdt.invoice_amount, xatdt.gl_date, xatdt.tax_id, xatdt.tax_name, xatdt.tax_rate, xatdt.basic_tax_rate, xatdt.surcharge_rate, xatdt.cess_rate, xatdt.section_code, xatdt.basic_tax_amount, xatdt.surcharge_amount, xatdt.cess_amount, xatdt.tax_amount, xatdt.gl_ac_number, xatdt.gl_ac_desc, xatdt.tax_invoice_date, xatdt.tax_invoice_due_date, xatdt.tax_authority_vendor_code, xatdt.tax_authority_name, xatdt.tax_authority_site_name, xatdt.tax_vendorsite_id, xatdt.payment_date, xatdt.check_id, xatdt.check_deposit_date, xatdt.deposit_bank_name, xatdt.challan_number, xatdt.payquick_check_number, xatdt.tds_account, xatdt.tds_acct_desc, xatdt.paid, xatdt.tax_invoice_gl_date, decode(aia.attribute_category,'Petty Cash',aia.attribute2,'HR Details',aia.attribute7,'Courier Details',aia.attribute7,'India VAT',aia.attribute7,aia.attribute5), aia.supplier_tax_invoice_number, aia.attribute1, aia.global_attribute15, xatdt.paygroup, xatdt.tax_cat_name Initial version - migrated from the HDFC Form 17 (India TDS) Oracle Reports / Discoverer worksheet on HDFC.XXHDFC_AP_TDS_DETAILS_TBL. The TDS detail table is populated for the entered Tax Invoice Due Date by the HDFC_TDS_DETAILS concurrent program, which is submitted and waited for by the report's DB package before-report trigger (XXHDFC_TDS_REPORT_PKG.beforereport) before the main SQL runs. XXHDFC_TDS_REPORT_PKG US AP TDS Details Report TDS (Tax Deducted at Source) invoice details for India Form 17, joining the HDFC TDS detail table to AP Invoices for the supplier attribute / supplier tax invoice number columns. The TDS detail table HDFC.XXHDFC_AP_TDS_DETAILS_TBL is not queried directly from your transactional tables. It is first populated for the entered Tax Invoice Due Date by the HDFC_TDS_DETAILS concurrent program (XXHDFC TDS Details Report). This report runs that program automatically through its DB package before-report trigger (XXHDFC_TDS_REPORT_PKG.beforereport), waits for it to complete, and then returns the populated rows - so you do not need to run the concurrent program separately. Enter the Tax Invoice Due Date to report TDS invoices due on that date. PV Number and Tax Category Id are summed for each unique combination of all other columns. Custom Reports HDFC :p_tax_inv_due_date 1 10 :p_tax_inv_due_date Date Y US Tax Invoice Due Date