---

SELECT
    o.id AS operation_id,
    o.operation_type_id,
    ot.code AS operation_type_code,
    o.operation_date,
    o.effective_date,
    o.comment,
    rd.id AS rops_decision_id,
    rd.rops_decisions_register_id
FROM back_office.operation o
LEFT JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
LEFT JOIN back_office.rops_decisions rd
    ON rd.operation_id = o.id
WHERE o.id = 84319200;