APPS.FND_DIAG_CM SQL Statements

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

Line: 58

    select a.request_id rqa, b.request_id rqb
	from fnd_concurrent_requests a, fnd_concurrent_requests b
	where a.PARENT_REQUEST_ID = parrqid
	  and b.PARENT_REQUEST_ID = parrqid
	  and (a.CRM_RELEASE_DATE < b.actual_COMPLETION_DATE and
		a.actual_completion_date > b.actual_start_date)
          and ((a.concurrent_PROGRAM_ID = apid
                and b.concurrent_PROGRAM_ID = cpid)
               or
	       (b.concurrent_PROGRAM_ID = apid
	        and a.concurrent_PROGRAM_ID = cpid)
               or
	       (a.cd_id = b.cd_id
	        and ((a.concurrent_PROGRAM_ID = apid
                      and b.concurrent_PROGRAM_ID = bpid)
                     or
	             (a.concurrent_PROGRAM_ID = bpid
	              and b.concurrent_PROGRAM_ID = apid))));

Line: 149

select concurrent_program_id
  into apid
  from fnd_concurrent_programs p,fnd_application a
 where a.application_id = p.application_id and p.concurrent_program_name = 'FNDCRMTA' and a.application_short_name='FND';

Line: 154

select concurrent_program_id
  into bpid
  from fnd_concurrent_programs p,fnd_application a
 where a.application_id=p.application_id and p.concurrent_program_name = 'FNDCRMTB' and a.application_short_name='FND';

Line: 159

select concurrent_program_id
  into cpid
  from fnd_concurrent_programs p,fnd_application a
 where a.application_id = p.application_id and p.concurrent_program_name = 'FNDCRMTC' and a.application_short_name='FND';