How to Approve back cancelled PR (Oracle Apps)
DECLARE CURSOR c IS SELECT b.requisition_header_id, b.requisition_line_id, b.quantity, a.segment1 FROM po_requisition_headers_all a, po_requisition_lines_all b, po_req_distributions_all c WHERE a.segment1 IN ( SELECT DISTINCT prh.segment1 requisition_num --, fu.user_name requestor, -- papf.full_name, TO_CHAR (prh.creation_date) creation_date, -- prh.creation_date, prh.authorization_status, prh.closed_code FROM apps.po_requisition_headers_all prh, ...