eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 56: (SELECT std_rate_tmpl_ver_id FROM okl_fe_std_rt_tmp_vers WHERE adj_mat_version_id=p_version_id);

52: -- cursor to fetch the maximum start date of lease quotes referencing Standard Rate Template
53: CURSOR srt_lq_csr(p_version_id IN NUMBER) IS
54: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
55: WHERE rate_template_id IN
56: (SELECT std_rate_tmpl_ver_id FROM okl_fe_std_rt_tmp_vers WHERE adj_mat_version_id=p_version_id);
57:
58: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template
59: CURSOR srt_qq_csr(p_version_id IN NUMBER) IS
60: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

Line 62: (SELECT std_rate_tmpl_ver_id from okl_fe_std_rt_tmp_vers where adj_mat_version_id=p_version_id);

58: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template
59: CURSOR srt_qq_csr(p_version_id IN NUMBER) IS
60: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
61: WHERE rate_template_id in
62: (SELECT std_rate_tmpl_ver_id from okl_fe_std_rt_tmp_vers where adj_mat_version_id=p_version_id);
63:
64: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets
65: CURSOR lrs_lq_csr(p_version_id IN NUMBER) IS
66: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

Line 1583: select max(effective_from_date) from okl_fe_std_rt_tmp_vers

1579: WHERE ADJ_MAT_ID = p_adj_mat_id;
1580:
1581:
1582: CURSOR cal_end_date(p_version_id IN NUMBER) IS
1583: select max(effective_from_date) from okl_fe_std_rt_tmp_vers
1584: where adj_mat_version_id=p_version_id;
1585:
1586: l_adj_mat_id NUMBER;
1587: l_adj_mat_ver_id NUMBER;

Line 1873: FROM okl_fe_std_rt_tmp_vers vers, okl_fe_std_rt_tmp_v hdr

1869: -- cursor to calculate the SRT objects which are referncing this adjustment matrix
1870:
1871: CURSOR srt_invalids_csr(p_version_id IN NUMBER) IS
1872: SELECT vers.std_rate_tmpl_ver_id ID,hdr.template_name NAME ,vers.version_number VERSION_NUMBER
1873: FROM okl_fe_std_rt_tmp_vers vers, okl_fe_std_rt_tmp_v hdr
1874: WHERE vers.std_rate_tmpl_id = hdr.std_rate_tmpl_id AND vers.adj_mat_version_id=p_version_id
1875: AND vers.STS_CODE='ACTIVE';
1876:
1877: -- cursor to calculate the LRS objects which are referncing this adjustment matrix