JA India - TDS Related Invoices - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - TDS Related Invoices (XML) - Not Supported: Reserved For Future Use
Short Name: JAINOTDS_XML
DB package: JA_JAINOTDS_XMLP_PKG
Run JA India - TDS Related Invoices - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT a.invoice_id invoice_id1,
a.invoice_num,a.INVOICE_CURRENCY_CODE, 
       a.invoice_amount, a.vendor_id vendor_id1, a.vendor_site_id vendor_site_id1, 
       b.invoice_id parent_invoice_id, a.description, 
	JA_JAINOTDS_XMLP_PKG.cf_vendor_name1formula(a.vendor_id, :VENDOR_ID, :CF_Vendor_Name) CF_vendor_name1, 
	JA_JAINOTDS_XMLP_PKG.cf_vendor_site_1formula(a.vendor_site_id, :VENDOR_SITE_ID, :CF_Vendor_site) CF_Vendor_site_1, 
	JA_JAINOTDS_XMLP_PKG.cf_tds_sectionformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TDS_SECTION, 
	JA_JAINOTDS_XMLP_PKG.cf_tds_tax_rateformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TDS_TAX_RATE, 
	JA_JAINOTDS_XMLP_PKG.cf_tax_nameformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TAX_NAME
FROM   ap_invoices_all A,jai_ap_tds_thhold_trxs B   
WHERE  (a.invoice_id = b.invoice_to_vendor_id  
   OR  a.invoice_id = b.invoice_to_tds_authority_id )
 and b.invoice_id=:invoice_id
Parameter Name SQL text Validation
Operating Unit 
 
 LOV Oracle
From Date 
 
 Date
To Date 
 
 Date
Download
Related Blitz Reports
JA India - TDS Certificates JA India - TDS Prescribed Rate - draft JA India - TDS at Lower Rates - draft JA India - Service Tax Credit Register - draft JA India - Purchases Report- Not Supported: Reserved For Future Use JA India - VAT Returns Report(1)- Not Supported: Reserved For Future Use JA India - Open Transactions Report for Prior-GST (XML Publisher) JA India - PLA Register - draft ZX Singaporean Input Taxes Gain/Loss Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: