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_DEAL_ASSET_PVT dependencies on OKC_K_LINES_TL

Line 40: asset_number OKC_K_LINES_TL.name%TYPE,

36: TYPE fin_line_tab_type IS TABLE OF NUMBER;
37:
38: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
39: amount OKL_K_LINES.tradein_amount%TYPE,
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
44: receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE);

Line 41: description OKC_K_LINES_TL.item_description%TYPE,

37:
38: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,
39: amount OKL_K_LINES.tradein_amount%TYPE,
40: asset_number OKC_K_LINES_TL.name%TYPE,
41: description OKC_K_LINES_TL.item_description%TYPE,
42: oec OKL_K_LINES.oec%TYPE,
43: capitalize_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE,
44: receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE);
45:

Line 889: from okc_k_lines_tl

885: -- This cursor is used to get asset number
886: CURSOR c_asset_info(p_cle_id OKC_K_LINES_B.ID%TYPE)
887: IS
888: select name
889: from okc_k_lines_tl
890: where id = p_cle_id;
891: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
892:
893:

Line 891: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

887: IS
888: select name
889: from okc_k_lines_tl
890: where id = p_cle_id;
891: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
892:
893:
894: --start NISINHA Bug 6490572
895:

Line 1417: okc_k_lines_tl clet_fin

1413: cleb_fin.bill_to_site_use_id,
1414: csu.location bill_to_site_name
1415: FROM okc_k_lines_b cleb_fin,
1416: hz_cust_site_uses_all csu ,
1417: okc_k_lines_tl clet_fin
1418: WHERE cleb_fin.id = p_cle_id
1419: AND csu.site_use_id = cleb_fin.bill_to_site_use_id
1420: AND clet_fin.id = cleb_fin.id
1421: AND clet_fin.language = userenv('LANG');

Line 1597: okc_k_lines_tl clet_fin,

1593: clet_fin.name asset_number,
1594: clet_fin.item_description description,
1595: NVL(kle_fin.oec,0) oec
1596: FROM okc_k_lines_b cleb_fin,
1597: okc_k_lines_tl clet_fin,
1598: okl_k_lines kle_fin,
1599: okc_line_styles_b lse_fin,
1600: okc_statuses_b sts
1601: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1618: okc_k_lines_tl clet_fin,

1614: clet_fin.name asset_number,
1615: clet_fin.item_description description,
1616: NVL(kle_fin.oec,0) oec
1617: FROM okc_k_lines_b cleb_fin,
1618: okc_k_lines_tl clet_fin,
1619: okl_k_lines kle_fin,
1620: okc_line_styles_b lse_fin,
1621: okc_statuses_b sts
1622: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1849: okc_k_lines_tl clet_fin,

1845: NVL(kle_fin.oec,0) oec,
1846: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1847: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1848: FROM okc_k_lines_b cleb_fin,
1849: okc_k_lines_tl clet_fin,
1850: okl_k_lines kle_fin,
1851: okc_line_styles_b lse_fin,
1852: okc_statuses_b sts
1853: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1872: okc_k_lines_tl clet_fin,

1868: NVL(kle_fin.oec,0) oec,
1869: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1870: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1871: FROM okc_k_lines_b cleb_fin,
1872: okc_k_lines_tl clet_fin,
1873: okl_k_lines kle_fin,
1874: okc_line_styles_b lse_fin,
1875: okc_statuses_b sts
1876: WHERE cleb_fin.dnz_chr_id = p_chr_id