隨手筆記

declare
po_number varchar2(20):='PO單號' ;
begin
  --po header
  FOR R1 IN (select *
               from po_headers_all
              where segment1 =po_number)
  loop

   update po_headers_all
      set authorization_status='APPROVED',
          approved_flag='Y',
          approved_date=sysdate
    where po_header_id =r1.po_header_id;--r1.po_header_id

     --po lines
     for r2 in (select *
                 from po_lines_all
                where po_header_id =r1.po_header_id)

     loop
       UPDATE po_line_locations_all
          SET approved_flag='Y',
              approved_date=sysdate
        where po_line_id =r2.po_line_id;
     end loop;

 /*  select *
     from po_distributions_all 
    where po_line_id in (29568,29910)*/
  end loop;
  commit;
end;