[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT l.language language_code,
l.territory territory_code
FROM xdo_lobs l
WHERE l.lob_type = 'TEMPLATE'
AND l.lob_code = p_template_code
AND l.application_short_name = p_template_application;
SELECT tb.default_language default_language
FROM xdo_templates_b tb
WHERE tb.application_short_name = p_template_application
AND tb.template_code = p_template_code;
SELECT il.name
INTO l_language_desc
FROM fnd_iso_languages_vl il
WHERE il.iso_language_2 = l_language_code;
SELECT tr.territory_short_name
INTO l_territory_desc
FROM fnd_territories_vl tr
WHERE tr.territory_code = upper(rec.territory_code);
SELECT rv.report_name report_name,
rv.report_code report_code,
rv.report_application report_application, -- added column 19.4.2006
rc.report_context_id rpt_context_id,
tc.template_context_id tpl_ctx_id,
tc.pdf_allowed pdf_format_allowed,
tc.rtf_allowed rtf_format_allowed,
tc.htm_allowed htm_format_allowed,
tc.xls_allowed xls_format_allowed,
tc.txt_allowed txt_format_allowed,
tv.template_name template_name,
tv.template_code template_code,
tv.template_application template_application -- added column 19.4.2006
FROM xdo_dgf_block_contexts bc,
xdo_dgf_rpt_contexts rc,
xdo_dgf_reports_v rv,
xdo_dgf_tpl_contexts tc,
xdo_dgf_templates_v tv,
fnd_request_group_units ru,
fnd_request_groups rg,
fnd_responsibility_vl fr,
fnd_concurrent_programs_vl fc
WHERE bc.form_code = p_form_code
AND bc.block_code = p_block_code
AND bc.block_context_id = rc.block_context_id
AND rv.report_code = rc.report_code
AND rv.report_application = rc.report_application
AND tc.report_context_id = rc.report_context_id
AND tv.template_code = tc.template_code
AND tv.template_application = tc.template_application
AND rv.report_code = fc.concurrent_program_name
AND ru.application_id = rg.application_id
AND ru.request_group_id = rg.request_group_id
AND rg.application_id = fr.group_application_id
AND rg.request_group_id = fr.request_group_id
AND ru.request_unit_id = fc.concurrent_program_id
AND ru.unit_application_id = fc.application_id
AND ru.request_unit_type = 'P'
AND fr.responsibility_id = p_resp_id
ORDER BY rv.report_code;
SELECT tr.rule_catalog_id xrg_id,
tr.format_filter_type format_filter_type
FROM xdo_dgf_tpl_rules tr
WHERE tr.template_context_id = p_tpl_context_id;
SELECT cat.rule_short_name rule_short_name,
cat.rule_type rule_type,
cat.rule_variable rule_variable,
cat.rule_operator rule_operator,
cat.rule_values rule_values,
cat.rule_values_datatype rule_values_datatype,
cat.db_function db_function,
cat.arg_number arg_number,
cat.arg01 arg01,
cat.arg02 arg02,
cat.arg03 arg03,
cat.arg04 arg04,
cat.arg05 arg05,
cat.arg06 arg06,
cat.arg07 arg07,
cat.arg08 arg08,
cat.arg09 arg09,
cat.arg10 arg10,
cat.arg01_type arg01_type,
cat.arg02_type arg02_type,
cat.arg03_type arg03_type,
cat.arg04_type arg04_type,
cat.arg05_type arg05_type,
cat.arg06_type arg06_type,
cat.arg07_type arg07_type,
cat.arg08_type arg08_type,
cat.arg09_type arg09_type,
cat.arg10_type arg10_type
FROM xdo_dgf_rule_catalog_vl cat
WHERE cat.rule_catalog_id = p_xrg_id;
l_sql := 'SELECT c.report_code, c.report_application, p.parameter_type, p.parameter_value, p.parameter_name ' -- modified 29.11.2006 - new column PARAMETER_NAME
|| 'FROM XDO_DGF_RPT_CONTEXT_PARAMETERS p, XDO_DGF_RPT_CONTEXTS c '
|| 'WHERE p.xrc_id = c.id '
|| ' AND c.id in ('
|| l_rpt_context_id_list
|| ')'
|| ' order by c.report_code, p.parameter_sequence';
g_parameter_list.delete;
l_report_list_final.delete;
g_report_list.delete;