[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:
3538: cim.number_of_items quantity,
3539: -- RRAVIKIR Legal Entity changes
3540: oar.legal_entity_id
3541: -- Legal Entity changes End
3542: FROM okc_k_lines_b kle,
3543: okc_k_headers_all_b okc,
3544: okl_asset_returns_all_b oar,
3545: mtl_system_items_b msi,
3546: okc_k_lines_b kle2,
3542: FROM okc_k_lines_b kle,
3543: okc_k_headers_all_b okc,
3544: okl_asset_returns_all_b oar,
3545: mtl_system_items_b msi,
3546: okc_k_lines_b kle2,
3547: okc_line_styles_b lse,
3548: okc_k_items cim,
3549: okl_system_params osp
3550: WHERE okc.id = kle.chr_id
3620: --Query changed to use base tables instead uv for performance
3621: CURSOR l_itemlocation_csr(p_financial_asset_id NUMBER) IS
3622: SELECT cii.instance_id instance_id, cii.active_end_date instance_end_date
3623: FROM okc_k_headers_b okhv,
3624: okc_k_lines_b kle_fa,
3625: okc_k_lines_tl klet_fa,
3626: okc_line_styles_b lse_fa,
3627: okc_k_lines_b kle_il,
3628: okc_line_styles_b lse_il,
3623: FROM okc_k_headers_b okhv,
3624: okc_k_lines_b kle_fa,
3625: okc_k_lines_tl klet_fa,
3626: okc_line_styles_b lse_fa,
3627: okc_k_lines_b kle_il,
3628: okc_line_styles_b lse_il,
3629: okc_k_lines_b kle_ib,
3630: okc_line_styles_b lse_ib,
3631: okc_k_items ite,
3625: okc_k_lines_tl klet_fa,
3626: okc_line_styles_b lse_fa,
3627: okc_k_lines_b kle_il,
3628: okc_line_styles_b lse_il,
3629: okc_k_lines_b kle_ib,
3630: okc_line_styles_b lse_ib,
3631: okc_k_items ite,
3632: csi_item_instances cii
3633: WHERE kle_fa.id = klet_fa.id
3667:
3668: -- get the deal type from the contract
3669: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
3670: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
3671: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
3672: WHERE khr.id = cle.chr_id
3673: AND lkhr.id = khr.id
3674: AND cle.id = p_financial_asset_id;
3675: