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
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 |