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_B

Line 38: TYPE asset_rec_type IS RECORD (fin_asset_id OKC_K_LINES_B.id%TYPE,

34: -------------------------------------------------------------------------------------------------
35:
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,

Line 66: l_clev_fa_id OKC_K_LINES_B.ID%TYPE;

62: l_talv_fa_rec OKL_TAL_PVT.talv_rec_type;
63: l_itiv_ib_tbl OKL_ITI_PVT.itiv_tbl_type;
64: -- gboomina Added for Bug 5876083 - Start
65: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
66: l_clev_fa_id OKC_K_LINES_B.ID%TYPE;
67: l_asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE;
68: -- gboomina Added for Bug 5876083 - End
69: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
70: x_clev_model_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 103: ,okc_k_lines_b KLE

99: FROM okl_asset_returns_b KAR
100: WHERE KAR.kle_id IN (SELECT KLE.cle_id
101: FROM okl_txl_assets_b TXL
102: ,okl_txd_assets_b TXD
103: ,okc_k_lines_b KLE
104: WHERE TXD.asset_number = p_asset_number
105: AND KLE.id = TXL.kle_id
106: AND TXL.id = TXD.tal_id )
107: AND KAR.ars_code = 'RE_LEASE';

Line 247: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');

243: IF (l_unit_cost IS NULL) THEN
244: OKL_API.set_message(p_app_name => G_APP_NAME,
245: p_msg_name => G_AMOUNT_FORMAT,
246: p_token1 => G_COL_NAME_TOKEN,
247: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: ELSE
250: l_talv_fa_rec.original_cost := l_unit_cost;
251: END IF;

Line 545: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');

541: IF (l_unit_cost IS NULL) THEN
542: OKL_API.set_message(p_app_name => G_APP_NAME,
543: p_msg_name => G_AMOUNT_FORMAT,
544: p_token1 => G_COL_NAME_TOKEN,
545: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
546: RAISE OKL_API.G_EXCEPTION_ERROR;
547: ELSE
548: l_talv_fa_rec.original_cost := l_unit_cost;
549: END IF;

Line 725: FROM okc_k_lines_b cleb_mdl,

721: cim_mdl.object1_id2 inventory_org_id,
722: cim_mdl.number_of_items,
723: cleb_mdl.price_unit,
724: msit.description inventory_item_name
725: FROM okc_k_lines_b cleb_mdl,
726: okc_line_styles_b lse_mdl,
727: okc_k_items cim_mdl,
728: mtl_system_items_tl msit
729: WHERE cim_mdl.cle_id = cleb_mdl.id

Line 756: okc_k_lines_b cleb_fa,

752: cim_fa.object1_id1 asset_id
753: FROM okl_txl_assets_b txl,
754: okc_line_styles_b lse_fa,
755: okl_k_lines kle_fa,
756: okc_k_lines_b cleb_fa,
757: okl_asset_key_lov_uv ast_key,
758: okx_ast_locs_v ast_loc,
759: okc_k_items cim_fa
760: WHERE cleb_fa.id = kle_fa.id

Line 777: FROM okc_k_lines_b cleb_inst,

773: CURSOR c_ib_line(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS
774: SELECT cleb_ib.id clev_ib_id,
775: iti.id,
776: iti.object_id1_new party_site_use_id
777: FROM okc_k_lines_b cleb_inst,
778: okc_k_lines_b cleb_ib,
779: okc_line_styles_b lse_inst,
780: okc_line_styles_b lse_ib,
781: okl_txl_itm_insts iti

Line 778: okc_k_lines_b cleb_ib,

774: SELECT cleb_ib.id clev_ib_id,
775: iti.id,
776: iti.object_id1_new party_site_use_id
777: FROM okc_k_lines_b cleb_inst,
778: okc_k_lines_b cleb_ib,
779: okc_line_styles_b lse_inst,
780: okc_line_styles_b lse_ib,
781: okl_txl_itm_insts iti
782: WHERE cleb_inst.cle_id = p_clev_fin_id

Line 824: okc_k_lines_b cle_ib,

820: hz_party_sites hps,
821: csi_item_instances csi,
822: okc_k_items cim_ib,
823: okc_line_styles_b lse_ib,
824: okc_k_lines_b cle_ib,
825: okc_line_styles_b lse_inst,
826: okc_k_lines_b cle_inst,
827: okc_line_styles_b lse_fin,
828: okc_k_lines_b cle_fin

Line 826: okc_k_lines_b cle_inst,

822: okc_k_items cim_ib,
823: okc_line_styles_b lse_ib,
824: okc_k_lines_b cle_ib,
825: okc_line_styles_b lse_inst,
826: okc_k_lines_b cle_inst,
827: okc_line_styles_b lse_fin,
828: okc_k_lines_b cle_fin
829: where cle_fin.cle_id is null
830: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 828: okc_k_lines_b cle_fin

824: okc_k_lines_b cle_ib,
825: okc_line_styles_b lse_inst,
826: okc_k_lines_b cle_inst,
827: okc_line_styles_b lse_fin,
828: okc_k_lines_b cle_fin
829: where cle_fin.cle_id is null
830: and cle_fin.chr_id = cle_fin.dnz_chr_id
831: and lse_fin.id = cle_fin.lse_id
832: and lse_fin.lty_code = 'FREE_FORM1'

Line 886: CURSOR c_asset_info(p_cle_id OKC_K_LINES_B.ID%TYPE)

882: and fa_hist.retirement_id is null;
883: l_fa_line_active_rec c_fa_line_active%ROWTYPE;
884:
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;

Line 898: CURSOR c_fa_line_loan(p_clev_fin_id IN okc_k_lines_b.id%type,

894: --start NISINHA Bug 6490572
895:
896: -- cursor to get Model Number and Manufacturer from OKL_K_LINES for loan contracts
897:
898: CURSOR c_fa_line_loan(p_clev_fin_id IN okc_k_lines_b.id%type,
899: p_dnz_chr_id IN okc_k_headers_all_b.id%type) IS
900: SELECT kle_fa.model_number,
901: kle_fa.year_built,
902: kle_fa.manufacturer_name

Line 905: okc_k_lines_b cleb_fa

901: kle_fa.year_built,
902: kle_fa.manufacturer_name
903: FROM okc_line_styles_b lse_fa,
904: okl_k_lines kle_fa,
905: okc_k_lines_b cleb_fa
906: WHERE cleb_fa.id = kle_fa.id
907: AND lse_fa.id = cleb_fa.lse_id
908: AND lse_fa.lty_code = 'FIXED_ASSET'
909: AND cleb_fa.cle_id = p_clev_fin_id

Line 1415: FROM okc_k_lines_b cleb_fin,

1411: SELECT clet_fin.name asset_number,
1412: clet_fin.item_description,
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

Line 1596: FROM okc_k_lines_b cleb_fin,

1592: SELECT cleb_fin.id fin_asset_id,
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

Line 1617: FROM okc_k_lines_b cleb_fin,

1613: SELECT cleb_fin.id fin_asset_id,
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

Line 1636: FROM okc_k_lines_b cleb_fin,

1632: AND NVL(kle_fin.re_lease_yn,'N') = 'N'; --ndani - 01-Apr-2013, Bug# 16567807, Adjustments should not be allowed for re-lease assets
1633:
1634: CURSOR c_term_fin_lines(p_chr_id IN NUMBER) is
1635: SELECT SUM(NVL(kle_fin.tradein_amount,0)) amount
1636: FROM okc_k_lines_b cleb_fin,
1637: okl_k_lines kle_fin,
1638: okc_line_styles_b lse_fin
1639: WHERE cleb_fin.dnz_chr_id = p_chr_id
1640: AND cleb_fin.chr_id = p_chr_id

Line 1848: FROM okc_k_lines_b cleb_fin,

1844: clet_fin.item_description description,
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

Line 1871: FROM okc_k_lines_b cleb_fin,

1867: clet_fin.item_description description,
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

Line 1892: FROM okc_k_lines_b cleb_fin,

1888:
1889: CURSOR c_term_fin_lines(p_chr_id IN NUMBER) is
1890: SELECT SUM( NVL(kle_fin.capital_reduction,0) +
1891: (NVL(kle_fin.capital_reduction_percent,0)/100 * kle_fin.oec)) amount
1892: FROM okc_k_lines_b cleb_fin,
1893: okl_k_lines kle_fin,
1894: okc_line_styles_b lse_fin
1895: WHERE cleb_fin.dnz_chr_id = p_chr_id
1896: AND cleb_fin.chr_id = p_chr_id

Line 2106: okc_k_lines_b cleb_sub

2102: IS
2103: CURSOR c_subsidy_amount(p_khr_id NUMBER, p_subsidy_id NUMBER) IS
2104: SELECT OKL_ACCOUNTING_UTIL.format_amount(SUM(NVL(kle_sub.subsidy_override_amount,kle_sub.amount)), cleb_sub.currency_code) subsidy_amount
2105: FROM okl_k_lines kle_sub,
2106: okc_k_lines_b cleb_sub
2107: WHERE kle_sub.subsidy_id = p_subsidy_id
2108: AND cleb_sub.dnz_chr_id = p_khr_id
2109: AND cleb_sub.id = kle_sub.id
2110: AND cleb_sub.sts_code <> 'ABANDONED'

Line 2130: okc_k_lines_b cleb_fin

2126: IS
2127: CURSOR c_down_payment_amount(p_khr_id NUMBER) IS
2128: SELECT OKL_ACCOUNTING_UTIL.format_amount(SUM( NVL(kle_fin.capital_reduction,0) + (NVL(kle_fin.capital_reduction_percent,0)/100 * kle_fin.oec) ), cleb_fin.currency_code) down_payment_amount
2129: FROM okl_k_lines kle_fin,
2130: okc_k_lines_b cleb_fin
2131: WHERE cleb_fin.chr_id = p_khr_id
2132: AND cleb_fin.dnz_chr_id = p_khr_id
2133: AND kle_fin.id = cleb_fin.id
2134: AND (kle_fin.capital_reduction_percent IS NOT NULL OR