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')
1808: AND kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id
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
3552: AND oar.imr_id = msi.inventory_item_id
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')
3635: AND kle_fa.chr_id = okhv.id AND lse_fa.id = kle_fa.lse_id