Query taking long time to execute not sure why?
Hi ,
Facing some issue with the following query. It is taking days to execute. Please suggest.(Perfomance tuning issue
Need your immediate support on the same.
SELECT (SELECT haou.NAME
FROM apps.hr_all_organization_units haou
WHERE haou.organization_id = ai.org_id) circle,
ai.invoice_num, TRUNC (ai.invoice_date) invoice_date,
(SELECT TRUNC (MIN (ac.check_date))
FROM apps.ap_checks_all ac,
apps.ap_invoice_payments_all aip
WHERE aip.check_id = ac.check_id
AND aip.invoice_id = ai.invoice_id) payment_date,
ass.vendor_name supplier_name, ass.segment1 supplier_number,
ass.vendor_type_lookup_code supplier_type,