eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: /*cgopinee bugfix for bug 8276025*/
748: /* CURSOR l_pricing_qty_csr(p_ordline_id Number)

Line 857: FROM okc_k_lines_b

853:
854: CURSOR l_lndates_csr (p_id NUMBER)
855: IS
856: SELECT start_date, end_date
857: FROM okc_k_lines_b
858: WHERE ID = p_id;
859:
860: CURSOR l_hdrdates_csr (p_id NUMBER)
861: IS

Line 879: okc_k_lines_b clines

875: CURSOR c_extwar_line_amount(p_chr_id IN NUMBER, p_line_id IN NUMBER) IS
876: SELECT
877: SUM(NVL(slines.tax_amount,0)) tax_amount
878: FROM
879: okc_k_lines_b clines
880: ,oks_k_lines_b slines
881: WHERE
882: clines.dnz_chr_id = p_chr_id
883: and clines.cle_id = p_line_id

Line 892: okc_k_lines_b clines

888: CURSOR c_extwar_hdr_amount(p_chr_id IN NUMBER) IS
889: SELECT
890: SUM(NVL(slines.tax_amount,0)) tax_amount
891: FROM
892: okc_k_lines_b clines
893: ,oks_k_lines_b slines
894: WHERE
895: clines.dnz_chr_id = p_chr_id
896: AND clines.lse_id IN (1, 19, 46) ---Modified for ER 16039680

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

990:
991: /*Added for CLOUD ER 16039680*/
992:
993: cursor c_line_ammt_ckeck(c_line_id in number)
994: is select nvl(price_negotiated,0) from okc_k_lines_b where id = c_line_id;
995:
996: -- Added fro fix of bug# 5165947
997:
998: BEGIN

Line 2571: UPDATE okc_k_lines_b

2567: );
2568: l_negotiated_amount :=l_k_line_rec.unit_selling_price * l_sub_qty ;
2569: l_list_price := (l_k_line_rec.unit_selling_price * l_sub_qty)/nvl(l_pr_qty,1);
2570:
2571: UPDATE okc_k_lines_b
2572: SET price_negotiated =l_negotiated_amount,
2573: price_unit =l_list_price
2574: WHERE id=l_lineid;
2575:

Line 2586: UPDATE okc_k_lines_b

2582:
2583: --Added for fix of bug# 5274971
2584: IF l_k_line_rec.coverage_schd_id IS NOT NULL THEN /*Added for CLOUD ER*/
2585:
2586: UPDATE okc_k_lines_b
2587: SET price_negotiated =
2588: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2589: FROM okc_k_lines_b
2590: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)

Line 2589: FROM okc_k_lines_b

2585:
2586: UPDATE okc_k_lines_b
2587: SET price_negotiated =
2588: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2589: FROM okc_k_lines_b
2590: WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2591: WHERE ID = l_lineid;
2592: END IF;
2593: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

Line 2596: FROM okc_k_lines_b

2592: END IF;
2593: UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2594: SET estimated_amount =
2595: (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2596: FROM okc_k_lines_b
2597: WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19, 46)) ---Modified for ER16039680
2598: WHERE ID = l_chrid;
2599:
2600:

Line 2951: -- UPDATE okc_k_lines_b

2947: END IF;
2948:
2949: -- Commented out for fix of bug# 5274971
2950: --
2951: -- UPDATE okc_k_lines_b
2952: -- SET price_negotiated =
2953: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2954: -- FROM okc_k_lines_b
2955: -- WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)

Line 2954: -- FROM okc_k_lines_b

2950: --
2951: -- UPDATE okc_k_lines_b
2952: -- SET price_negotiated =
2953: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2954: -- FROM okc_k_lines_b
2955: -- WHERE cle_id = l_lineid AND dnz_chr_id = l_chrid)
2956: -- WHERE ID = l_lineid;
2957: --
2958: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC

Line 2961: -- FROM okc_k_lines_b

2957: --
2958: -- UPDATE okc_k_headers_all_b --mmadhavi _all for MOAC
2959: -- SET estimated_amount =
2960: -- (SELECT NVL (SUM (NVL (price_negotiated, 0)), 0)
2961: -- FROM okc_k_lines_b
2962: -- WHERE dnz_chr_id = l_chrid AND lse_id IN (1, 19))
2963: -- WHERE ID = l_chrid;
2964: --
2965: --

Line 4858: From okc_k_lines_b KL,

4854: Cursor kl_cur Is
4855: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
4856: KI.number_of_items, KI.uom_code,
4857: NVL(MTL.contract_item_type_code,'NON-SUB'), MTL.coverage_schedule_id, MTL.comms_nl_trackable_flag
4858: From okc_k_lines_b KL,
4859: okc_k_items KI,
4860: mtl_system_items MTL
4861: Where KL.id = p_cle_id
4862: and KI.cle_id = p_cle_id

Line 4889: FROM okc_k_headers_all_b okhb,okc_k_lines_b okcl

4885: WHERE instance_id = p_cp_id;
4886:
4887: CURSOR l_contract_hdr_dtls IS
4888: SELECT okhb.start_date,okhb.end_date,okcl.cust_acct_id,okcl.sts_code
4889: FROM okc_k_headers_all_b okhb,okc_k_lines_b okcl
4890: WHERE okhb.id=okcl.chr_id
4891: AND okcl.id=p_cle_id;
4892:
4893: