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

Line 84: FROM okc_k_lines_b kl, oks_k_lines_b sl

80: l_shiporg_id NUMBER
81: )
82: IS
83: SELECT 'x'
84: FROM okc_k_lines_b kl, oks_k_lines_b sl
85: WHERE kl.ID = p_k_line_id
86: AND kl.ID = sl.cle_id
87: AND NVL (sl.acct_rule_id, -99) = NVL (l_acct_id, -99)
88: AND NVL (kl.inv_rule_id, -99) = NVL (l_inv_id, -99)

Line 1279: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c

1275: a.bill_to_site_use_id, a.line_renewal_type_code,
1276: b.tax_code --Fix for bug 4121175
1277: ,
1278: b.price_uom
1279: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1280: WHERE a.ID = l_line_id AND a.ID = b.cle_id AND a.sts_code = c.code;
1281:
1282: CURSOR service_item (l_line_id NUMBER)
1283: IS

Line 1309: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c

1305: l_price_uom VARCHAR2
1306: )
1307: IS
1308: SELECT a.ID
1309: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1310: WHERE a.ID = l_line_id
1311: AND a.ID = b.cle_id
1312: AND a.sts_code = c.code
1313: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 6701: FROM oks_k_lines_b

6697: --bug start 3736860
6698: CURSOR get_oks_line_dtls (p_id NUMBER)
6699: IS
6700: SELECT ID, object_version_number
6701: FROM oks_k_lines_b
6702: WHERE cle_id = p_id;
6703:
6704: CURSOR l_bill_tax_csr (p_cle_id NUMBER)
6705: IS

Line 7529: FROM oks_k_lines_b ksl, oks_k_lines_b ksl1

7525:
7526: CURSOR l_cov_csr (p_cle_id NUMBER)
7527: IS
7528: SELECT ksl1.inheritance_type
7529: FROM oks_k_lines_b ksl, oks_k_lines_b ksl1
7530: WHERE ksl.cle_id = p_cle_id AND ksl1.cle_id = ksl.coverage_id;
7531:
7532: --level element id
7533: CURSOR l_rule_csr (p_cle_id NUMBER)

Line 7560: FROM oks_k_lines_b

7556: -- bug start 3736860
7557: CURSOR get_oks_line_dtls (p_id NUMBER)
7558: IS
7559: SELECT ID, object_version_number
7560: FROM oks_k_lines_b
7561: WHERE cle_id = p_id;
7562:
7563: CURSOR l_bill_tax_csr (p_cle_id NUMBER)
7564: IS

Line 8198: UPDATE oks_k_lines_b

8194: SET estimated_amount = estimated_amount + l_newamt
8195: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
8196:
8197: -- Update topline tax amount
8198: UPDATE oks_k_lines_b
8199: SET tax_amount = tax_amount + l_newtax
8200: WHERE cle_id = l_lineid;
8201:
8202: -- Update header tax amount

Line 9220: FROM oks_k_lines_b LN, okc_k_lines_b kl, oks_k_lines_b ks

9216: IS
9217: CURSOR l_cov_csr (p_cle_id NUMBER)
9218: IS
9219: SELECT LN.transfer_option
9220: FROM oks_k_lines_b LN, okc_k_lines_b kl, oks_k_lines_b ks
9221: WHERE kl.ID = p_cle_id
9222: AND ks.cle_id = kl.ID
9223: AND LN.cle_id = ks.coverage_id;
9224:

Line 10028: FROM okc_k_lines_b okc, oks_k_lines_b oks

10024: IS
10025: CURSOR l_line_rule_csr (p_line_id NUMBER)
10026: IS
10027: SELECT oks.acct_rule_id, okc.inv_rule_id, okc.price_list_id
10028: FROM okc_k_lines_b okc, oks_k_lines_b oks
10029: WHERE okc.ID = p_line_id AND oks.cle_id = okc.ID;
10030:
10031: CURSOR l_party_csr (p_id NUMBER)
10032: IS

Line 12408: UPDATE oks_k_lines_b

12404: AND dnz_chr_id =
12405: l_merge_chr_id)
12406: WHERE ID = l_merge_line_id;
12407:
12408: UPDATE oks_k_lines_b
12409: SET tax_amount =
12410: NVL (tax_amount, 0)
12411: + NVL ((SELECT tax_amount
12412: FROM oks_k_lines_b

Line 12412: FROM oks_k_lines_b

12408: UPDATE oks_k_lines_b
12409: SET tax_amount =
12410: NVL (tax_amount, 0)
12411: + NVL ((SELECT tax_amount
12412: FROM oks_k_lines_b
12413: WHERE cle_id =
12414: l_subline_id),
12415: 0
12416: )

Line 12440: FROM oks_k_lines_b

12436: UPDATE oks_k_headers_b
12437: SET tax_amount =
12438: NVL (tax_amount, 0)
12439: + NVL ((SELECT tax_amount
12440: FROM oks_k_lines_b
12441: WHERE cle_id =
12442: l_subline_id),
12443: 0
12444: )

Line 12663: UPDATE oks_k_lines_b

12659: THEN
12660: RAISE g_exception_halt_validation;
12661: END IF;
12662:
12663: UPDATE oks_k_lines_b
12664: SET coverage_id = l_coverage_id,
12665: standard_cov_yn = 'N'
12666: WHERE cle_id = l_line_id;
12667: END IF;

Line 12947: UPDATE oks_k_lines_b

12943: AND dnz_chr_id =
12944: l_merge_chr_id)
12945: WHERE ID = l_line_id;
12946:
12947: UPDATE oks_k_lines_b
12948: SET tax_amount =
12949: NVL (tax_amount, 0)
12950: + NVL ((SELECT tax_amount
12951: FROM oks_k_lines_b

Line 12951: FROM oks_k_lines_b

12947: UPDATE oks_k_lines_b
12948: SET tax_amount =
12949: NVL (tax_amount, 0)
12950: + NVL ((SELECT tax_amount
12951: FROM oks_k_lines_b
12952: WHERE cle_id =
12953: l_subline_id),
12954: 0
12955: )

Line 12979: FROM oks_k_lines_b

12975: UPDATE oks_k_headers_b
12976: SET tax_amount =
12977: NVL (tax_amount, 0)
12978: + NVL ((SELECT tax_amount
12979: FROM oks_k_lines_b
12980: WHERE cle_id =
12981: l_subline_id),
12982: 0
12983: )

Line 13260: UPDATE oks_k_lines_b

13256: THEN
13257: RAISE g_exception_halt_validation;
13258: END IF;
13259:
13260: UPDATE oks_k_lines_b
13261: SET coverage_id = l_coverage_id,
13262: standard_cov_yn = 'N'
13263: WHERE cle_id = l_line_id;
13264: END IF;

Line 13443: UPDATE oks_k_lines_b

13439: WHERE cle_id = l_line_id
13440: AND dnz_chr_id = l_chr_id)
13441: WHERE ID = l_line_id;
13442:
13443: UPDATE oks_k_lines_b
13444: SET tax_amount =
13445: NVL (tax_amount, 0)
13446: + NVL ((SELECT tax_amount
13447: FROM oks_k_lines_b

Line 13447: FROM oks_k_lines_b

13443: UPDATE oks_k_lines_b
13444: SET tax_amount =
13445: NVL (tax_amount, 0)
13446: + NVL ((SELECT tax_amount
13447: FROM oks_k_lines_b
13448: WHERE cle_id = l_subline_id), 0)
13449: WHERE cle_id = l_line_id;
13450:
13451: UPDATE okc_k_headers_b

Line 13468: FROM oks_k_lines_b

13464: UPDATE oks_k_headers_b
13465: SET tax_amount =
13466: NVL (tax_amount, 0)
13467: + NVL ((SELECT tax_amount
13468: FROM oks_k_lines_b
13469: WHERE cle_id = l_subline_id), 0)
13470: WHERE chr_id = l_chr_id;
13471:
13472: IF p_kdtl_tbl (l_ctr).lse_id <> 18

Line 14595: FROM oks_k_lines_b LN, oks_k_lines_b kl

14591: -- Cursor to check cov attribute set
14592: CURSOR l_cov_csr (p_cle_id NUMBER)
14593: IS
14594: SELECT KL.sync_date_install
14595: FROM oks_k_lines_b LN, oks_k_lines_b kl
14596: WHERE LN.cle_id = p_cle_id AND kl.cle_id = LN.coverage_id;
14597:
14598: -- Cursor to check SR logged
14599: CURSOR l_checksr_csr (

Line 14654: FROM oks_k_lines_b

14650: --mmadhavi bug 3761489
14651: CURSOR get_oks_line_dtls (p_id NUMBER)
14652: IS
14653: SELECT ID, object_version_number
14654: FROM oks_k_lines_b
14655: WHERE cle_id = p_id;
14656:
14657: --mmadhavi bug 3761489
14658: CURSOR l_serv_csr (p_serv_line_id NUMBER)

Line 15829: UPDATE oks_k_lines_b

15825: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
15826: and date_cancelled is null)
15827: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
15828:
15829: UPDATE oks_k_lines_b
15830: SET tax_amount =
15831: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
15832: FROM oks_k_lines_b
15833: WHERE cle_id IN ( SELECT id

Line 15832: FROM oks_k_lines_b

15828:
15829: UPDATE oks_k_lines_b
15830: SET tax_amount =
15831: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
15832: FROM oks_k_lines_b
15833: WHERE cle_id IN ( SELECT id
15834: FROM okc_k_lines_b
15835: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
15836: AND lse_id IN (9,25)

Line 15852: FROM oks_k_lines_b

15848:
15849:
15850: UPDATE oks_k_headers_b
15851: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
15852: FROM oks_k_lines_b
15853: WHERE cle_id IN (SELECT id
15854: FROM okc_k_lineS_b
15855: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
15856: AND date_cancelled IS NULL

Line 16303: UPDATE oks_k_lines_b

16299: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16300: AND date_cancelled is NULL)
16301: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
16302:
16303: UPDATE oks_k_lines_b
16304: SET tax_amount =
16305: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16306: FROM oks_k_lines_b
16307: WHERE cle_id IN ( SELECT id

Line 16306: FROM oks_k_lines_b

16302:
16303: UPDATE oks_k_lines_b
16304: SET tax_amount =
16305: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16306: FROM oks_k_lines_b
16307: WHERE cle_id IN ( SELECT id
16308: FROM okc_k_lines_b
16309: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16310: AND lse_id IN (9,25)

Line 16331: FROM oks_k_lines_b

16327: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16328:
16329: UPDATE oks_k_headers_b
16330: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16331: FROM oks_k_lines_b
16332: WHERE cle_id IN (SELECT id
16333: FROM okc_k_lineS_b
16334: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16335: AND date_cancelled IS NULL

Line 16516: UPDATE oks_k_lines_b

16512: p_kdtl_tbl (l_ctr).hdr_id
16513: AND date_cancelled IS NULL)
16514: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
16515:
16516: UPDATE oks_k_lines_b
16517: SET tax_amount =
16518: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16519: FROM oks_k_lines_b
16520: WHERE cle_id IN ( SELECT id

Line 16519: FROM oks_k_lines_b

16515:
16516: UPDATE oks_k_lines_b
16517: SET tax_amount =
16518: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16519: FROM oks_k_lines_b
16520: WHERE cle_id IN ( SELECT id
16521: FROM okc_k_lines_b
16522: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16523: AND lse_id IN (9,25)

Line 16545: FROM oks_k_lines_b

16541:
16542:
16543: UPDATE oks_k_headers_b
16544: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16545: FROM oks_k_lines_b
16546: WHERE cle_id IN (SELECT id
16547: FROM okc_k_lineS_b
16548: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16549: AND date_cancelled IS NULL