[Home] [Help]
53: chrb.scs_code, -- rmunjulu 4622198
54: chrb.org_id --added by akrangan to get the org_id of the contract
55: FROM okc_k_headers_b chrb,
56: okl_k_headers khr,
57: okc_k_lines_b okc
58: WHERE okc.id = p_kle_id
59: AND khr.id = chrb.id
60: AND okc.chr_id = chrb.id;
61: --akrangan sla cr start
1793: --Changed query to use base tables instead uv for performance
1794: CURSOR l_itemlocation_csr IS
1795: SELECT cii.instance_id instance_id, cii.active_end_date instance_end_date
1796: FROM okc_k_headers_b okhv,
1797: okc_k_lines_b kle_fa,
1798: okc_k_lines_tl klet_fa,
1799: okc_line_styles_b lse_fa,
1800: okc_k_lines_b kle_il,
1801: okc_line_styles_b lse_il,
1796: FROM okc_k_headers_b okhv,
1797: okc_k_lines_b kle_fa,
1798: okc_k_lines_tl klet_fa,
1799: okc_line_styles_b lse_fa,
1800: okc_k_lines_b kle_il,
1801: okc_line_styles_b lse_il,
1802: okc_k_lines_b kle_ib,
1803: okc_line_styles_b lse_ib,
1804: okc_k_items ite,
1798: okc_k_lines_tl klet_fa,
1799: okc_line_styles_b lse_fa,
1800: okc_k_lines_b kle_il,
1801: okc_line_styles_b lse_il,
1802: okc_k_lines_b kle_ib,
1803: okc_line_styles_b lse_ib,
1804: okc_k_items ite,
1805: csi_item_instances cii
1806: WHERE kle_fa.id = klet_fa.id
1838:
1839: -- validate the financial asset id
1840: CURSOR l_okclines_csr(p_financial_asset_id IN NUMBER) IS
1841: SELECT 'x'
1842: FROM okc_k_lines_b cle, okc_line_styles_b lse
1843: WHERE cle.lse_id = lse.id
1844: AND lse.lty_code = 'FREE_FORM1'
1845: AND cle.id = p_financial_asset_id;
1846:
1846:
1847: -- get the deal type from the contract
1848: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
1849: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
1850: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
1851: WHERE khr.id = cle.chr_id
1852: AND lkhr.id = khr.id
1853: AND cle.id = p_financial_asset_id;
1854:
3530: cim.number_of_items quantity,
3531: -- RRAVIKIR Legal Entity changes
3532: oar.legal_entity_id
3533: -- Legal Entity changes End
3534: FROM okc_k_lines_b kle,
3535: okc_k_headers_all_b okc,
3536: okl_asset_returns_all_b oar,
3537: mtl_system_items_b msi,
3538: okc_k_lines_b kle2,
3534: FROM okc_k_lines_b kle,
3535: okc_k_headers_all_b okc,
3536: okl_asset_returns_all_b oar,
3537: mtl_system_items_b msi,
3538: okc_k_lines_b kle2,
3539: okc_line_styles_b lse,
3540: okc_k_items cim,
3541: okl_system_params osp
3542: WHERE okc.id = kle.chr_id
3612: --Query changed to use base tables instead uv for performance
3613: CURSOR l_itemlocation_csr(p_financial_asset_id NUMBER) IS
3614: SELECT cii.instance_id instance_id, cii.active_end_date instance_end_date
3615: FROM okc_k_headers_b okhv,
3616: okc_k_lines_b kle_fa,
3617: okc_k_lines_tl klet_fa,
3618: okc_line_styles_b lse_fa,
3619: okc_k_lines_b kle_il,
3620: okc_line_styles_b lse_il,
3615: FROM okc_k_headers_b okhv,
3616: okc_k_lines_b kle_fa,
3617: okc_k_lines_tl klet_fa,
3618: okc_line_styles_b lse_fa,
3619: okc_k_lines_b kle_il,
3620: okc_line_styles_b lse_il,
3621: okc_k_lines_b kle_ib,
3622: okc_line_styles_b lse_ib,
3623: okc_k_items ite,
3617: okc_k_lines_tl klet_fa,
3618: okc_line_styles_b lse_fa,
3619: okc_k_lines_b kle_il,
3620: okc_line_styles_b lse_il,
3621: okc_k_lines_b kle_ib,
3622: okc_line_styles_b lse_ib,
3623: okc_k_items ite,
3624: csi_item_instances cii
3625: WHERE kle_fa.id = klet_fa.id
3659:
3660: -- get the deal type from the contract
3661: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
3662: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
3663: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
3664: WHERE khr.id = cle.chr_id
3665: AND lkhr.id = khr.id
3666: AND cle.id = p_financial_asset_id;
3667: