员工离职停用ebs账号时，需要检查的内容

 员工离职时需要检查其有没有正则审批中的pr/po，否则停用账号后，会引起异常。

select

--  DISTINCT fu.user_name
 prla.requisition_line_id,
 t.authorization_status,
 
 fu.description,
 fu.email_address, ---t.* 
 t.segment1,
 prla.line_num,
 (select msib.segment1
    from apps.mtl_system_items_b msib
   where msib.inventory_item_id = prla.item_id
     and msib.organization_id = prla.destination_organization_id) item_no,
 prla.item_description,
 prla.unit_price * prla.quantity amount,
 PRLA.CREATION_DATE
  from po.po_requisition_headers_all t,
       apps.fnd_user                      fu,
       po.po_requisition_lines_all   prla
 where 1 = 1
      --t.created_by in (5565)   --4925 user_id
   and t.created_by = fu.user_id
   and prla.requisition_header_id = t.requisition_header_id
   and prla.org_id = t.org_id
  -- and fu.user_name in ('6I20324')
      /*   and prla.item_id in (select t.inventory_item_id
                                from inv.mtl_system_items_b t
                               where \*t.segment1 in ('C112-010-013','MD425-03-004')*\
                               t.item_type = 'SI'
                               and t.description like '%垫%')*/
      
      --and t.authorization_status!='APPROVED'
  -- and t.authorization_status = 'IN PROCESS'
 order by prla.requisition_header_id, prla.line_num;