[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
retu := 'SELECT fpg.APPLICATIONS_SYSTEM_NAME, fpg.RELEASE_NAME'
|| ' , flue.severity, flue.status, fnd_date.DATE_TO_DISPLAYDT(flm.timestamp, ''GMT'') TIMESTAMP_GMT, flue.category, flue.english_message'
|| ' , flm.log_sequence, flue.unique_exception_id'
|| ' , fltc.component_type, fltc.component_id, fac.component_name, nvl(fac.display_name,''UNKNOWN'') COMP_DISPLAY_NAME, fac.description COMP_DESCRIPTION'
|| ' , fltc.component_appl_id, fa.application_short_name COMPONENT_APPL_SHORT_NAME, fat.application_name COMPONENT_APPL_NAME, flm.module'
|| ' , fltc.user_id, fu.user_name, fltc.responsibility_id, fr.responsibility_key, frt.responsibility_name'
|| ' , fltc.resp_appl_id, fra.application_short_name RESP_APPL_SHORT_NAME, frat.application_name RESP_APPL_NAME'
|| ' , flm.audsid, gvi.instance_name, flm.db_instance, fle.session_module, fle.session_action'
|| ' , fltc.session_id, flm.node, flm.node_ip_address, fltc.security_group_id, fsg.security_group_key, fsgt.security_group_name'
|| ' , flm.process_id, flm.thread_id, flm.jvm_id'
|| ' , fltc.transaction_context_id, fltc.transaction_type, fltc.transaction_id'
|| ' FROM'
|| ' fnd_log_transaction_context fltc, fnd_log_messages flm, fnd_log_attachments flattach'
|| ' , fnd_log_exceptions fle, fnd_log_unique_exceptions flue, fnd_user fu, fnd_app_components_vl fac'
|| ' , fnd_application fa, fnd_application_tl fat, fnd_responsibility fr, fnd_responsibility_tl frt'
|| ' , fnd_application fra, fnd_application_tl frat, fnd_security_groups fsg, fnd_security_groups_tl fsgt'
|| ' , gv$instance gvi, fnd_product_groups fpg'
|| ' WHERE '
|| ' fltc.transaction_context_id = flm.transaction_context_id and flm.log_sequence = fle.log_sequence'
|| ' and fle.unique_exception_id = flue.unique_exception_id and flm.user_id = fu.user_id (+) '
|| ' and fltc.component_type = fac.component_type (+) and fltc.component_appl_id = fac.application_id (+)'
|| ' and fltc.component_id = fac.component_id (+) and fltc.component_appl_id = fa.application_id (+)'
|| ' and fltc.responsibility_id = fr.responsibility_id (+) and fltc.resp_appl_id = fra.application_id (+)'
|| ' and fltc.security_group_id = fsg.security_group_id (+) and flm.db_instance = gvi.instance_number (+)'
|| ' and flm.log_sequence = flattach.log_sequence (+) and fa.application_id = fat.application_id (+)'
|| ' and fat.language (+) = userenv(''LANG'') and fr.responsibility_id = frt.responsibility_id (+)'
|| ' and frt.language (+) = userenv(''LANG'') and fra.application_id = frat.application_id (+)'
|| ' and frat.language (+) = userenv(''LANG'') and fsg.security_group_id = fsgt.security_group_id (+)'
|| ' and fsgt.language (+) = userenv(''LANG'') AND flm.log_sequence = ' || p_logSEQ;