---

-- Когда создан реестр 219866848 относительно документа 176
SELECT 
    arap.id as doc_id,
    arap.status_id,
    arap.created,
    pr.id as register_id,
    pr.created as register_created,
    pr.accepted
FROM back_office.accrual_repurchase_amount_payments arap
JOIN back_office.payment_register pr ON pr.id = 219866848
WHERE arap.id = 176;





-- Откуда берётся payment_register_id в payment для выкупных сумм
SELECT 
    p.payment_register_id,
    pr.accepted,
    pr.created
FROM back_office.payment p
JOIN back_office.payment_register pr ON pr.id = p.payment_register_id  
JOIN back_office.accrual_repurchase_amount_payments_details d ON d.id = p.accrual_repurchase_id
WHERE d.accrual_repurchase_amount_payments_id = 176
LIMIT 1;