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_QP_INT_PVT dependencies on OKC_K_LINES_B

Line 27: FROM okc_k_lines_b

23: )
24: IS
25: SELECT lse_id,
26: line_number
27: FROM okc_k_lines_b
28: WHERE ID = p_line_id;
29:
30: CURSOR l_line_no_csr (
31: p_subline_id NUMBER

Line 37: FROM okc_k_lines_b a,

33: IS
34: SELECT b.line_number ||
35: '.' ||
36: a.line_number line_no
37: FROM okc_k_lines_b a,
38: okc_k_lines_b b
39: WHERE a.ID = p_subline_id
40: AND a.cle_id = b.ID;
41:

Line 38: okc_k_lines_b b

34: SELECT b.line_number ||
35: '.' ||
36: a.line_number line_no
37: FROM okc_k_lines_b a,
38: okc_k_lines_b b
39: WHERE a.ID = p_subline_id
40: AND a.cle_id = b.ID;
41:
42: l_lse_id NUMBER;

Line 168: FROM okc_k_lines_b kle,

164: FUNCTION get_subline_discount(p_subline_id IN NUMBER) RETURN NUMBER IS
165: CURSOR cs_subline_discount (cp_subline_id IN NUMBER) IS
166: SELECT kle.lse_id,
167: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty discount
168: FROM okc_k_lines_b kle,
169: oks_k_lines_b cleb
170: WHERE kle.ID = cp_subline_id
171: AND kle.ID = cleb.cle_id
172: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);

Line 212: FROM okc_k_lines_b kle,

208: FUNCTION get_subline_surcharge(p_subline_id IN NUMBER) RETURN NUMBER IS
209: CURSOR cs_subline_surcharge(cp_subline_id IN NUMBER) IS
210: SELECT kle.lse_id,
211: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty surcharge
212: FROM okc_k_lines_b kle,
213: oks_k_lines_b cleb
214: WHERE kle.ID = cp_subline_id
215: AND kle.ID = cleb.cle_id
216: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);

Line 266: FROM okc_k_lines_b

262: )
263: IS
264: SELECT ID,
265: lse_id
266: FROM okc_k_lines_b
267: WHERE cle_id = cp_cle_id;
268:
269: l_lse_id NUMBER;
270: l_topline_discount NUMBER;

Line 340: FROM okc_k_lines_b

336: )
337: IS
338: SELECT ID,
339: lse_id
340: FROM okc_k_lines_b
341: WHERE cle_id = cp_cle_id;
342:
343: l_lse_id NUMBER;
344: l_topline_surcharge NUMBER;

Line 419: FROM okc_k_lines_b

415: start_date,
416: end_date,
417: date_terminated,
418: dnz_chr_id
419: FROM okc_k_lines_b
420: WHERE ID = p_line_id;
421:
422: l_line_rec l_line_csr%ROWTYPE;
423: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;

Line 598: FROM okc_k_lines_b

594:
595: CURSOR cs_hdr_line
596: IS
597: SELECT ID
598: FROM okc_k_lines_b
599: WHERE dnz_chr_id = p_chr_id
600: AND cle_id IS NULL;
601:
602: l_line_discount NUMBER;

Line 752: FROM okc_k_lines_b

748: )
749: IS
750: SELECT ID,
751: object_version_number
752: FROM okc_k_lines_b
753: WHERE ID = p_id;
754:
755: CURSOR l_oks_chr_csr (
756: p_id NUMBER

Line 873: FROM okc_k_lines_b

869: )
870: IS
871: SELECT dnz_chr_id,
872: cle_id
873: FROM okc_k_lines_b
874: WHERE ID = p_line_id;
875: BEGIN
876: -- start debug log
877: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 953: FROM okc_k_lines_b kl,

949: p_subline_id NUMBER
950: )
951: IS
952: SELECT 'x'
953: FROM okc_k_lines_b kl,
954: okc_k_items ki,
955: oks_subscr_header_b sh
956: WHERE kl.ID = p_subline_id
957: AND ki.cle_id = kl.ID

Line 1023: FROM okc_k_lines_b

1019: IS
1020: SELECT cle_id,
1021: lse_id,
1022: dnz_chr_id
1023: FROM okc_k_lines_b
1024: WHERE ID = p_line_id;
1025:
1026: CURSOR l_item_csr (
1027: c_cle_id NUMBER

Line 1317: FROM okc_k_lines_b

1313: p_line_id NUMBER
1314: )
1315: IS
1316: SELECT SUM (price_negotiated) amount
1317: FROM okc_k_lines_b
1318: WHERE cle_id = p_line_id
1319: AND chr_id IS NULL
1320: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
1321: AND date_cancelled IS NULL; -- bug 4870602

Line 1328: FROM okc_k_lines_b

1324: p_chr_id NUMBER
1325: )
1326: IS
1327: SELECT SUM (price_negotiated) amount
1328: FROM okc_k_lines_b
1329: WHERE chr_id = p_chr_id
1330: AND cle_id IS NULL
1331: AND date_cancelled IS NULL; -- bug 4870602
1332:

Line 1706: FROM okc_k_lines_b

1702: item_to_price_yn,
1703: pricing_date,
1704: price_basis_yn,
1705: object_version_number
1706: FROM okc_k_lines_b
1707: WHERE ID = p_cle_id
1708: AND lse_id = 46;
1709:
1710: CURSOR l_subs_elements_csr (

Line 2645: FROM okc_k_lines_b

2641: line_list_price,
2642: item_to_price_yn,
2643: pricing_date,
2644: price_basis_yn
2645: FROM okc_k_lines_b
2646: WHERE ID = p_cle_id
2647: AND lse_id IN (7, 9, 25);
2648:
2649: CURSOR l_prodpriceuom_csr (

Line 2662: FROM okc_k_lines_b

2658: p_cle_id NUMBER
2659: )
2660: IS
2661: SELECT dnz_chr_id
2662: FROM okc_k_lines_b
2663: WHERE ID = p_cle_id;
2664:
2665: CURSOR l_numitems_csr (
2666: p_subline_id NUMBER

Line 3344: FROM okc_k_lines_b

3340: SELECT ID,
3341: start_date,
3342: end_date,
3343: lse_id
3344: FROM okc_k_lines_b
3345: WHERE cle_id = p_cle_id
3346: AND lse_id IN (7, 9, 25)
3347: AND date_cancelled IS NULL --[llc]
3348: AND date_terminated IS NULL -- bug 5504157

Line 3907: FROM okc_k_lines_b

3903: SELECT ID,
3904: start_date,
3905: end_date,
3906: lse_id
3907: FROM okc_k_lines_b
3908: WHERE chr_id = p_chr_id
3909: AND lse_id IN (1, 14, 19, 46)
3910: AND date_cancelled IS NULL --[llc] bug 4653406
3911: AND date_terminated IS NULL -- bug 5504157