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_CONTRACT_LINE_ITEM_PVT dependencies on OKC_K_LINES_B

Line 57: from OKC_K_LINES_B CLE,

53: select cle.id ID1,
54: '#' ID2,
55: tl.name NAME,
56: tl.item_description DESCRIPTION
57: from OKC_K_LINES_B CLE,
58: OKC_K_LINES_TL TL,
59: OKC_LINE_STYLES_B LSE,
60: OKC_K_HEADERS_B CHR
61: where

Line 315: okc_k_lines_b cle

311: CURSOR get_lty_code_csr(p_chr_id NUMBER,
312: p_cle_id NUMBER) IS
313: SELECT lty_code
314: FROM okc_line_styles_b lse,
315: okc_k_lines_b cle
316: WHERE lse.lse_parent_id = cle.lse_id
317: AND cle.id = p_cle_id
318: AND cle.chr_id = p_chr_id;
319:

Line 1138: , okc_k_lines_b cle

1134:
1135: CURSOR get_lse_id_csr(p_chr_id number, p_cle_id number) IS
1136: select lse.id,lse.lty_code
1137: from okc_line_styles_b lse
1138: , okc_k_lines_b cle
1139: where lse.lse_parent_id = cle.lse_id
1140: and cle.id = p_cle_id
1141: and cle.dnz_chr_id = p_chr_id;
1142:

Line 1620: , okc_k_lines_b cle

1616:
1617: CURSOR get_lse_id_csr(p_chr_id number, p_cle_id number) IS
1618: select lse.id,lse.lty_code
1619: from okc_line_styles_b lse
1620: , okc_k_lines_b cle
1621: where lse.lse_parent_id = cle.lse_id
1622: and cle.id = p_cle_id
1623: and cle.dnz_chr_id = p_chr_id;
1624:

Line 2156: from okc_k_lines_b chr

2152: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2153:
2154: CURSOR get_k_dates_csr(l_id NUMBER) IS
2155: select chr.start_date, chr.end_date
2156: from okc_k_lines_b chr
2157: where id = l_id;
2158:
2159: l_start_date okc_k_lines_b.start_date%type := null;
2160: l_end_date okc_k_lines_b.end_date%type := null;

Line 2159: l_start_date okc_k_lines_b.start_date%type := null;

2155: select chr.start_date, chr.end_date
2156: from okc_k_lines_b chr
2157: where id = l_id;
2158:
2159: l_start_date okc_k_lines_b.start_date%type := null;
2160: l_end_date okc_k_lines_b.end_date%type := null;
2161: l_amount number;
2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:

Line 2160: l_end_date okc_k_lines_b.end_date%type := null;

2156: from okc_k_lines_b chr
2157: where id = l_id;
2158:
2159: l_start_date okc_k_lines_b.start_date%type := null;
2160: l_end_date okc_k_lines_b.end_date%type := null;
2161: l_amount number;
2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:
2164: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS

Line 2511: from okc_k_lines_b chr

2507: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2508:
2509: CURSOR get_k_dates_csr(l_id NUMBER) IS
2510: select chr.start_date, chr.end_date
2511: from okc_k_lines_b chr
2512: where id = l_id;
2513:
2514: l_fee_type okl_k_lines.fee_type%type := null;
2515: l_amount NUMBER := null;

Line 2516: l_start_date okc_k_lines_b.start_date%type := null;

2512: where id = l_id;
2513:
2514: l_fee_type okl_k_lines.fee_type%type := null;
2515: l_amount NUMBER := null;
2516: l_start_date okc_k_lines_b.start_date%type := null;
2517: l_end_date okc_k_lines_b.end_date%type := null;
2518:
2519: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2520: select cle.fee_type

Line 2517: l_end_date okc_k_lines_b.end_date%type := null;

2513:
2514: l_fee_type okl_k_lines.fee_type%type := null;
2515: l_amount NUMBER := null;
2516: l_start_date okc_k_lines_b.start_date%type := null;
2517: l_end_date okc_k_lines_b.end_date%type := null;
2518:
2519: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2520: select cle.fee_type
2521: from okl_k_lines_full_v cle

Line 2528: FROM okc_k_lines_b cle

2524:
2525: -- Bug# 6598350
2526: CURSOR c_orig_cle_csr(p_cle_id IN NUMBER) IS
2527: SELECT cle.start_date
2528: FROM okc_k_lines_b cle
2529: WHERE cle.id = p_cle_id;
2530:
2531: l_orig_cle_rec c_orig_cle_csr%ROWTYPE;
2532: BEGIN

Line 2896: CURSOR lty_code_csr(p_id okc_k_lines_b.id%TYPE) IS

2892: -- vthiruva, 09/01/2004
2893: -- START, Code change to enable Business Event
2894: */
2895: --cursor to fetch the line style code for line style id of the record.
2896: CURSOR lty_code_csr(p_id okc_k_lines_b.id%TYPE) IS
2897: SELECT lse.lty_code lty_code, items.object1_id1 asset_id
2898: FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items
2899: WHERE lines.id = p_id
2900: AND lse.id = lines.lse_id

Line 2898: FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items

2894: */
2895: --cursor to fetch the line style code for line style id of the record.
2896: CURSOR lty_code_csr(p_id okc_k_lines_b.id%TYPE) IS
2897: SELECT lse.lty_code lty_code, items.object1_id1 asset_id
2898: FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items
2899: WHERE lines.id = p_id
2900: AND lse.id = lines.lse_id
2901: AND items.cle_id = lines.id;
2902:

Line 2904: p_line_id okc_k_lines_b.id%TYPE) IS

2900: AND lse.id = lines.lse_id
2901: AND items.cle_id = lines.id;
2902:
2903: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
2904: p_line_id okc_k_lines_b.id%TYPE) IS
2905: SELECT rlobj.object1_id1
2906: FROM okc_k_rel_objs_v rlobj
2907: WHERE rlobj.chr_id = p_chr_id
2908: AND rlobj.cle_id = p_line_id

Line 2912: l_service_top_line_id okc_k_lines_b.id%TYPE;

2908: AND rlobj.cle_id = p_line_id
2909: AND rlobj.rty_code = 'OKLSRV'
2910: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
2911:
2912: l_service_top_line_id okc_k_lines_b.id%TYPE;
2913:
2914: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
2915: SELECT dnz_chr_id
2916: FROM okc_k_lines_b

Line 2914: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS

2910: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
2911:
2912: l_service_top_line_id okc_k_lines_b.id%TYPE;
2913:
2914: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
2915: SELECT dnz_chr_id
2916: FROM okc_k_lines_b
2917: WHERE id = p_serv_top_line_id;
2918:

Line 2916: FROM okc_k_lines_b

2912: l_service_top_line_id okc_k_lines_b.id%TYPE;
2913:
2914: CURSOR get_serv_cle_from_serv (p_serv_top_line_id okc_k_lines_b.id%TYPE) IS
2915: SELECT dnz_chr_id
2916: FROM okc_k_lines_b
2917: WHERE id = p_serv_top_line_id;
2918:
2919: l_serv_contract_id okc_k_headers_b.id%TYPE;
2920:

Line 2922: l_asset_id okc_k_lines_b.id%TYPE;

2918:
2919: l_serv_contract_id okc_k_headers_b.id%TYPE;
2920:
2921: l_lty_code okc_line_styles_b.lty_code%TYPE;
2922: l_asset_id okc_k_lines_b.id%TYPE;
2923: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
2924: l_business_event_name WF_EVENTS.NAME%TYPE;
2925: l_parameter_list WF_PARAMETER_LIST_T;
2926:

Line 2947: okc_k_lines_b lnk_fee_cleb,

2943: p_cim_id in number) is
2944: select cim.object1_id1,
2945: cim.dnz_chr_id
2946: from okc_k_items cim,
2947: okc_k_lines_b lnk_fee_cleb,
2948: okc_line_styles_b lnk_fee_lseb,
2949: okc_k_lines_b fee_cleb,
2950: okl_k_lines fee_kle
2951: where cim.id = p_cim_id

Line 2949: okc_k_lines_b fee_cleb,

2945: cim.dnz_chr_id
2946: from okc_k_items cim,
2947: okc_k_lines_b lnk_fee_cleb,
2948: okc_line_styles_b lnk_fee_lseb,
2949: okc_k_lines_b fee_cleb,
2950: okl_k_lines fee_kle
2951: where cim.id = p_cim_id
2952: and lnk_fee_cleb.id = p_cle_id
2953: and cim.dnz_chr_id = lnk_fee_cleb.dnz_chr_id

Line 2974: from okc_k_lines_b cleb,

2970: --Bug# 4899328
2971: --cursor to check if contract is a rebook copy contract
2972: Cursor l_rbk_asst_csr(p_cle_id IN NUMBER) is
2973: Select 'Y' rbk_asst_flag
2974: from okc_k_lines_b cleb,
2975: okc_k_headers_b chrb
2976: where chrb.id = cleb.dnz_chr_id
2977: and chrb.scs_code = 'LEASE'
2978: and chrb.orig_system_source_code = 'OKL_REBOOK'

Line 2983: okc_k_lines_b orig_cleb

2979: and cleb.id = p_cle_id
2980: and cleb.orig_system_id1 is not NULL
2981: and exists (select '1'
2982: from okc_k_headers_b orig_chrb,
2983: okc_k_lines_b orig_cleb
2984: where orig_chrb.id = chrb.orig_system_id1
2985: and orig_cleb.id = cleb.orig_system_id1
2986: and orig_cleb.sts_code <> 'ABANDONED'
2987: and orig_cleb.dnz_chr_id = orig_chrb.id);