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 840: from okc_k_lines_tl

836: -- This cursor is used to get asset number
837: CURSOR c_asset_info(p_cle_id OKC_K_LINES_B.ID%TYPE)
838: IS
839: select name
840: from okc_k_lines_tl
841: where id = p_cle_id;
842: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
843:
844:

Line 842: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

838: IS
839: select name
840: from okc_k_lines_tl
841: where id = p_cle_id;
842: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
843:
844:
845: --start NISINHA Bug 6490572
846:

Line 1355: okc_k_lines_tl clet_fin

1351: cleb_fin.bill_to_site_use_id,
1352: csu.location bill_to_site_name
1353: FROM okc_k_lines_b cleb_fin,
1354: hz_cust_site_uses_all csu ,
1355: okc_k_lines_tl clet_fin
1356: WHERE cleb_fin.id = p_cle_id
1357: AND csu.site_use_id = cleb_fin.bill_to_site_use_id
1358: AND clet_fin.id = cleb_fin.id
1359: AND clet_fin.language = userenv('LANG');

Line 1535: okc_k_lines_tl clet_fin,

1531: clet_fin.name asset_number,
1532: clet_fin.item_description description,
1533: NVL(kle_fin.oec,0) oec
1534: FROM okc_k_lines_b cleb_fin,
1535: okc_k_lines_tl clet_fin,
1536: okl_k_lines kle_fin,
1537: okc_line_styles_b lse_fin,
1538: okc_statuses_b sts
1539: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1555: okc_k_lines_tl clet_fin,

1551: clet_fin.name asset_number,
1552: clet_fin.item_description description,
1553: NVL(kle_fin.oec,0) oec
1554: FROM okc_k_lines_b cleb_fin,
1555: okc_k_lines_tl clet_fin,
1556: okl_k_lines kle_fin,
1557: okc_line_styles_b lse_fin,
1558: okc_statuses_b sts
1559: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1785: okc_k_lines_tl clet_fin,

1781: NVL(kle_fin.oec,0) oec,
1782: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1783: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1784: FROM okc_k_lines_b cleb_fin,
1785: okc_k_lines_tl clet_fin,
1786: okl_k_lines kle_fin,
1787: okc_line_styles_b lse_fin,
1788: okc_statuses_b sts
1789: WHERE cleb_fin.dnz_chr_id = p_chr_id

Line 1807: okc_k_lines_tl clet_fin,

1803: NVL(kle_fin.oec,0) oec,
1804: NVL(kle_fin.capitalize_down_payment_yn,'Y') capitalize_yn,
1805: NVL(kle_fin.down_payment_receiver_code,'LESSOR') receiver_code
1806: FROM okc_k_lines_b cleb_fin,
1807: okc_k_lines_tl clet_fin,
1808: okl_k_lines kle_fin,
1809: okc_line_styles_b lse_fin,
1810: okc_statuses_b sts
1811: WHERE cleb_fin.dnz_chr_id = p_chr_id