SELECT * FROM TR_PO_MASTER tpm WHERE tpm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/001034')
SELECT * FROM TR_PO_DETAIL tpd WHERE tpd.PO_ID IN (SELECT tpm.PO_ID FROM TR_PO_MASTER tpm WHERE tpm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/001034'))
--update 23052023_secretkey