[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT nvl(meaning, 'UNKNOWN')
INTO c_status
FROM fnd_lookups
WHERE lookup_type = 'CP_STATUS_CODE'
AND lookup_code = p_status_code;
SELECT nvl(meaning, 'UNKNOWN')
INTO c_phase
FROM fnd_lookups
WHERE lookup_type = 'CP_PHASE_CODE'
AND lookup_code = p_phase_code;
SELECT running_processes,
max_processes,
decode(control_code, 'T', 'N', -- Abort
'X', 'N', -- Aborted
'D', 'N', -- Deactivate
'E', 'N', -- Deactivated
'Y') active
FROM fnd_concurrent_worker_requests
WHERE request_id = rid
AND NOT((queue_application_id = 0)
AND(concurrent_queue_id IN(1, 4)));
SELECT runalone_flag
INTO run_alone_flag
FROM fnd_conflicts_domain d
WHERE d.cd_id = manager_check.cd_id;
SELECT user_concurrent_queue_name name,
fcwr.running_processes active,
decode(fcwr.control_code, 'A', fl.meaning, 'D', fl.meaning, 'E', fl.meaning, 'N', fl.meaning, 'R', fl.meaning, 'T',
fl.meaning, 'U', fl.meaning, 'V', fl.meaning, 'X', fl.meaning, NULL, 'Running', '** Unknown Status **') status
FROM fnd_concurrent_queues_vl fcqv,
fnd_concurrent_worker_requests fcwr,
fnd_lookups fl
WHERE fcwr.request_id = rid
AND fcwr.concurrent_queue_id = fcqv.concurrent_queue_id
AND fcwr.concurrent_queue_id NOT IN(1, 4)
AND fl.lookup_code(+) = fcwr.control_code
AND fl.lookup_type(+) = 'CP_CONTROL_CODE';
SELECT request_id,
phase_code,
status_code
FROM fnd_concurrent_requests
WHERE parent_request_id = p_req_id;
SELECT to_run_application_id,
to_run_concurrent_program_id
FROM fnd_concurrent_program_serial
WHERE running_application_id = conc_app_id
AND running_concurrent_program_id = conc_id;
SELECT request_id,
phase_code,
status_code
FROM fnd_concurrent_requests
WHERE phase_code = 'R'
AND program_application_id = traid
AND concurrent_program_id = trcpid
AND cd_id = conc_cd_id;
SELECT request_id,
to_char(requested_start_date, 'DD-MON-RR HH24:MI:SS') start_date,
phase_code,
status_code
FROM fnd_concurrent_requests
WHERE phase_code IN('R', 'P')
AND requested_by = uid
AND requested_start_date < s
AND hold_flag = 'N';
SELECT *
INTO reqinfo
FROM fnd_concurrent_requests
WHERE request_id = p_req_id;
SELECT fvl.*
INTO proginfo
FROM fnd_concurrent_programs_vl fvl,
fnd_concurrent_requests fcr
WHERE fcr.request_id = p_req_id
AND fcr.concurrent_program_id = fvl.concurrent_program_id
AND fcr.program_application_id = fvl.application_id;
SELECT nvl(application_name, '-- UNKNOWN APPLICATION --')
INTO conc_app_name
FROM fnd_application_vl fvl,
fnd_concurrent_requests fcr
WHERE fcr.request_id = p_req_id
AND fcr.program_application_id = fvl.application_id;
SELECT nvl(meaning, 'UNKNOWN')
INTO m_buf
FROM fnd_lookups
WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND lookup_code = proginfo.execution_method_code;
SELECT nvl(execution_file_name, 'NONE')
INTO exe_file_name
FROM fnd_executables
WHERE application_id = proginfo.executable_application_id
AND executable_id = proginfo.executable_id;
SELECT request_class_name
INTO rclass_name
FROM fnd_concurrent_request_class
WHERE application_id = proginfo.class_application_id
AND request_class_id = proginfo.concurrent_class_id;
SELECT user_name
INTO c_user
FROM fnd_user
WHERE user_id = reqinfo.requested_by;
SELECT user_name
INTO last_user
FROM fnd_user
WHERE user_id = reqinfo.last_updated_by;
SELECT responsibility_name
INTO resp_name
FROM fnd_responsibility_vl
WHERE responsibility_id = reqinfo.responsibility_id
AND application_id = reqinfo.responsibility_application_id;
SELECT user_concurrent_queue_name
INTO mgrname
FROM fnd_concurrent_queues_vl
WHERE concurrent_queue_id = reqinfo.controlling_manager;
SELECT queue_control_flag
INTO qcf
FROM fnd_concurrent_programs
WHERE concurrent_program_id = reqinfo.concurrent_program_id
AND application_id = reqinfo.program_application_id;
SELECT nvl(reqinfo.logfile_name, '-- No logfile --')
INTO filename
FROM dual;
SELECT nvl(reqinfo.outfile_name, '-- No output file --')
INTO filename
FROM dual;
SELECT user_concurrent_queue_name
INTO mgrname
FROM fnd_concurrent_queues_vl
WHERE concurrent_queue_id = reqinfo.controlling_manager;
SELECT nvl(reqinfo.logfile_name, '-- No logfile --')
INTO filename
FROM dual;
SELECT nvl(reqinfo.outfile_name, '-- No output file --')
INTO filename
FROM dual;
SELECT nvl(concurrent_program_name, 'UNKNOWN')
INTO conc_prog_name
FROM fnd_concurrent_programs
WHERE concurrent_program_id = reqinfo.concurrent_program_id;
SELECT queue_control_flag
INTO qcf
FROM fnd_concurrent_programs
WHERE concurrent_program_id = reqinfo.concurrent_program_id
AND application_id = reqinfo.program_application_id;
note := jtf_diag_report_factory.create_note('It was placed on hold by: ' || last_user || ' on ' || to_char(reqinfo.last_update_date, 'DD-MON-RR HH24:MI:SS'), reportcontext);
SELECT nvl(parent_request_id, -1)
INTO parent_id
FROM fnd_conc_req_summary_v
WHERE request_id = p_req_id;
SELECT nvl(parent_request_id, -1)
INTO parent_id
FROM fnd_conc_req_summary_v
WHERE request_id = p_req_id;
SELECT program_application_id,
concurrent_program_id,
cd_id
INTO conc_app_id,
conc_id,
conc_cd_id
FROM fnd_concurrent_requests
WHERE request_id = p_req_id;
SELECT user_cd_name
INTO conflict_domain
FROM fnd_conflicts_domain
WHERE cd_id = reqinfo.cd_id;
SELECT request_id,
status_code,
actual_start_date
INTO tmp_id,
tmp_status,
tmp_date
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp
WHERE fcp.run_alone_flag = 'Y'
AND fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcr.phase_code = 'R'
AND fcr.cd_id = reqinfo.cd_id;