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 3539: okc_line_styles_b lse,

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

Line 3618: okc_line_styles_b lse_fa,

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,
3621: okc_k_lines_b kle_ib,
3622: okc_line_styles_b lse_ib,

Line 3620: okc_line_styles_b lse_il,

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

Line 3622: okc_line_styles_b lse_ib,

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