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_AUTH_UTIL_PVT dependencies on OKS_K_LINES_B

Line 4372: FROM okc_k_lines_b cle, oks_k_lines_b sle

4368: --LLC
4369:
4370: CURSOR get_topline_tax_amt_csr (p_cle_id IN NUMBER) IS
4371: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4372: FROM okc_k_lines_b cle, oks_k_lines_b sle
4373: WHERE cle.cle_id = p_cle_id
4374: AND cle.lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
4375: AND cle.id = sle.cle_id
4376: AND cle.dnz_chr_id = sle.dnz_chr_id

Line 4381: FROM okc_k_lines_b cle, oks_k_lines_b sle

4377: AND cle.date_cancelled IS NULL;
4378:
4379: CURSOR get_hdr_tax_amt_csr (p_chr_id IN NUMBER) IS
4380: SELECT nvl(SUM(nvl(tax_amount, 0)), 0)
4381: FROM okc_k_lines_b cle, oks_k_lines_b sle
4382: WHERE cle.dnz_chr_id = p_chr_id
4383: AND cle.lse_id IN (1, 12, 14, 19, 46)
4384: AND cle.cle_id IS NULL
4385: AND cle.id = sle.cle_id

Line 4499: oks_k_lines_b kln

4495: , cle.dnz_chr_id chr_id
4496: , kln.id kln_id
4497: , kln.object_version_number
4498: FROM okc_k_lines_b cle,
4499: oks_k_lines_b kln
4500: WHERE cle.cle_id = p_cle_id
4501: AND kln.cle_id = cle.id
4502: AND lse_id NOT IN (2, 15, 20, 46);
4503:

Line 5104: UPDATE oks_k_lines_b

5100: RAISE G_ERROR;
5101: END IF;
5102: **/
5103: --Bug 4718226: need to create standard coverage to service line after split
5104: UPDATE oks_k_lines_b
5105: SET coverage_id = l_covtemp_id,
5106: standard_cov_yn = 'Y'
5107: WHERE cle_id = l_target_tbl(idx).cle_id;
5108:

Line 6322: FROM okc_k_lines_b cle, oks_k_lines_b kln

6318: AND date_cancelled IS NULL; -- line Level Cancellation
6319:
6320: CURSOR toplinetax_cur(p_cle_id IN NUMBER) IS
6321: SELECT SUM(nvl(tax_amount, 0)) amount
6322: FROM okc_k_lines_b cle, oks_k_lines_b kln
6323: WHERE cle.cle_id = p_cle_id
6324: AND cle.id = kln.cle_id
6325: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
6326: AND cle.date_cancelled IS NULL;

Line 6332: FROM oks_k_lines_b

6328: l_tax_amount toplinetax_cur%ROWTYPE;
6329:
6330: CURSOR Get_oks_Lines_details(p_cle_id IN NUMBER) IS
6331: SELECT id, object_version_number, dnz_chr_id
6332: FROM oks_k_lines_b
6333: WHERE cle_id = p_cle_id ;
6334:
6335: l_get_oks_details Get_oks_Lines_details%ROWTYPE;
6336:

Line 6472: FROM okc_k_lines_b cle, oks_k_lines_b kln

6468:
6469: -- Header Tax Total
6470: CURSOR hdrtax_cur IS
6471: SELECT SUM(kln.tax_amount) amount
6472: FROM okc_k_lines_b cle, oks_k_lines_b kln
6473: WHERE cle.dnz_chr_id = p_header_id
6474: AND cle.id = kln.cle_id
6475: AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
6476: AND cle.date_cancelled IS NULL;

Line 6631: FROM okc_k_lines_b okc, oks_k_lines_b oks

6627: okc.dnz_chr_id,
6628: currency_code,
6629: oks.id oks_id,
6630: oks.object_version_number
6631: FROM okc_k_lines_b okc, oks_k_lines_b oks
6632: WHERE okc.Cle_id = p_contract_line_id
6633: AND OKS.cle_id = okc.id
6634: AND (okc.date_terminated IS NULL OR okc.date_terminated > TRUNC(SYSDATE))
6635: AND lse_id NOT IN(2, 15, 20)

Line 6640: FROM oks_k_lines_b

6636: AND okc.date_cancelled IS NULL; -- line Level Cancellation
6637:
6638: CURSOR get_tax_details(p_cle_id IN NUMBER) IS
6639: SELECT id, object_version_number
6640: FROM oks_k_lines_b
6641: WHERE cle_id = p_cle_id;
6642:
6643: get_tax_rec get_tax_details%rowtype;
6644: -- Bug 5228352 --

Line 7776: FROM OKS_k_LINES_B

7772:
7773: CURSOR get_lines_details (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
7774: SELECT locked_price_list_id,
7775: locked_price_list_line_id
7776: FROM OKS_k_LINES_B
7777: WHERE dnz_chr_id = p_chr_id
7778: AND cle_id = p_cle_id ;
7779:
7780: l_return_status VARCHAR2(2);

Line 7829: UPDATE OKS_K_LINES_B SET

7825: END IF;
7826: END IF;
7827: END IF;
7828:
7829: UPDATE OKS_K_LINES_B SET
7830: locked_price_list_id = NULL,
7831: locked_price_list_line_id = NULL
7832: WHERE dnz_chr_id = p_contract_hdr_id
7833: AND cle_id = cur_rec.id ;

Line 7949: oks_k_lines_b c, oks_k_lines_b d

7945: SUM(nvl(b.price_negotiated,0)) sum_subline_amt,
7946: nvl(c.tax_amount,0) topline_tax_amt,
7947: SUM(nvl(d.tax_amount,0)) sum_subline_tax_amt
7948: FROM okc_k_lines_b a, okc_k_lines_b b,
7949: oks_k_lines_b c, oks_k_lines_b d
7950: WHERE a.dnz_chr_id = cp_chr_id AND a.lse_id IN (1,12,14,19)
7951: AND b.dnz_chr_id = a.dnz_chr_id AND b.cle_id = a.id
7952: AND a.id=c.cle_id AND b.id=d.cle_id
7953: AND b.lse_id IN (7,8,9,10,11,35,13,18,25)

Line 7979: oks_k_headers_b c, oks_k_lines_b d

7975: SUM(nvl(b.price_negotiated,0)) sum_tl_line_amt,
7976: nvl(c.tax_amount,0) hdr_tax_amt,
7977: SUM(nvl(d.tax_amount,0)) sum_tl_line_amt_tax
7978: FROM okc_k_headers_all_b a, okc_k_lines_b b,
7979: oks_k_headers_b c, oks_k_lines_b d
7980: WHERE a.id = cp_chr_id
7981: AND b.dnz_chr_id = a.id AND b.cle_id IS NULL
7982: AND d.dnz_chr_id = c.chr_id AND d.cle_id=b.id
7983: AND b.date_cancelled is null

Line 8099: UPDATE oks_k_lines_b

8095: SET price_negotiated = l_sl_amt_tbl(j)
8096: WHERE id = l_tl_id_tbl(j);
8097:
8098: FORALL j IN l_tl_id_tbl.first..l_tl_id_tbl.last
8099: UPDATE oks_k_lines_b
8100: SET tax_amount = l_sl_amt_tax_tbl(j)
8101: WHERE cle_id = l_tl_id_tbl(j);
8102:
8103: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN