SQL Query to fetch Approved Work Confirmation in Oracle Apps R12 - Orapoint

SELECT  DISTINCT 
         rsh.SHIPMENT_HEADER_ID,  
         poh.segment1 po_number,
         rsh.CREATION_DATE, 
         rsh.SHIPMENT_NUM work_confm_num,
         nvl(rsh.APPROVAL_STATUS,'PENDING')APPROVAL_STATUS,
         SHIPMENT_LINE_STATUS_CODE,
         rsl.amount_received,
         rsl.item_description Rec_line_description,
         (SELECT vendor_name FROM po_vendors WHERE vendor_id = rsh.vendor_id) Vendor_Name,
         rsh.performance_period_from,
         rsh.performance_period_to,
         rsh.COMMENTS Comments_header 
 FROM    rcv_shipment_headers rsh,
         rcv_shipment_lines rsl, 
         po_headers_all poh
 WHERE   rsh.SHIPMENT_HEADER_ID = rsl.SHIPMENT_HEADER_ID
 AND     rsl.po_header_id = poh.po_header_id
 AND     NVL(rsl.SHIPMENT_LINE_STATUS_CODE,'A')<>'CANCELLED'
 AND     ASN_TYPE = 'WC'
 AND     NVL(rsh.APPROVAL_STATUS,'A') IN ( 'APPROVED')
 AND     trunc(rsh.CREATION_DATE) > '31-Jan-2020'
 ORDER BY po_number;