Open Purchase Orders and Requisitions

I am trying to determine the Open Purchase Requisitions and Purchase Orders on my system. I have a Sql Script as follows

select
  poh.segment1 as PO_NUM,
  pv.vendor_name,
  pol.line_num,
  msib.segment1,
  msib.description,
  (fcb.segment1||' - '||fcb.segment2) as Asset_category ,
  mcc.segment1 ||' - '||mcc.segment2 ||' - '||mcc.segment3 as Purch_category,
  poll.quantity as Qty_Ordered,
  poll.quantity_received as Qty_Received,
  poll.quantity_billed as Qty_Invoiced,
  gcc.segment2||' - '||gcc.segment3||' - '||gcc.segment4 as Account,
  ffv1.description||' - '||ffv2.description||' - '||ffv3.description as Account_desc