select lp.*,
u.fio,
kk.name as subkontoname,
a.acc,
(select d.res from decode(lp.curr, 2, 'UAH', 3, '$', 4, 'EUR', 8, 'RUR',
2, 'UAH', 3, '$', 4, 'EUR', c.name) d) as CurrName,
a.name,
f.name as firmname,
(select res from Get_Real_Rate(lp.dat_paym, lp.curr,:MAINCURR)) as rate_nbu,
(select summa_ from get_summ_val_by_rate(lp.dat_paym, lp.summa,
lp.curr,:MAINCURR)) as summausd,
u2.fio as LastUser,
(select out_val from nvl((select res from decode((select res from
decode('~!!!!~', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', sg.security,'0')),
'0',
kk.name,'1',sg.name,'1',sg.name,'1',sg.name,'1',sg.name,'1',sg.name,'1',sg.name,sg.name)),kk.name)) as SubkontogroupName,
(select summa_ from get_summ_val_by_rate(lp.dat_paym, lp.summa,
lp.curr,:MAINCURR)) as oplat_usd1,
(select OUT_VAL from nvl(
(select res from
decode(:MAINCURR,3,oop.oplat_usd,8,oop.oplat_rur,4,
oop.oplat_eur,2,oop.oplat_grn,
3,oop.oplat_usd,8,oop.oplat_rur,4, oop.oplat_eur, 0
))
, 0)) as oplat_usd2,
lp.summa - ssss.summ_payed as oplat_val,
(select OUT_VAL from nvl(ssss.count_paym_, 0)) as count_paym_,
f.id,
sg.security,
ad.direction_name
from accrual_paym lp, vocabulary c, users u, subkonto_group sg
left join organizaton kk on kk.id_group = sg.id_group
left join activity_derection ad on ad.id_direction = lp.id_direction
left join users u2 on lp.last_edit_user = u2.id_user
left join view_oplat oop on oop.id_accrual = lp.id_paym
left join firm f on f.id = lp.id_firm
left join view_summ_payed ssss on ssss.id_accrual = lp.id_paym
left join account a on lp.id_account = a.id_account
where
lp.id_user = u.id_user
and lp.curr = c.id
and lp.subkonto = kk.id_org |