SELECT REPLACE(REPLACE(ptp_cde,'mem',''),'0',''),ptp_cde,f.* FROM dap_ptp_mst m
JOIN dev_att_fil f
ON m.glb_unq_idn = f.ent_glb_unq_idn
WHERE ptp_cde IN(
'MEM'+replicate('0',10-len('387'))+'387',
'MEM'+replicate('0',10-len('492'))+'492',
'MEM'+replicate('0',10-len('522'))+'522',
'MEM'+replicate('0',10-len('1343'))+'1343',
'MEM'+replicate('0',10-len('67127'))+'67127',
'MEM'+replicate('0',10-len('1769'))+'1769',
'MEM'+replicate('0',10-len('1825'))+'1825',
'MEM'+replicate('0',10-len('1692'))+'1692',
'MEM'+replicate('0',10-len('2907'))+'2907',
'MEM'+replicate('0',10-len('1956'))+'1956',
'MEM'+replicate('0',10-len('2125'))+'2125',
'MEM'+replicate('0',10-len('4332'))+'4332',
'MEM'+replicate('0',10-len('3725'))+'3725',
'MEM'+replicate('0',10-len('4182'))+'4182',
'MEM'+replicate('0',10-len('4439'))+'4439',
'MEM'+replicate('0',10-len('4480'))+'4480',
'MEM'+replicate('0',10-len('5313'))+'5313',
'MEM'+replicate('0',10-len('4883'))+'4883',
'MEM'+replicate('0',10-len('5171'))+'5171',
'MEM'+replicate('0',10-len('6973'))+'6973',
'MEM'+replicate('0',10-len('68321'))+'68321',
'MEM'+replicate('0',10-len('7564'))+'7564',
'MEM'+replicate('0',10-len('7453'))+'7453',
'MEM'+replicate('0',10-len('8001'))+'8001',
'MEM'+replicate('0',10-len('8320'))+'8320',
'MEM'+replicate('0',10-len('8983'))+'8983',
'MEM'+replicate('0',10-len('9571'))+'9571',
'MEM'+replicate('0',10-len('8920'))+'8920',
'MEM'+replicate('0',10-len('10281'))+'10281',
'MEM'+replicate('0',10-len('69838'))+'69838',
'MEM'+replicate('0',10-len('12216'))+'12216',
'MEM'+replicate('0',10-len('13295'))+'13295',
'MEM'+replicate('0',10-len('68594'))+'68594',
'MEM'+replicate('0',10-len('16051'))+'16051',
'MEM'+replicate('0',10-len('16108'))+'16108',
'MEM'+replicate('0',10-len('68226'))+'68226',
'MEM'+replicate('0',10-len('17090'))+'17090',
'MEM'+replicate('0',10-len('178148'))+'178148',
'MEM'+replicate('0',10-len('16996'))+'16996',
'MEM'+replicate('0',10-len('70493'))+'70493',
'MEM'+replicate('0',10-len('67203'))+'67203',
'MEM'+replicate('0',10-len('18980'))+'18980',
'MEM'+replicate('0',10-len('19150'))+'19150',
'MEM'+replicate('0',10-len('20081'))+'20081',
'MEM'+replicate('0',10-len('19692'))+'19692',
'MEM'+replicate('0',10-len('69072'))+'69072',
'MEM'+replicate('0',10-len('20675'))+'20675',
'MEM'+replicate('0',10-len('22654'))+'22654',
'MEM'+replicate('0',10-len('23298'))+'23298',
'MEM'+replicate('0',10-len('63515'))+'63515',
'MEM'+replicate('0',10-len('64424'))+'64424',
'MEM'+replicate('0',10-len('64498'))+'64498')
AND att_typ_cde = 'CERTIFICATE'
AND att_vld_sdt = '2019-01-01 00:00:00.000'