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_LINE_STYLES_B

Line 59: OKC_LINE_STYLES_B LSE,

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
62: cle.lse_id = lse.id
63: and lse.lty_code = 'USAGE'

Line 294: l_lty_code okc_line_styles_b.lty_code%type;

290:
291: l_chr_id okl_k_headers.id%type;
292: l_parent_cle_id okl_k_lines.id%type;
293: l_cle_id okl_k_lines.id%type;
294: l_lty_code okc_line_styles_b.lty_code%type;
295: l_id okl_k_lines.id%type;
296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Link_Asset';
298: l_api_version CONSTANT NUMBER := 1.0;

Line 314: FROM okc_line_styles_b lse,

310: -- Cursor to fetch the lty_code
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;

Line 1105: l_lse_id okc_line_styles_b.id%type := null;

1101: l_cnt number := 0;
1102:
1103: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1104: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1105: l_lse_id okc_line_styles_b.id%type := null;
1106: l_lty_code okc_line_styles_b.lty_code%type := null;
1107: l_item_id1 okc_k_items.object1_id1%type := null;
1108: l_item_id2 okc_k_items.object1_id2%type := null;
1109: l_amount number := null;

Line 1106: l_lty_code okc_line_styles_b.lty_code%type := null;

1102:
1103: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1104: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1105: l_lse_id okc_line_styles_b.id%type := null;
1106: l_lty_code okc_line_styles_b.lty_code%type := null;
1107: l_item_id1 okc_k_items.object1_id1%type := null;
1108: l_item_id2 okc_k_items.object1_id2%type := null;
1109: l_amount number := null;
1110:

Line 1137: from okc_line_styles_b lse

1133: where chr.id = p_chr_id;
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;

Line 1588: l_lse_id okc_line_styles_b.id%type := null;

1584: l_amount number := null;
1585:
1586: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1587: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1588: l_lse_id okc_line_styles_b.id%type := null;
1589: l_lty_code okc_line_styles_b.lty_code%type := null;
1590: l_item_id1 okc_k_items.object1_id1%type := null;
1591: l_item_id2 okc_k_items.object1_id2%type := null;
1592:

Line 1589: l_lty_code okc_line_styles_b.lty_code%type := null;

1585:
1586: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1587: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1588: l_lse_id okc_line_styles_b.id%type := null;
1589: l_lty_code okc_line_styles_b.lty_code%type := null;
1590: l_item_id1 okc_k_items.object1_id1%type := null;
1591: l_item_id2 okc_k_items.object1_id2%type := null;
1592:
1593: CURSOR get_link_fee_asset_csr(p_chr_id number, p_cle_id number, p_name varchar2) IS

Line 1619: from okc_line_styles_b lse

1615: where chr.id = p_chr_id;
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;

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 2921: l_lty_code okc_line_styles_b.lty_code%TYPE;

2917: WHERE id = p_serv_top_line_id;
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;

Line 2948: okc_line_styles_b lnk_fee_lseb,

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
2952: and lnk_fee_cleb.id = p_cle_id