rem This program will run under apps on Rel 10.7
rem it will check the existing records under
rem fnd_concurrent_requests and delete the non
rem existing records on oe.so_exceptions table.
rem
-------------------------------------------------
set long 90000
set head on
set echo on
select a.request_id,
       a.creation_date,
       a.last_update_date,
       a.context,
       a.message_text
from so_exceptions a
where not exists (select b.request_id
                  from fnd_concurrent_requests b
                  where a.request_id =
                               b.request_id)
/
delete from so_exceptions a
       where not exists (select b.request_id
       from fnd_concurrent_requests b
          where a.request_id = b.request_id)
/

Return to : Oracle Database, SQL, Application, Programming Tips