Procure to Pay query without receipts

SELECT reqh.segment1 req_num,

       reqh.authorization_status req_status,

       -- poh.po_header_id,

       poh.segment1 po_num,

       pol.line_num,

       poh.authorization_status po_status,

       -- i.invoice_id,

       i.invoice_num,

       i.invoice_amount,

       i.amount_paid,

       i.vendor_id,

       -- v.vendor_name,

       -- p.check_id,

       c.check_number,

       h.gl_transfer_flag,

       h.period_name

  FROM ap_invoices_all i,

       ap_invoice_distributions_all invd,

       po_headers_all poh,

       po_lines_all pol,

       po_distributions_all pod,

       po_vendors v,

       po_requisition_headers_all reqh,

       po_requisition_lines_all reql,

       po_req_distributions_all reqd,

       ap_invoice_payments_all p,

       ap_checks_all c,

       ap_ae_headers_all h,

       ap_ae_lines_all l

 WHERE 1 = 1

   AND i.vendor_id = v.vendor_id

   AND c.check_id = p.check_id

   AND p.invoice_id = i.invoice_id

   AND poh.po_header_id = pol.po_header_id

   AND reqh.requisition_header_id = rql.requisition_header_id

   AND reqd.requisition_line_id = reql.requisition_line_id

   AND pod.req_distribution_id = reqd.distribution_id

   AND pod.po_header_id = poh.po_header_id

   AND pod.po_distribution_id = invd.po_distribution_id

   AND invd.invoice_id = i.invoice_id

   AND h.ae_header_id = l.ae_header_id

   AND l.source_table = 'AP_INVOICES'

   AND l.source_id = i.invoice_id

   --and poh.segment1 = 4033816 -- PO NUMBER

   AND reqh.segment1 = '501' -- REQ NUMBER

   --and i.invoice_num = 3114 -- INVOICE NUMBER

   --and c.check_number =  -- CHECK NUMBER

   --and vendor_id =   -- VENDOR ID