APPS.OKS_OMINT_PUB dependencies on OKC_K_LINES_B

Line 1419: From okc_k_items ot, okc_k_lines_b ol

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

Line 1694: FROM OKC_K_LINES_B

1690:
1691: --Added for bug# 5623790 by sjanakir
1692: CURSOR l_lse_id_csr(p_id IN NUMBER) IS
1693: SELECT lse_id
1694: FROM OKC_K_LINES_B
1695: WHERE id = p_id;
1696: --Addition Ends
1697: l_target_qty NUMBER;
1698: l_source_uom varchar2(30);

Line 1825: FROM OKC_K_LINES_B

1821:
1822: --Added for bug#5330614
1823: Cursor l_lse_id_csr(p_id IN NUMBER) IS
1824: SELECT lse_id
1825: FROM OKC_K_LINES_B
1826: WHERE id = p_id;
1827:
1828: l_target_qty NUMBER;
1829: l_target_uom varchar2(30);

Line 1848: from okc_k_lines_b subline,

1844: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
1845:
1846: /* CURSOR om_period_csr(p_id IN NUMBER) IS
1847: select service_period,service_duration
1848: from okc_k_lines_b subline,
1849: okc_k_rel_objs rel,
1850: oe_order_lines_all oel
1851: where subline.cle_id = p_id
1852: and rel.cle_id = subline.id