APPS.OKL_ARINTF_PVT dependencies on OKC_LINE_STYLES_B

Line 1301: -- okc_line_styles_b lse

1297:
1298: CURSOR get_top_line ( p_cle_id NUMBER ) IS
1299: select cle.id--, lse.lty_code
1300: from okc_k_lines_b cle--,
1301: -- okc_line_styles_b lse
1302: -- where lse.id = cle.lse_id
1303: -- and cle.cle_id is null
1304: where cle.cle_id is null -- it's top line
1305: start with cle.id = p_cle_id

Line 1329: okc_line_styles_b b,

1325: -- Code Changed for Bug 3044872
1326: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1327: SELECT c.OBJECT1_ID1
1328: FROM okc_k_lines_b a,
1329: okc_line_styles_b b,
1330: okc_k_items c
1331: WHERE a.cle_id = p_fin_asset_line_id
1332: AND b.lty_code = 'ITEM'
1333: AND a.lse_id = b.id

Line 1357: okc_line_styles_b lse

1353: FROM csi_item_instances csi,
1354: okc_k_items cim,
1355: okc_k_lines_b inst,
1356: okc_k_lines_b ib,
1357: okc_line_styles_b lse
1358: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
1359: AND cim.cle_id = ib.id
1360: AND ib.cle_id = inst.id
1361: AND inst.lse_id = lse.id