DBA Data[Home] [Help]

APPS.BIS_RSG_VH_PURGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

  delete from bis_request_set_options opt where request_set_name not in
    (select request_set_name from fnd_request_sets req
     where req.request_set_name = opt.request_set_name and req.application_id=opt.set_app_id );
Line: 9

  delete from bis_request_set_objects obj where request_set_name not in
    (select request_set_name from fnd_request_sets req
     where req.request_set_name = obj.request_set_name and req.application_id=obj.set_app_id );