[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(b.arrears_yn, 'Y', 1, 0) arrears
,decode(a.frq_code, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, 0) frequency
,nvl(b.deferred_pmts, 0) deferred_pmts
,nvl(b.advance_pmts, 0) advance_pmts
,b.lrs_rate
,b.effective_from_date
,b.end_of_term_ver_id
,b.std_rate_tmpl_ver_id
,nvl(b.residual_tolerance, 0) residual_tolerance
,b.rate_set_id
,b.standard_rate
FROM okl_ls_rt_fctr_sets_v a
,okl_fe_rate_set_versions b
WHERE a.id = b.rate_set_id
AND b.rate_set_version_id = csr_rate_set_version_id;
SELECT a.rate_type_code
,(b.srt_rate+nvl(b.spread,0)) srt_rate
FROM okl_fe_std_rt_tmp_v a
,okl_fe_std_rt_tmp_vers b
WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id
AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id;
SELECT (c.value+nvl(b.spread,0)) value
FROM okl_fe_std_rt_tmp_v a
,okl_fe_std_rt_tmp_vers b
,okl_index_values c
WHERE a.std_rate_tmpl_id = b.std_rate_tmpl_id AND a.index_id = c.idx_id
AND b.std_rate_tmpl_ver_id = csr_std_rate_tmpl_ver_id
AND lrs_eff_from BETWEEN c.datetime_valid AND nvl(c.datetime_invalid, lrs_eff_from + 1);
SELECT a.eot_type_code
FROM okl_fe_eo_terms_v a
,okl_fe_eo_term_vers b
WHERE a.end_of_term_id = b.end_of_term_id
AND b.end_of_term_ver_id = eot_version_id;
SELECT eot_term
,eot_value
FROM okl_fe_eo_term_values a
WHERE a.end_of_term_ver_id = eot_version_id;
SELECT category_type_code
FROM okl_fe_eo_terms_v a
,okl_fe_eo_term_vers b
WHERE a.end_of_term_id = b.end_of_term_id
AND b.end_of_term_ver_id = eot_version_id;
SELECT DISTINCT irsval.term_in_months term_in_months
,irsval.residual_value residual_value
FROM okl_fe_eo_terms_v eoth
,okl_fe_eo_term_vers eotv
,okl_fe_eo_term_objects eoto
,OKL_FE_ITEM_RESIDUAL irsh
,okl_itm_cat_rv_prcs irsv
,okl_fe_item_resdl_values irsval
WHERE eoth.eot_type_code = 'RESIDUAL_PERCENT'
AND eotv.end_of_term_ver_id = eot_version_id
AND eoth.end_of_term_id = eotv.end_of_term_id
AND eotv.end_of_term_ver_id = eoto.end_of_term_ver_id
AND eoth.category_type_code = irsh.category_type_code
AND eoth.category_type_code = 'ITEM'
AND irsh.category_type_code = 'ITEM'
AND irsh.residual_type_code = 'PERCENT'
AND eoto.inventory_item_id = irsh.inventory_item_id
AND eoto.organization_id = irsh.organization_id
AND eoto.category_set_id = irsh.category_set_id
AND irsh.item_residual_id = irsv.item_residual_id
AND irsv.sts_code = 'ACTIVE'
AND p_lrs_effective_from_date BETWEEN irsv.start_date AND nvl(irsv.end_date, to_date('01-01-9999', 'dd-mm-yyyy'))
AND irsv.id = irsval.item_resdl_version_id;
SELECT DISTINCT irsval.term_in_months term_in_months
,irsval.residual_value residual_value
FROM okl_fe_eo_terms_v eoth
,okl_fe_eo_term_vers eotv
,okl_fe_eo_term_objects eoto
,OKL_FE_ITEM_RESIDUAL irsh
,okl_itm_cat_rv_prcs irsv
,okl_fe_item_resdl_values irsval
WHERE eoth.eot_type_code = 'RESIDUAL_PERCENT'
AND eotv.end_of_term_ver_id = eot_version_id
AND eoth.end_of_term_id = eotv.end_of_term_id
AND eoth.category_type_code = 'ITEMCAT'
AND eotv.end_of_term_ver_id = eoto.end_of_term_ver_id
AND eoth.category_type_code = irsh.category_type_code
AND eoto.category_id = irsh.category_id
AND eoto.category_set_id = irsh.category_set_id
AND irsh.category_type_code = 'ITEMCAT'
AND irsh.residual_type_code = 'PERCENT'
AND irsh.item_residual_id = irsv.item_residual_id
AND irsv.sts_code = 'ACTIVE'
AND p_lrs_effective_from_date BETWEEN irsv.start_date AND nvl(irsv.end_date, to_date('01-01-9999', 'dd-mm-yyyy'))
AND irsv.id = irsval.item_resdl_version_id;
SELECT DISTINCT f.term_in_months
,f.residual_value
FROM okl_fe_eo_terms_v a
,okl_fe_eo_term_vers b
,okl_fe_eo_term_objects c
,OKL_FE_ITEM_RESIDUAL d
,okl_itm_cat_rv_prcs e
,okl_fe_item_resdl_values f
WHERE b.end_of_term_ver_id = eot_version_id
AND a.end_of_term_id = b.end_of_term_id
AND b.end_of_term_ver_id = c.end_of_term_ver_id
AND a.category_type_code = d.category_type_code
AND a.category_type_code = 'RESCAT'
AND d.residual_type_code = 'PERCENT'
AND c.resi_category_set_id = d.resi_category_set_id
AND d.item_residual_id = e.item_residual_id
AND e.sts_code = 'ACTIVE'
AND p_lrs_effective_from_date BETWEEN e.start_date AND nvl(e.end_date, p_lrs_effective_from_date + 1)
AND e.id = f.item_resdl_version_id;
okl_lease_rate_factors_pvt.delete_lease_rate_factors(p_api_version => p_api_version
,p_init_msg_list => okl_api.g_false
,x_return_status => lx_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrv_id => p_rate_set_version_id);
fnd_file.put_line(fnd_file.log, 'Inserting into okl_ls_rt_fctr_ents');
SELECT rate_set_version_id
FROM okl_fe_rate_set_versions
WHERE effective_from_date BETWEEN p_start_date AND nvl(p_end_date, to_date('01-01-9999', 'dd-mm-yyyy'))
AND sts_code = 'NEW' AND rate_set_id NOT IN(SELECT id
FROM okl_ls_rt_fctr_sets_v WHERE lrs_type_code = 'MANUAL');