APPS.OKL_ARINTF_PVT dependencies on OKC_LINE_STYLES_B

Line 2266: -- okc_line_styles_b lse

2262:
2263: CURSOR get_top_line ( p_cle_id NUMBER ) IS
2264: select cle.id--, lse.lty_code
2265: from okc_k_lines_b cle--,
2266: -- okc_line_styles_b lse
2267: -- where lse.id = cle.lse_id
2268: -- and cle.cle_id is null
2269: where cle.cle_id is null -- it's top line
2270: start with cle.id = p_cle_id

Line 2295: okc_line_styles_b b,

2291: -- Code Changed for Bug 3044872
2292: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
2293: SELECT c.OBJECT1_ID1
2294: FROM okc_k_lines_b a,
2295: okc_line_styles_b b,
2296: okc_k_items c
2297: WHERE a.cle_id = p_fin_asset_line_id
2298: AND b.lty_code = 'ITEM'
2299: AND a.lse_id = b.id

Line 2323: okc_line_styles_b lse

2319: FROM csi_item_instances csi,
2320: okc_k_items cim,
2321: okc_k_lines_b inst,
2322: okc_k_lines_b ib,
2323: okc_line_styles_b lse
2324: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
2325: AND cim.cle_id = ib.id
2326: AND ib.cle_id = inst.id
2327: AND inst.lse_id = lse.id