select tran_date from WORKORDER_RECEIPT
where TRAN_ID
in ( select PORCP_NO from qc_order where qorder_no = ?


git-svn-id: http://15.206.35.175/svn/proteus/business-java/trunk@32116 ce508802-f39f-4f6c-b175-0d175dae99d5