check_data.txt
| 1 |
SELECT A.REQ_ID,A.REQ_CODE,a.HO_NOTES,b.QTY_ETM,b.TYPE_XL |
|---|---|
| 2 |
FROM TR_REQUEST_SHOP_DOC A |
| 3 |
LEFT JOIN TR_REQUEST_SHOP_DOC_DT B ON A.REQ_ID = B.REQ_DOC_ID |
| 4 |
WHERE A.REQ_TYPE = 'CPTS' AND A.STATUS IN ('TBP_D','QLTS_D','APPROVE')
|
| 5 |
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')
|