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_LINE_STYLES_B

Line 684: okc_line_styles_b lse_mdl,

680: cim_mdl.number_of_items,
681: cleb_mdl.price_unit,
682: msit.description inventory_item_name
683: FROM okc_k_lines_b cleb_mdl,
684: okc_line_styles_b lse_mdl,
685: okc_k_items cim_mdl,
686: mtl_system_items_tl msit
687: WHERE cim_mdl.cle_id = cleb_mdl.id
688: AND cim_mdl.dnz_chr_id = cleb_mdl.dnz_chr_id

Line 712: okc_line_styles_b lse_fa,

708: txl.asset_key_id,
709: ast_key.concatenated_segments asset_key_name,
710: cim_fa.object1_id1 asset_id
711: FROM okl_txl_assets_b txl,
712: okc_line_styles_b lse_fa,
713: okl_k_lines kle_fa,
714: okc_k_lines_b cleb_fa,
715: okl_asset_key_lov_uv ast_key,
716: okx_ast_locs_v ast_loc,

Line 737: okc_line_styles_b lse_inst,

733: iti.id,
734: iti.object_id1_new party_site_use_id
735: FROM okc_k_lines_b cleb_inst,
736: okc_k_lines_b cleb_ib,
737: okc_line_styles_b lse_inst,
738: okc_line_styles_b lse_ib,
739: okl_txl_itm_insts iti
740: WHERE cleb_inst.cle_id = p_clev_fin_id
741: AND cleb_inst.dnz_chr_id = p_dnz_chr_id

Line 738: okc_line_styles_b lse_ib,

734: iti.object_id1_new party_site_use_id
735: FROM okc_k_lines_b cleb_inst,
736: okc_k_lines_b cleb_ib,
737: okc_line_styles_b lse_inst,
738: okc_line_styles_b lse_ib,
739: okl_txl_itm_insts iti
740: WHERE cleb_inst.cle_id = p_clev_fin_id
741: AND cleb_inst.dnz_chr_id = p_dnz_chr_id
742: AND cleb_inst.lse_id = lse_inst.id

Line 777: okc_line_styles_b lse_ib,

773: from hz_locations hl,
774: hz_party_sites hps,
775: csi_item_instances csi,
776: okc_k_items cim_ib,
777: okc_line_styles_b lse_ib,
778: okc_k_lines_b cle_ib,
779: okc_line_styles_b lse_inst,
780: okc_k_lines_b cle_inst,
781: okc_line_styles_b lse_fin,

Line 779: okc_line_styles_b lse_inst,

775: csi_item_instances csi,
776: okc_k_items cim_ib,
777: okc_line_styles_b lse_ib,
778: okc_k_lines_b cle_ib,
779: okc_line_styles_b lse_inst,
780: okc_k_lines_b cle_inst,
781: okc_line_styles_b lse_fin,
782: okc_k_lines_b cle_fin
783: where cle_fin.cle_id is null

Line 781: okc_line_styles_b lse_fin,

777: okc_line_styles_b lse_ib,
778: okc_k_lines_b cle_ib,
779: okc_line_styles_b lse_inst,
780: okc_k_lines_b cle_inst,
781: okc_line_styles_b lse_fin,
782: okc_k_lines_b cle_fin
783: where cle_fin.cle_id is null
784: and cle_fin.chr_id = cle_fin.dnz_chr_id
785: and lse_fin.id = cle_fin.lse_id

Line 854: FROM okc_line_styles_b lse_fa,

850: p_dnz_chr_id IN okc_k_headers_all_b.id%type) IS
851: SELECT kle_fa.model_number,
852: kle_fa.year_built,
853: kle_fa.manufacturer_name
854: FROM okc_line_styles_b lse_fa,
855: okl_k_lines kle_fa,
856: okc_k_lines_b cleb_fa
857: WHERE cleb_fa.id = kle_fa.id
858: AND lse_fa.id = cleb_fa.lse_id

Line 1537: okc_line_styles_b lse_fin,

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
1540: AND cleb_fin.chr_id = p_chr_id
1541: AND clet_fin.id = cleb_fin.id

Line 1557: okc_line_styles_b lse_fin,

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
1560: AND cleb_fin.chr_id = p_chr_id
1561: AND clet_fin.id = cleb_fin.id

Line 1574: okc_line_styles_b lse_fin

1570: CURSOR c_term_fin_lines(p_chr_id IN NUMBER) is
1571: SELECT SUM(NVL(kle_fin.tradein_amount,0)) amount
1572: FROM okc_k_lines_b cleb_fin,
1573: okl_k_lines kle_fin,
1574: okc_line_styles_b lse_fin
1575: WHERE cleb_fin.dnz_chr_id = p_chr_id
1576: AND cleb_fin.chr_id = p_chr_id
1577: AND cleb_fin.sts_code = 'TERMINATED'
1578: AND kle_fin.id = cleb_fin.id

Line 1787: okc_line_styles_b lse_fin,

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
1790: AND cleb_fin.chr_id = p_chr_id
1791: AND clet_fin.id = cleb_fin.id

Line 1809: okc_line_styles_b lse_fin,

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
1812: AND cleb_fin.chr_id = p_chr_id
1813: AND clet_fin.id = cleb_fin.id

Line 1828: okc_line_styles_b lse_fin

1824: SELECT SUM( NVL(kle_fin.capital_reduction,0) +
1825: (NVL(kle_fin.capital_reduction_percent,0)/100 * kle_fin.oec)) amount
1826: FROM okc_k_lines_b cleb_fin,
1827: okl_k_lines kle_fin,
1828: okc_line_styles_b lse_fin
1829: WHERE cleb_fin.dnz_chr_id = p_chr_id
1830: AND cleb_fin.chr_id = p_chr_id
1831: AND cleb_fin.sts_code = 'TERMINATED'
1832: AND kle_fin.id = cleb_fin.id