-- Update wrong fin_payment_scheduledetai related to orders
update fin_payment_scheduledetail as psd
set ad_org_id = i.ad_org_id
from c_invoice i
join fin_payment_schedule ps
on i.c_invoice_id = ps.c_invoice_id
where ps.fin_payment_schedule_id=psd.fin_payment_schedule_invoice
and psd.fin_payment_detail_id is null
and i.ad_org_id <> psd.ad_org_id

-- Update wrong fin_payment_scheduledetai related to invoices
update fin_payment_scheduledetail as psd
set ad_org_id = o.ad_org_id
from c_order o
join fin_payment_schedule ps
on o.c_order_id = ps.c_order_id
where ps.fin_payment_schedule_id=psd.fin_payment_schedule_order
and psd.fin_payment_detail_id is null
and o.ad_org_id <> psd.ad_org_id