--Детализация по извещениям
select
a.bodyitempurchasenoticedatacustomermaininfofullname,
a.bodyitempurchasenoticedatacustomermaininfoinn,
a.bodyitempurchasenoticedataregistrationnumber,
a.bodyitempurchasenoticedatapurchasecodename,
a.bodyitempurchasenoticedatapurchasemethodcode,
a.bodyitempurchasenoticedatapublicationdatetime,
a.bodyitempurchasenoticedatalotslotlotdatasubject,
case
    when a.nmck=''  or a.nmck=' ' then b.lotdatainitialsum else a.nmck::numeric end nmck,
a.bodyitempurchasenoticedataversion
from eis_notice_223all a
left join eis_notice_223_lotsall b on a.bodyitempurchasenoticedataregistrationnumber=b.bodyitempurchasenoticeaesmbodataregistrationnumber
Where nmck is Not Null
order by bodyitempurchasenoticedatacustomermaininfofullname