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 49: FROM okc_k_lines_b

45: )
46: IS
47: SELECT lse_id,
48: line_number
49: FROM okc_k_lines_b
50: WHERE ID = p_line_id;
51:
52: CURSOR l_line_no_csr (
53: p_subline_id NUMBER

Line 59: FROM okc_k_lines_b a,

55: IS
56: SELECT b.line_number ||
57: '.' ||
58: a.line_number line_no
59: FROM okc_k_lines_b a,
60: okc_k_lines_b b
61: WHERE a.ID = p_subline_id
62: AND a.cle_id = b.ID;
63:

Line 60: okc_k_lines_b b

56: SELECT b.line_number ||
57: '.' ||
58: a.line_number line_no
59: FROM okc_k_lines_b a,
60: okc_k_lines_b b
61: WHERE a.ID = p_subline_id
62: AND a.cle_id = b.ID;
63:
64: l_lse_id NUMBER;

Line 190: FROM okc_k_lines_b kle,

186: FUNCTION get_subline_discount(p_subline_id IN NUMBER) RETURN NUMBER IS
187: CURSOR cs_subline_discount (cp_subline_id IN NUMBER) IS
188: SELECT kle.lse_id,
189: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty discount
190: FROM okc_k_lines_b kle,
191: oks_k_lines_b cleb
192: WHERE kle.ID = cp_subline_id
193: AND kle.ID = cleb.cle_id
194: AND NVL(kle.line_list_price, 0) > NVL(cleb.toplvl_adj_price,0);

Line 234: FROM okc_k_lines_b kle,

230: FUNCTION get_subline_surcharge(p_subline_id IN NUMBER) RETURN NUMBER IS
231: CURSOR cs_subline_surcharge(cp_subline_id IN NUMBER) IS
232: SELECT kle.lse_id,
233: (NVL(cleb.toplvl_adj_price,0) - NVL(kle.line_list_price,0)) * cleb.toplvl_price_qty surcharge
234: FROM okc_k_lines_b kle,
235: oks_k_lines_b cleb
236: WHERE kle.ID = cp_subline_id
237: AND kle.ID = cleb.cle_id
238: AND NVL (kle.line_list_price, 0) < NVL (cleb.toplvl_adj_price, 0);

Line 288: FROM okc_k_lines_b

284: )
285: IS
286: SELECT ID,
287: lse_id
288: FROM okc_k_lines_b
289: WHERE cle_id = cp_cle_id;
290:
291: l_lse_id NUMBER;
292: l_topline_discount NUMBER;

Line 362: FROM okc_k_lines_b

358: )
359: IS
360: SELECT ID,
361: lse_id
362: FROM okc_k_lines_b
363: WHERE cle_id = cp_cle_id;
364:
365: l_lse_id NUMBER;
366: l_topline_surcharge NUMBER;

Line 441: FROM okc_k_lines_b

437: start_date,
438: end_date,
439: date_terminated,
440: dnz_chr_id
441: FROM okc_k_lines_b
442: WHERE ID = p_line_id;
443:
444: l_line_rec l_line_csr%ROWTYPE;
445: l_kln_rec_in oks_contract_line_pub.klnv_rec_type;

Line 620: FROM okc_k_lines_b

616:
617: CURSOR cs_hdr_line
618: IS
619: SELECT ID
620: FROM okc_k_lines_b
621: WHERE dnz_chr_id = p_chr_id
622: AND cle_id IS NULL;
623:
624: l_line_discount NUMBER;

Line 774: FROM okc_k_lines_b

770: )
771: IS
772: SELECT ID,
773: object_version_number
774: FROM okc_k_lines_b
775: WHERE ID = p_id;
776:
777: CURSOR l_oks_chr_csr (
778: p_id NUMBER

Line 895: FROM okc_k_lines_b

891: )
892: IS
893: SELECT dnz_chr_id,
894: cle_id
895: FROM okc_k_lines_b
896: WHERE ID = p_line_id;
897: BEGIN
898: -- start debug log
899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 975: FROM okc_k_lines_b kl,

971: p_subline_id NUMBER
972: )
973: IS
974: SELECT 'x'
975: FROM okc_k_lines_b kl,
976: okc_k_items ki,
977: oks_subscr_header_b sh
978: WHERE kl.ID = p_subline_id
979: AND ki.cle_id = kl.ID

Line 1045: FROM okc_k_lines_b

1041: IS
1042: SELECT cle_id,
1043: lse_id,
1044: dnz_chr_id
1045: FROM okc_k_lines_b
1046: WHERE ID = p_line_id;
1047:
1048: CURSOR l_item_csr (
1049: c_cle_id NUMBER

Line 1339: FROM okc_k_lines_b

1335: p_line_id NUMBER
1336: )
1337: IS
1338: SELECT SUM (price_negotiated) amount
1339: FROM okc_k_lines_b
1340: WHERE cle_id = p_line_id
1341: AND chr_id IS NULL
1342: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
1343: AND date_cancelled IS NULL; -- bug 4870602

Line 1350: FROM okc_k_lines_b

1346: p_chr_id NUMBER
1347: )
1348: IS
1349: SELECT SUM (price_negotiated) amount
1350: FROM okc_k_lines_b
1351: WHERE chr_id = p_chr_id
1352: AND cle_id IS NULL
1353: AND date_cancelled IS NULL; -- bug 4870602
1354:

Line 1728: FROM okc_k_lines_b

1724: item_to_price_yn,
1725: pricing_date,
1726: price_basis_yn,
1727: object_version_number
1728: FROM okc_k_lines_b
1729: WHERE ID = p_cle_id
1730: AND lse_id = 46;
1731:
1732: CURSOR l_subs_elements_csr (

Line 2681: FROM okc_k_lines_b

2677: line_list_price,
2678: item_to_price_yn,
2679: pricing_date,
2680: price_basis_yn
2681: FROM okc_k_lines_b
2682: WHERE ID = p_cle_id
2683: AND lse_id IN (7, 9, 25);
2684:
2685: CURSOR l_prodpriceuom_csr (

Line 2698: FROM okc_k_lines_b

2694: p_cle_id NUMBER
2695: )
2696: IS
2697: SELECT dnz_chr_id
2698: FROM okc_k_lines_b
2699: WHERE ID = p_cle_id;
2700:
2701: CURSOR l_numitems_csr (
2702: p_subline_id NUMBER

Line 3383: FROM okc_k_lines_b

3379: SELECT ID,
3380: start_date,
3381: end_date,
3382: lse_id
3383: FROM okc_k_lines_b
3384: WHERE cle_id = p_cle_id
3385: AND lse_id IN (7, 9, 25)
3386: AND date_cancelled IS NULL --[llc]
3387: AND date_terminated IS NULL -- bug 5504157

Line 4348: from okc_k_lines_b

4344: select id,
4345: start_date,
4346: end_date,
4347: lse_id
4348: from okc_k_lines_b
4349: where cle_id = p_cle_id
4350: and lse_id in (7, 9, 25)
4351: and date_cancelled is null --[llc]
4352: and date_terminated is null -- bug 5504157

Line 6111: FROM okc_k_lines_b

6107: SELECT ID,
6108: start_date,
6109: end_date,
6110: lse_id
6111: FROM okc_k_lines_b
6112: WHERE chr_id = p_chr_id
6113: AND lse_id IN (1, 14, 19, 46)
6114: AND date_cancelled IS NULL --[llc] bug 4653406
6115: AND date_terminated IS NULL -- bug 5504157