JA India - TDS Related Invoices - draft

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
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
To Date
 
Date
From Date
 
Date
Operating Unit
 
LOV Oracle