"""Vendor Currency Codes Query."""

VENDOR_CURRENCY_CODES_SQL = """
SELECT v.vendor_id, cur.ISO_4217_code AS currency_code
FROM vendor v
INNER JOIN vw_active_vendor_contract vacv ON v.vendor_id = vacv.vendor_id
INNER JOIN vendor_contract vc ON vacv.vendor_contract_id = vc.id
INNER JOIN currencies cur ON cur.id = vc.currency_id
"""