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 726: okc_line_styles_b lse_mdl,

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
730: AND cim_mdl.dnz_chr_id = cleb_mdl.dnz_chr_id

Line 754: okc_line_styles_b lse_fa,

750: txl.asset_key_id,
751: ast_key.concatenated_segments asset_key_name,
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,

Line 779: okc_line_styles_b lse_inst,

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
783: AND cleb_inst.dnz_chr_id = p_dnz_chr_id

Line 780: okc_line_styles_b lse_ib,

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
783: AND cleb_inst.dnz_chr_id = p_dnz_chr_id
784: AND cleb_inst.lse_id = lse_inst.id

Line 823: okc_line_styles_b lse_ib,

819: from hz_locations hl,
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,

Line 825: okc_line_styles_b lse_inst,

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
829: where cle_fin.cle_id is null

Line 827: okc_line_styles_b lse_fin,

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
831: and lse_fin.id = cle_fin.lse_id

Line 903: FROM okc_line_styles_b lse_fa,

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
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

Line 1599: okc_line_styles_b lse_fin,

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

Line 1620: okc_line_styles_b lse_fin,

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

Line 1638: okc_line_styles_b lse_fin

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
1641: AND cleb_fin.sts_code = 'TERMINATED'
1642: AND kle_fin.id = cleb_fin.id

Line 1851: okc_line_styles_b lse_fin,

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

Line 1874: okc_line_styles_b lse_fin,

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

Line 1894: okc_line_styles_b lse_fin

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
1897: AND cleb_fin.sts_code = 'TERMINATED'
1898: AND kle_fin.id = cleb_fin.id