[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT printer,
print_style,
decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
,number_of_copies
FROM fnd_concurrent_requests fcr
WHERE fcr.request_id = c_request_id;
select
p.srs_flag, p.concurrent_program_name, r.program_application_id,
r.argument1, r.argument2, r.argument3, r.argument4,
r.argument5, r.argument6, r.argument7, r.argument8,
r.argument9, r.argument10, r.argument11, r.argument12,
r.argument13, r.argument14, r.argument15, r.argument16,
r.argument17, r.argument18, r.argument19, r.argument20,
r.argument21, r.argument22, r.argument23, r.argument24,
r.argument25, r.number_of_arguments,r.request_date
from fnd_concurrent_requests r, fnd_concurrent_programs p
where r.request_id = p_conc_request_id
and r.concurrent_program_id = p.concurrent_program_id
and r.program_application_id = p.application_id;
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
from fnd_conc_request_arguments
where request_id = p_conc_request_id;
select to_number(substr(application_column_name, 10)) num,
end_user_column_name
from fnd_descr_flex_column_usages
where application_id = l_appl_id
and descriptive_flexfield_name = '$SRS$.'||l_conc_prog_name
and descriptive_flex_context_code = 'Global Data Elements'
and enabled_flag = 'Y'
order by column_seq_num;