[Home] [Help]
418: ap_invoice_distributions_all aid,
419: ap_checks_all ac,
420: ap_invoice_payments_all aip,
421: po_vendors pvend,
422: po_vendor_sites_all pvs,
423: (SELECT distinct person_id,
424: national_identifier
425: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
426: WHERE ai.invoice_id = aid.invoice_id
444: --------------------------------------------------------------------------------
445: C_COUNT_VENDORS_QUERY :=
446: 'SELECT SUM(DECODE(SUM(countv), SUM(countt), 1, 0)) Count_Vendors
447: FROM po_vendors pvend,
448: po_vendor_sites_all pvs,
449: (SELECT distinct person_id
450: ,national_identifier
451: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf,
452: (SELECT distinct ac.vendor_site_id Vendor_Site_IDs,
484: COUNT(distinct(ac1.vendor_site_id)) countt
485: FROM AP_INVOICE_PAYMENTS_ALL aip1
486: ,AP_CHECKS_ALL ac1
487: ,PO_VENDORS pvend1
488: ,PO_VENDOR_SITES_ALL pvs1
489: WHERE aip1.check_id = ac1.check_id
490: AND aip1.set_of_books_id= ' || l_primary_ledger_id || '
491: AND ac1.global_attribute_category=''JE.IL.APXPAWKB.CHECKS''
492: AND NVL(ac1.global_attribute1,0) > 0
693: CURSOR c_get_bank_awt IS
694: SELECT TO_NUMBER(ac.global_attribute1) bank_wht_amount
695: FROM AP_CHECKS_ALL ac
696: ,PO_VENDORS pv
697: ,PO_VENDOR_SITES_ALL pvs
698: WHERE ac.check_id =pn_check_id
699: AND ac.vendor_id = pv.vendor_id
700: AND ac.vendor_site_id = pvs.vendor_site_id
701: AND pv.vendor_id = pvs.vendor_id
1146: CURSOR c_get_bank_awt IS
1147: SELECT TO_NUMBER(ac.global_attribute1) bank_wht_amount
1148: FROM AP_CHECKS_ALL ac
1149: ,PO_VENDORS pv
1150: ,PO_VENDOR_SITES_ALL pvs
1151: WHERE ac.check_id =pn_check_id
1152: AND ac.vendor_id = pv.vendor_id
1153: AND ac.vendor_site_id = pvs.vendor_site_id
1154: AND pv.vendor_id = pvs.vendor_id