How is about this:
SELECT
a.type,
FROM order_booking a
LEFT JOIN commercial_estimation b ON a.type = 'commercial' AND b.oid = a.id
LEFT JOIN packaging_estimation c ON a.type = 'packaging' AND c.oid = a.id
LEFT JOIN order_estimation d ON a.type = 'order' AND d.oid = a.id
To have access to the Details you can also use
COALESCE
in case the datatype do match and you like to have one field for the three Details.