1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
SELECT distinct
a.capname, b.curcode, a.q_id, c.accdate, d.ccy,
e.accno, f.bankno, h.rate
FROM capent a, cur b, journals c, journal_ent d,
acc e, bank f, count g, cur_rates h
WHERE ( (a.ccy_code_information = b.code)
AND (a.cic_id = c.cic_id)
AND (e.gla_id = d.gla_id)
AND (c.glj_id = d.glj_id)
AND (f.ba_id = d.ba_id)
AND (g.ctp_id = f.ctp_id)
AND (a.cic_id = h.cic_id)
AND (d.ccy_code = h.ccy_code)
AND (d.ccy_code IN ('EUR', 'GBP'))
AND (c.journal_type = 'F')
AND (d.description = 'FD')
AND (a.q_id = 219)
AND (h.rate_date = '05-dec-2008')
) |
Partager