APPS.OKS_OMINT_PUB dependencies on OKC_K_LINES_B

Line 1415: From okc_k_items ot, okc_k_lines_b ol

1411: Where line_id = p_order_line_id;
1412:
1413: Cursor l_get_warr_dates_csr(p_cp_id Number) IS
1414: Select max(ol.end_date)
1415: From okc_k_items ot, okc_k_lines_b ol
1416: Where ot.object1_id1 = to_char(p_cp_id) -- Bug Fix #5011519
1417: And ol.id = ot.cle_id
1418: And ol.lse_id = 18 ;
1419:

Line 1647: FROM OKC_K_LINES_B

1643:
1644: --Added for bug# 5623790 by sjanakir
1645: CURSOR l_lse_id_csr(p_id IN NUMBER) IS
1646: SELECT lse_id
1647: FROM OKC_K_LINES_B
1648: WHERE id = p_id;
1649: --Addition Ends
1650: l_target_qty NUMBER;
1651: l_source_uom varchar2(30);

Line 1778: FROM OKC_K_LINES_B

1774:
1775: --Added for bug#5330614
1776: Cursor l_lse_id_csr(p_id IN NUMBER) IS
1777: SELECT lse_id
1778: FROM OKC_K_LINES_B
1779: WHERE id = p_id;
1780:
1781: l_target_qty NUMBER;
1782: l_target_uom varchar2(30);

Line 1801: from okc_k_lines_b subline,

1797: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
1798:
1799: /* CURSOR om_period_csr(p_id IN NUMBER) IS
1800: select service_period,service_duration
1801: from okc_k_lines_b subline,
1802: okc_k_rel_objs rel,
1803: oe_order_lines_all oel
1804: where subline.cle_id = p_id
1805: and rel.cle_id = subline.id