DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OKC_LINE_STYLES_B

Line 1799: okc_line_styles_b lse_fa,

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,
1802: okc_k_lines_b kle_ib,
1803: okc_line_styles_b lse_ib,

Line 1801: okc_line_styles_b lse_il,

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,
1805: csi_item_instances cii

Line 1803: okc_line_styles_b lse_ib,

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
1807: AND klet_fa.language = USERENV('LANG')

Line 1842: FROM okc_k_lines_b cle, okc_line_styles_b lse

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:

Line 3547: okc_line_styles_b lse,

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
3551: AND oar.kle_id = kle.id

Line 3626: okc_line_styles_b lse_fa,

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,
3629: okc_k_lines_b kle_ib,
3630: okc_line_styles_b lse_ib,

Line 3628: okc_line_styles_b lse_il,

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,
3632: csi_item_instances cii

Line 3630: okc_line_styles_b lse_ib,

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
3634: AND klet_fa.language = USERENV('LANG')