618: ps.discount_date
619: FROM ap_supplier_sites_all sites,
620: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
621: ap_payment_schedules ps,
622: ap_suppliers suppliers,
623: hz_parties hz
624: where inv.invoice_id = ps.invoice_id
625: AND sites.vendor_site_id(+) = inv.vendor_site_id
626: AND suppliers.vendor_id(+) = inv.vendor_id
2038: ,Null payment_exchange_rate
2039: ,Null payment_exchange_rate_type
2040: ,Null payment_exchange_date
2041: FROM ap_supplier_sites_all sites,
2042: ap_suppliers suppliers,
2043: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2044: ap_payment_schedules_all ps,
2045: ap_system_parameters_all asp,
2046: hz_parties hzp,
2332: ,Null payment_exchange_rate
2333: ,Null payment_exchange_rate_type
2334: ,Null payment_exchange_date
2335: FROM ap_supplier_sites_all sites,
2336: ap_suppliers suppliers,
2337: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2338: ap_payment_schedules_all ps,
2339: ap_system_parameters_all asp,
2340: hz_parties hzp,