[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select to_number(substr(application_column_name,10)) ,enabled_flag
from fnd_descr_flex_column_usages
where application_id = app_id
and descriptive_flexfield_name = flex_name
order by column_seq_num;
select count(*) into g_arg_count
from fnd_conc_request_arguments
where request_id = reqid;
attr_to_arg.delete(attr_counter);
select r.program_application_id , p.concurrent_program_name
into app_id, prog_short_name
from fnd_concurrent_requests r, fnd_concurrent_programs p
where r.request_id = reqid
and r.concurrent_program_id = p.concurrent_program_id
and r.program_application_id = p.application_id;
select argument1, argument2, argument3, argument4,
argument5, argument6, argument7, argument8,
argument9, argument10, argument11, argument12,
argument13, argument14, argument15, argument16,
argument17, argument18, argument19, argument20,
argument21, argument22, argument23, argument24,
argument25
into args(1), args(2), args(3), args(4),
args(5), args(6), args(7), args(8),
args(9), args(10), args(11), args(12),
args(13), args(14), args(15), args(16),
args(17), args(18), args(19), args(20),
args(21), args(22), args(23), args(24),
args(25)
from fnd_concurrent_requests
where request_id = reqid;
select argument26,argument27,argument28,
argument29,argument30,argument31,argument32,argument33,
argument34,argument35,argument36,argument37,argument38,
argument39,argument40,argument41,argument42,argument43,
argument44,argument45,argument46,argument47,argument48,
argument49,argument50,argument51,argument52,argument53,
argument54,argument55,argument56,argument57,argument58,
argument59,argument60,argument61,argument62,argument63,
argument64,argument65,argument66,argument67,argument68,
argument69,argument70,argument71,argument72,argument73,
argument74,argument75,argument76,argument77,argument78,
argument79,argument80,argument81,argument82,argument83,
argument84,argument85,argument86,argument87,argument88,
argument89,argument90,argument91,argument92,argument93,
argument94,argument95,argument96,argument97,argument98,
argument99,argument100
into args(26),args(27),args(28),args(29),args(30),
args(31),args(32),args(33),args(34),args(35),
args(36),args(37),args(38),args(39),args(40),
args(41),args(42),args(43),args(44),args(45),
args(46),args(47),args(48),args(49),args(50),
args(51),args(52),args(53),args(54),args(55),
args(56),args(57),args(58),args(59),args(60),
args(61),args(62),args(63),args(64),args(65),
args(66),args(67),args(68),args(69),args(70),
args(71),args(72),args(73),args(74),args(75),
args(76),args(77),args(78),args(79),args(80),
args(81),args(82),args(83),args(84),args(85),
args(86),args(87),args(88),args(89),args(90),
args(91),args(92),args(93),args(94),args(95),
args(96),args(97),args(98),args(99),args(100)
from fnd_conc_request_arguments
where request_id = reqid;
select 'I',
'M'
into upcode,
uscode
from sys.dual
where not exists (select null
from fnd_concurrent_worker_requests
where request_id = rid
and running_processes > 0
and (not (queue_application_id = 0
and concurrent_queue_id in (1,4))
or queue_control_flag = 'Y'));
select meaning into req_phase
from fnd_lookups
where lookup_code = upcode
and lookup_type = ltype;
select meaning into req_status
from fnd_lookups
where lookup_code = req_status_code
and lookup_type = ltype;
FOR temp_record IN (SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = ltype
ORDER BY to_number(lookup_code)) LOOP
weeks(rec_count) := temp_record.meaning;
FOR temp_record IN (SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = ltype
ORDER BY to_number(lookup_code)) LOOP
weekdays(rec_count) := temp_record.meaning;
FOR temp_record IN (SELECT meaning
FROM fnd_lookup_values_vl
WHERE lookup_type = ltype
ORDER BY to_number(lookup_code)) LOOP
months(rec_count) := temp_record.meaning;
SELECT COUNT(*)
into cnt
from FND_CONC_RELEASE_CLASSES
WHERE OWNER_REQ_ID is not null
AND RELEASE_CLASS_NAME = schedule_name
AND rownum < 2;
select resubmit_interval, resubmit_interval_unit_code
into interval, int_unit
from fnd_concurrent_requests
where request_id = req_id;
select sch_id, sch_exists, sch_perm, sch_owner_req_id,
requested_start_date, request_date, sch_date1, sch_date2, sch_name,
sch_curr_values, sch_type
into l_sch_id, l_sch_exists, l_sch_perm, l_sch_owner_req_id,
l_requested_start_date, l_request_date, l_sch_date1, l_sch_date2,
l_sch_name, l_sch_curr_values, l_sch_type
from fnd_conc_requests_form_v
where request_id = get_sch_desc.request_id;
select count(*) into i
from fnd_descr_flex_column_usages
where application_id = program_appl_id
and descriptive_flexfield_name = '$SRS$.' || program_name
and descriptive_flex_context_code = 'Global Data Elements'
and enabled_flag = 'Y'
and display_flag = 'Y';
select to_char(trunc(sysdate) + (end_time - begin_time), 'HH24:MI:SS')
into e_time
from sys.dual;
select substrb(display_name,1,80) dname
from fnd_conc_pp_actions pp,
wf_roles wf
where pp.concurrent_request_id = req_id
and pp.action_type = 2
and wf.orig_system_id = pp.orig_system_id
and wf.orig_system = pp.orig_system
and wf.name = pp.arguments
order by sequence;
select * into lp_code, lof_name, lof_size, lsave_of from
(select R.phase_code,
decode(nvl(A.Action_type,0), 6, O.file_name, R.outfile_name),
decode(nvl(A.action_type,0), 6, O.file_size, R.ofile_size),
R.save_output_flag
from fnd_concurrent_requests R,
fnd_conc_pp_actions A,
fnd_conc_req_outputs O
where R.request_id = A.concurrent_request_id (+)
and R.request_id = O.concurrent_request_id (+)
and R.request_id = req_id
order by A.action_type desc)
where rownum=1;
sqlstmt varchar2(1000) := 'select count(*) from ' ||
' xdo_templates_vl T, fnd_concurrent_programs P, ' ||
' fnd_application A ' ||
' where DS_APP_SHORT_NAME= :1 and data_source_code= :2 ' ||
' and template_status = ''E'' and sysdate between ' ||
' start_date and nvl(end_date, sysdate) ' ||
' and P.concurrent_program_name= T.data_source_code ' ||
' and A.application_short_name = T.DS_APP_SHORT_NAME ' ||
' and P.application_id = A.application_id ' ||
' and P.output_file_type = ''XML''';
execute immediate 'select count(*) from xdo_templates_vl' into cnt;