APPS.WF_DIAGNOSTICS_APPS SQL Statements

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

Line: 41

	select VARIABLE_NAME, VALUE
	from FND_ENV_CONTEXT
	where CONCURRENT_PROCESS_ID in
	      (select  max(CONCURRENT_PROCESS_ID)
	       from FND_CONCURRENT_PROCESSES fcp , FND_CONCURRENT_QUEUES fcq
	       where fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
	       and   fcq.CONCURRENT_QUEUE_NAME= p_qname
	       and   fcp.QUEUE_APPLICATION_ID  = p_appId  )
        and VARIABLE_NAME in ('APPL_TOP', 'APPLCSF', 'APPLLOG', 'FND_TOP',
			      'AF_CLASSPATH', 'AFJVAPRG', 'AFJRETOP', 'CLASSPATH',
			      'PATH', 'LD_LIBRARY_PATH', 'ORACLE_HOME', 'NLS_LANG',
	                      'AF_LD_LIBRARY_PATH')
       order by VARIABLE_NAME;

Line: 64

    select decode(fnd_profile.value('CONC_GSM_ENABLED'), 'Y', 'ENABLED', 'NOT ENABLED')
    into   l_gsm_enabled from dual;

Line: 147

             SELECT application_id INTO l_app_id
             FROM fnd_application
             WHERE application_short_name = l_service_instances(i).application;

Line: 155

	        SELECT  user_concurrent_queue_name,
			concurrent_queue_id,
			decode(enabled_flag, 'Y', 'ENABLED', 'NOT ENABLED')
		INTO    l_user_concurrent_queue_name, l_managerid, l_service_enabed
		FROM    fnd_concurrent_queues_vl
		WHERE   concurrent_queue_name = l_service_instances(i).instance_name;