DBA Data[Home] [Help]

APPS.AP_PARTYMERGE_GRP dependencies on AP_INVOICES_ALL

Line 105: FROM ap_invoices_all ai,

101: -- this because 3.1.2.1 of veto rules HLD
102:
103: SELECT COUNT(*)
104: INTO l_unpaid_invoices
105: FROM ap_invoices_all ai,
106: ap_supplier_sites_all pav
107: WHERE ai.vendor_site_id = pav.vendor_site_id
108: AND pav.party_site_id = p_from_fk_id
109: AND nvl(ai.payment_status_flag,'N') <> 'Y';

Line 377: FROM ap_invoices_all ai,

373: -- of the tables ai, pov, pvs, sql will return zero i.e. go ahead
374:
375: SELECT COUNT(*)
376: INTO l_unpaid_invoices
377: FROM ap_invoices_all ai,
378: ap_suppliers pov,
379: ap_supplier_sites_all pvs
380: WHERE ai.vendor_site_id = pvs.vendor_site_id
381: AND pvs.vendor_id = pov.vendor_id