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_GENERATE_ACCRUALS_PVT dependencies on OKC_K_ITEMS

Line 236: SELECT 'x' FROM okc_k_items cim

232: SELECT 'Y' FROM okc_k_headers_b chr
233: WHERE id = p_contract_id
234: AND EXISTS
235: (
236: SELECT 'x' FROM okc_k_items cim
237: WHERE cim.object1_id1 = to_char(chr.id)
238: AND EXISTS
239: (
240: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

Line 1400: okc_k_items ite,

1396: FROM okc_k_lines_b kle_fa,
1397: okc_line_styles_b lse_fa,
1398: okc_k_lines_b kle_ml,
1399: okc_line_styles_b lse_ml,
1400: okc_k_items ite,
1401: okl_k_headers_full_v khr
1402: WHERE kle_fa.id = cp_cle_id
1403: AND kle_fa.chr_id = cp_chr_id
1404: AND lse_fa.id = kle_fa.lse_id

Line 1432: FROM okc_k_items

1428:
1429: -- cursor to get parent kle_id
1430: CURSOR get_parent_kle_id_csr (p_kle_id NUMBER) IS
1431: SELECT object1_id1
1432: FROM okc_k_items
1433: WHERE cle_id = p_kle_id;
1434:
1435: --Added by kthiruva on 14-May-2007
1436: --cursor to fetch the contract dff information for SLA Uptake