[Purge] Oracle EBS 查看是否存在txn被purged了

SQL:

select * from mtl_purge_header order by organization_id

SELECT mp.organization_id
              ,mp.organization_code
              ,mp.wms_enabled_flag
             ,nvl(duom.duom_items, 0)
             ,nvl(prg.prg_lines, 0)
FROM mtl_parameters mp
         , ( select organization_id , count(1) duom_items from mtl_system_items_b
              where tracking_quantity_ind = 'PS'
              group by organization_id) duom
          , ( select organization_id,  count(1) prg_lines from mtl_purge_header
               group by organization_id) prg
where mp.organization_id = duom.organization_id(+)
and mp.organization_id = prg.organization_id(+)
order by 1