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 |