How to find the all cancel PO Requisitions in oracle apps EBS R12

How to find the all cancel PO Requisitions in oracle apps EBS R12
  
 ---- All cancel PO Requisitions -----
SELECT prh.requisition_header_id, prh.preparer_id, prh.segment1 "REQ NUM",
       TRUNC (prh.creation_date), prh.description, prh.note_to_authorizer
  FROM apps.po_requisition_headers_all prh, apps.po_action_history pah
 WHERE action_code = 'CANCEL'
   AND pah.object_type_code = 'REQUISITION'
   AND pah.object_id = prh.requisition_header_id

---------------- END -------------