PO quries

=====================================
Concurrent Program Runtime in Minutes
=====================================
SELECT
  /*+ rule */
  rq.request_id "Req. ID",
  tl.user_concurrent_program_name "Program Name",
  to_char(rq.actual_start_date,'DD-MON-YY HH24:MI:SS') "Start Date",
  to_char(rq.actual_completion_date,'DD-MON-YY HH24:MI:SS') "Completion Date",
  ROUND((rq.actual_completion_date - rq.actual_start_date) * 1440, 2) "Runtime (in Minutes)"
FROM apps.fnd_concurrent_programs_tl tl,
  apps.fnd_concurrent_requests rq
WHERE tl.application_id             = rq.program_application_id
AND tl.concurrent_program_id        = rq.concurrent_program_id
AND tl.LANGUAGE                     = USERENV('LANG')
AND rq.actual_start_date           IS NOT NULL
AND rq.actual_completion_date      IS NOT NULL
AND tl.user_concurrent_program_name = 'Journal Import' -- <change it>
ORDER BY rq.request_id DESC;

=======================================
Purchase Order from Requisition Number
=======================================

This is the query to find out the purchase order number from requisition number

SELECT DISTINCT pha.segment1
FROM po_headers_all pha,
  po_distributions_all pda,
  po_req_distributions_all rda,
  po_requisition_headers_all rha,
  po_requisition_lines_all rla
WHERE pha.po_header_id       =pda.po_header_id
AND pda.req_distribution_id  =rda.distribution_id
AND rda.requisition_line_id  =rla.requisition_line_id
AND rla.requisition_header_id=rha.requisition_header_id
AND rha.segment1             ='&Requisition'

You can also find out the requisition number from purchase order number by using query given below

SELECT DISTINCT rha.segment1
FROM apps.po_requisition_headers_all rha,
  apps.po_requisition_lines_all rla,
  apps.po_req_distributions_all rda,
  apps.po_distributions_all pda,
  apps.po_headers_all pha
WHERE rha.requisition_header_id=rla.requisition_header_id
AND rla.requisition_line_id    =rda.requisition_line_id
AND rda.distribution_id        =pda.req_distribution_id
AND pda.po_header_id           =pha.po_header_id
AND pha.segment1               ='626900'