[Home] [Help]
225: PV.NUM_1099 AS SUPPLIER_TAXPAYER_ID,
226: PV.VAT_REGISTRATION_NUM AS SUPPLIER_TAX_REGN_NUM
227: FROM FUN_NET_AP_INVS_ALL FNAP,
228: FUN_NET_BATCHES_ALL FNB,
229: AP_INVOICES_ALL API,
230: AP_LOOKUP_CODES ALC,
231: PO_VENDORS PV,
232: PO_VENDOR_SITES_ALL PVS
233: WHERE FNAP.BATCH_ID = p_batch_id
269: MIN(APS.DUE_DATE) AS DUE_DATE,
270: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
271: FROM FUN_NET_AP_INVS_ALL FNAP,
272: FUN_NET_BATCHES_ALL FNB,
273: AP_INVOICES_ALL API,
274: ap_invoice_lines_all ail,
275: AP_LOOKUP_CODES ALC,
276: AP_PAYMENT_SCHEDULES_ALL APS,
277: PO_VENDORS PV,
277: PO_VENDORS PV,
278: PO_VENDOR_SITES_ALL PVS,
279: (select ail2.invoice_id
280: ,sum(ail2.amount) vat_amount
281: from ap_invoices_all ai2
282: ,ap_invoice_lines_all ail2
283: ,ap_tax_codes_all atc
284: where ai2.vendor_id = :SUPPLIER_ID
285: and ai2.vendor_site_id = :SITE_ID
612: PVS.ZIP AS SUPPLIER_ZIP,
613: PVC.FIRST_NAME||' '||PVC.LAST_NAME AS CONTACT_FIRST_LAST_NAME
614: FROM FUN_NET_AP_INVS_ALL FNAP,
615: FUN_NET_BATCHES_ALL FNB,
616: AP_INVOICES_ALL API,
617: AP_LOOKUP_CODES ALC,
618: PO_VENDORS PV,
619: PO_VENDOR_SITES_ALL PVS,
620: PO_VENDOR_CONTACTS PVC
677: AC.CHECK_NUMBER AS PAYMENT_NUMBER,
678: LTRIM(TO_CHAR(SUM(nvl(vat.vat_amount,0)),''999999999999999999999.999999999999'')) AS VAT_AMOUNT
679: FROM FUN_NET_AP_INVS_ALL FNAP,
680: FUN_NET_BATCHES_ALL FNB,
681: AP_INVOICES_ALL API,
682: AP_LOOKUP_CODES ALC,
683: PO_VENDORS PV,
684: PO_VENDOR_SITES_ALL PVS,
685: AP_CHECKS_ALL AC,
684: PO_VENDOR_SITES_ALL PVS,
685: AP_CHECKS_ALL AC,
686: (select ail2.invoice_id
687: ,sum(ail2.amount) vat_amount
688: from ap_invoices_all ai2
689: ,ap_invoice_lines_all ail2
690: ,ap_tax_codes_all atc
691: where ai2.vendor_id = :SUPPLIER_ID
692: and ai2.vendor_site_id = :SITE_ID