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_PRICING_PVT dependencies on OKL_K_LINES_FULL_V

Line 1467: FROM okl_k_lines_full_v kle,

1463: CURSOR l_terminated_line_csr is
1464: SELECT kle.ID,
1465: sts.STE_CODE,
1466: trunc(nvl(kle.DATE_TERMINATED, sysdate)) date_terminated
1467: FROM okl_k_lines_full_v kle,
1468: okc_statuses_b sts
1469: WHERE kle.id = p_kle_id
1470: and kle.dnz_chr_id = p_khr_id
1471: and sts.code = kle.sts_code

Line 4622: from okl_k_lines_full_v kle,

4618: CURSOR top_svc_csr ( chrId NUMBER, linkId NUMBER ) IS
4619: select to_char(kle1.id) top_svc_id,
4620: kle1.amount top_amount,
4621: kle.amount link_amount
4622: from okl_k_lines_full_v kle,
4623: okl_k_lines_full_v kle1,
4624: okc_line_styles_b lse,
4625: okc_statuses_b sts
4626: where KLE1.LSE_ID = LSE.ID

Line 4623: okl_k_lines_full_v kle1,

4619: select to_char(kle1.id) top_svc_id,
4620: kle1.amount top_amount,
4621: kle.amount link_amount
4622: from okl_k_lines_full_v kle,
4623: okl_k_lines_full_v kle1,
4624: okc_line_styles_b lse,
4625: okc_statuses_b sts
4626: where KLE1.LSE_ID = LSE.ID
4627: and ((lse.lty_code = 'SOLD_SERVICE') OR (lse.lty_code = 'FEE'and kle1.fee_type ='PASSTHROUGH'))

Line 5884: from okl_k_lines_full_v kle,

5880:
5881: CURSOR c_kle IS
5882: select kle.id,
5883: kle.start_date
5884: from okl_k_lines_full_v kle,
5885: okc_statuses_b sts
5886: where kle.dnz_chr_id = p_khr_id
5887: and kle.id = p_kle_id
5888: and sts.code = kle.sts_code

Line 7185: from okl_k_lines_full_v kle,

7181: Select 'Y'
7182: From dual
7183: where Exists(
7184: select kle.id
7185: from okl_k_lines_full_v kle,
7186: okc_line_styles_b lse,
7187: okc_statuses_b sts
7188: where KLE.LSE_ID = LSE.ID
7189: and lse.lty_code = 'SUBSIDY'

Line 9731: from okl_k_lines_full_v kle,

9727: Select 'Y'
9728: From dual
9729: where Exists(
9730: select kle.id
9731: from okl_k_lines_full_v kle,
9732: okc_line_styles_b lse,
9733: okc_statuses_b sts
9734: where KLE.LSE_ID = LSE.ID
9735: and lse.lty_code = 'SUBSIDY'