APPS.OKS_OCINT_PUB dependencies on OKC_K_LINES_B

Line 694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line

690:
691: CURSOR l_contract_csr (p_ordlineid NUMBER)
692: IS
693: SELECT rel.cle_id, rel.chr_id
694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line
695: WHERE rel.object1_id1 = TO_CHAR (p_ordlineid)
696: AND rel.jtot_object1_code = 'OKX_ORDERLINE'
697: AND line.ID = rel.cle_id
698: AND line.lse_id IN (9, 25);

Line 744: FROM okc_k_lines_b

740:
741: CURSOR l_contract_line_csr (p_subline_id NUMBER)
742: IS
743: SELECT cle_id
744: FROM okc_k_lines_b
745: WHERE ID = p_subline_id;
746:
747: --General
748: l_index NUMBER;

Line 831: FROM okc_k_lines_b

827:
828: CURSOR l_lndates_csr (p_id NUMBER)
829: IS
830: SELECT start_date, end_date
831: FROM okc_k_lines_b
832: WHERE ID = p_id;
833:
834: CURSOR l_hdrdates_csr (p_id NUMBER)
835: IS

Line 853: okc_k_lines_b clines

849: CURSOR c_extwar_line_amount(p_chr_id IN NUMBER, p_line_id IN NUMBER) IS
850: SELECT
851: SUM(NVL(slines.tax_amount,0)) tax_amount
852: FROM
853: okc_k_lines_b clines
854: ,oks_k_lines_b slines
855: WHERE
856: clines.dnz_chr_id = p_chr_id
857: and clines.cle_id = p_line_id

Line 866: okc_k_lines_b clines

862: CURSOR c_extwar_hdr_amount(p_chr_id IN NUMBER) IS
863: SELECT
864: SUM(NVL(slines.tax_amount,0)) tax_amount
865: FROM
866: okc_k_lines_b clines
867: ,oks_k_lines_b slines
868: WHERE
869: clines.dnz_chr_id = p_chr_id
870: AND clines.lse_id IN (1, 19)

Line 910: is select nvl(price_negotiated,0) from okc_k_lines_b where id = c_line_id;

906: l_prev_line_amt NUMBER;
907: l_curr_line_amt NUMBER;
908:
909: cursor c_line_ammt_ckeck(c_line_id in number)
910: is select nvl(price_negotiated,0) from okc_k_lines_b where id = c_line_id;
911:
912: -- Added fro fix of bug# 5165947
913:
914: BEGIN

Line 2004: UPDATE okc_k_lines_b

2000:
2001:
2002: --Added for fix of bug# 5274971
2003:
2004: UPDATE okc_k_lines_b
2005: SET price_negotiated =
2006: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2007: FROM okc_k_lines_b
2008: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)

Line 2007: FROM okc_k_lines_b

2003:
2004: UPDATE okc_k_lines_b
2005: SET price_negotiated =
2006: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2007: FROM okc_k_lines_b
2008: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2009: WHERE ID = l_lineid;
2010:
2011: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

Line 2014: FROM okc_k_lines_b

2010:
2011: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2012: SET estimated_amount =
2013: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2014: FROM okc_k_lines_b
2015: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
2016: WHERE ID = l_chrid;
2017:
2018:

Line 2307: -- UPDATE okc_k_lines_b

2303: END IF;
2304:
2305: -- Commented out for fix of bug# 5274971
2306: --
2307: -- UPDATE okc_k_lines_b
2308: -- SET price_negotiated =
2309: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2310: -- FROM okc_k_lines_b
2311: -- WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)

Line 2310: -- FROM okc_k_lines_b

2306: --
2307: -- UPDATE okc_k_lines_b
2308: -- SET price_negotiated =
2309: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2310: -- FROM okc_k_lines_b
2311: -- WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2312: -- WHERE ID = l_lineid;
2313: --
2314: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

Line 2317: -- FROM okc_k_lines_b

2313: --
2314: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2315: -- SET estimated_amount =
2316: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2317: -- FROM okc_k_lines_b
2318: -- WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
2319: -- WHERE ID = l_chrid;
2320: --
2321: --