SELECT A.REQ_ID,A.REQ_CODE,a.HO_NOTES,b.QTY_ETM,b.TYPE_XL
FROM TR_REQUEST_SHOP_DOC A 
LEFT JOIN TR_REQUEST_SHOP_DOC_DT B ON A.REQ_ID = B.REQ_DOC_ID
WHERE A.REQ_TYPE = 'CPTS' AND A.STATUS IN ('TBP_D','QLTS_D','APPROVE')
AND A.REQ_CODE NOT IN ('PYC/2023/000002','PYC/2023/000004','PYC/2023/000005','PYC/2023/000021','PYC/2023/000027','PYC/2023/000048','PYC/2023/000051')