Create invoice

select n.id,
       ml.cod,
       us.cod as ini,
       mn.nam,
       ct.num,
       nm.licence_text as rights,
       nm.price fee,
       n.quote_total as total,
       n.quote_currency
from notes n
join notes_media nm on n.id=nm.note_id
join ct             on nm.media_id=ct.id
join ml             on n.company_id=ml.id
join us             on n.user_id=us.id
join mn             on n.contact_id=mn.id
where n.id=?

This needs

trunc(case when discount_is_percentage then discount else discount / quote_total * 100 end, 2) as discount_percentage