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

Line 37: FROM okc_k_lines_b okc,

33: CURSOR cur_get_lines IS
34: SELECT oks.ID,
35: oks.cle_id,
36: oks.object_version_number -- bug 4638902
37: FROM okc_k_lines_b okc,
38: oks_k_lines_b oks
39: WHERE okc.dnz_chr_id = p_chr_id
40: AND okc.lse_id IN (1, 7, 9, 25, 19)
41: AND okc.ID = oks.cle_id;

Line 409: okc_k_lines_b lin

405: CURSOR l_oks_elements (p_line_id NUMBER) IS
406: SELECT itm.number_of_items,kln.toplvl_uom_code,lin.date_terminated
407: FROM oks_k_lines_b kln,
408: okc_k_items itm,
409: okc_k_lines_b lin
410: WHERE kln.cle_id = p_line_id
411: and itm.cle_id = kln.cle_id
412: and lin.id = p_line_id;
413:

Line 423: FROM okc_k_lines_b

419: and sub.instance_id = itm.object1_id1;
420:
421: CURSOR get_orig_system_id1 IS
422: SELECT orig_system_id1
423: FROM okc_k_lines_b
424: WHERE ID = p_id;
425:
426: l_oks_elements_rec l_oks_elements%ROWTYPE;
427: l_old_duration NUMBER;

Line 565: FROM okc_k_lines_b

561:
562: CURSOR l_olddates_csr IS
563: SELECT start_date,
564: end_date
565: FROM okc_k_lines_b
566: WHERE ID =
567: (SELECT ool.object_cle_id
568: FROM okc_operation_lines ool,
569: okc_operation_instances oie,

Line 805: FROM okc_k_lines_b

801: l_api_name CONSTANT VARCHAR2 (30) := 'update_amounts';
802:
803: CURSOR l_topline_csr IS
804: SELECT ID
805: FROM okc_k_lines_b
806: WHERE dnz_chr_id = p_chr_id
807: AND cle_id IS NULL
808: AND lse_id IN (1, 12, 19);
809:

Line 814: FROM okc_k_lines_b

810: CURSOR l_sublineamt_csr (
811: c_cle_id IN NUMBER
812: ) IS
813: SELECT SUM (NVL (price_negotiated, 0)) topline_amt
814: FROM okc_k_lines_b
815: WHERE dnz_chr_id = p_chr_id
816: AND cle_id = c_cle_id
817: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35) -- added skekkar
818: AND date_cancelled IS NULL; -- added skekkar

Line 822: FROM okc_k_lines_b

818: AND date_cancelled IS NULL; -- added skekkar
819:
820: CURSOR l_toplineamt_csr IS
821: SELECT SUM (NVL (price_negotiated, 0)) header_amt
822: FROM okc_k_lines_b
823: WHERE dnz_chr_id = p_chr_id
824: AND cle_id IS NULL
825: AND lse_id IN (1, 12, 19, 46)
826: AND date_cancelled IS NULL; -- added skekkar

Line 836: FROM okc_k_lines_b

832: SELECT SUM (NVL (tax_amount, 0)) topline_tax
833: FROM oks_k_lines_b
834: WHERE dnz_chr_id = p_chr_id
835: AND cle_id IN ( SELECT id
836: FROM okc_k_lines_b
837: WHERE dnz_chr_id = p_chr_id
838: AND cle_id = c_cle_id
839: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
840: AND date_cancelled IS NULL

Line 849: FROM okc_k_lines_b

845: SELECT SUM (NVL (tax_amount, 0)) header_tax
846: FROM oks_k_lines_b
847: WHERE dnz_chr_id = p_chr_id
848: AND cle_id IN ( SELECT id
849: FROM okc_k_lines_b
850: WHERE dnz_chr_id = p_chr_id
851: AND cle_id IS NULL
852: AND lse_id IN (1, 12, 19, 46)
853: AND date_cancelled IS NULL

Line 1605: '123:Amount Goes to OKC_K_LINES_B: ' ||

1601: );
1602: fnd_log.STRING (fnd_log.level_statement,
1603: g_module ||
1604: l_api_name,
1605: '123:Amount Goes to OKC_K_LINES_B: ' ||
1606: l_new_amount
1607: );
1608: END IF;
1609:

Line 1611: --errorout_urp('Amount Goes to OKC_K_LINES_B: ' || l_new_amount);

1607: );
1608: END IF;
1609:
1610: --errorout_urp('In Calulate Price : l_price_type: ' || l_price_type);
1611: --errorout_urp('Amount Goes to OKC_K_LINES_B: ' || l_new_amount);
1612: l_clev_rec.ID := p_line_id;
1613: l_clev_rec.price_negotiated := l_new_amount;
1614:
1615: -- bug 5511211

Line 1970: FROM okc_k_lines_b

1966: price_negotiated,
1967: price_unit,
1968: cle_id,
1969: dnz_chr_id
1970: FROM okc_k_lines_b
1971: WHERE dnz_chr_id = p_reprice_rec.contract_id
1972: AND lse_id IN (7, 8, 9, 10, 11, 13, 25, 35, 46);
1973:
1974: -- Bug Fix 4291565

Line 2070: FROM okc_k_lines_b

2066: price_negotiated,
2067: price_unit,
2068: cle_id,
2069: dnz_chr_id
2070: FROM okc_k_lines_b
2071: WHERE dnz_chr_id = p_reprice_rec.contract_id
2072: AND lse_id IN (8, 10, 11, 13, 35); -- Bug fix 4769124
2073: l_man_priced_line_rec l_man_priced_lines_csr%ROWTYPE;
2074:

Line 2956: FROM okc_k_lines_b

2952: price_negotiated,
2953: price_unit,
2954: cle_id,
2955: dnz_chr_id
2956: FROM okc_k_lines_b
2957: WHERE ID = p_line_id;
2958:
2959: CURSOR l_usage_type_csr (
2960: p_cle_id NUMBER