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.OKS_CONTRACTS_PUB dependencies on OKC_K_LINES_B

Line 654: FROM okc_k_lines_b

650: IS
651:
652: CURSOR l_line_csr(p_cle_id NUMBER) IS
653: SELECT dnz_chr_id, start_date
654: FROM okc_k_lines_b
655: WHERE id = p_cle_id;
656:
657: l_line_rec l_line_csr%ROWTYPE;
658:

Line 3370: From okc_k_lines_b

3366: Is
3367: max_line_number Number;
3368: Cursor get_line_number Is
3369: Select NVL(Max(TO_NUMBER(line_number)),0) +1
3370: From okc_k_lines_b
3371: Where dnz_chr_id = p_chr_id
3372: And lse_id in (1,12,14,19,46);
3373:
3374: Begin

Line 3394: From okc_k_lines_b

3390: Is
3391: max_line_number Number;
3392: Cursor get_line_number Is
3393: Select NVL(Max(TO_NUMBER(line_number)),0) +1
3394: From okc_k_lines_b
3395: Where dnz_chr_id = p_chr_id
3396: And cle_id = p_cle_id
3397: And lse_id in (35,7,8,9,10,11,13,18,25);
3398:

Line 4623: FROM okc_k_lines_b

4619: l_mtl_rec l_mtl_csr%rowtype;
4620:
4621: CURSOR l_parent_line_csr (p_line_id Number) IS
4622: SELECT id, lse_id
4623: FROM okc_k_lines_b
4624: WHERE id = p_line_id;
4625: /*
4626: CURSOR l_usage_type_csr(p_line_id NUMBER) IS
4627: SELECT rule_information10

Line 6150: from Okc_k_lines_b

6146: End If;
6147:
6148: Update Okc_k_headers_b
6149: Set Estimated_amount = (Select nvl(sum(nvl(price_negotiated,0)),0)
6150: from Okc_k_lines_b
6151: Where dnz_chr_id = l_contract_header_id
6152: and lse_id in (9,25,46))
6153: Where id = l_contract_header_id ;
6154: