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 97: FROM okc_k_lines_b kl, oks_k_lines_b sl

93: l_shiporg_id NUMBER
94: )
95: IS
96: SELECT 'x'
97: FROM okc_k_lines_b kl, oks_k_lines_b sl
98: WHERE kl.ID = p_k_line_id
99: AND kl.ID = sl.cle_id
100: AND NVL (sl.acct_rule_id, -99) = NVL (l_acct_id, -99)
101: AND NVL (kl.inv_rule_id, -99) = NVL (l_inv_id, -99)

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

1315: a.bill_to_site_use_id, a.line_renewal_type_code,
1316: b.tax_code --Fix for bug 4121175
1317: ,
1318: b.price_uom
1319: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1320: WHERE a.ID = l_line_id AND a.ID = b.cle_id AND a.sts_code = c.code;
1321:
1322: CURSOR service_item (l_line_id NUMBER)
1323: IS

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

1345: l_price_uom VARCHAR2
1346: )
1347: IS
1348: SELECT a.ID
1349: FROM okc_k_lines_b a, oks_k_lines_b b, okc_statuses_b c
1350: WHERE a.ID = l_line_id
1351: AND a.ID = b.cle_id
1352: AND a.sts_code = c.code
1353: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 6869: FROM oks_k_lines_b

6865: --bug start 3736860
6866: CURSOR get_oks_line_dtls (p_id NUMBER)
6867: IS
6868: SELECT ID, object_version_number
6869: FROM oks_k_lines_b
6870: WHERE cle_id = p_id;
6871:
6872: CURSOR l_bill_tax_csr (p_cle_id NUMBER)
6873: IS

Line 7710: FROM oks_k_lines_b ksl, oks_k_lines_b ksl1

7706:
7707: CURSOR l_cov_csr (p_cle_id NUMBER)
7708: IS
7709: SELECT ksl1.inheritance_type
7710: FROM oks_k_lines_b ksl, oks_k_lines_b ksl1
7711: WHERE ksl.cle_id = p_cle_id AND ksl1.cle_id = ksl.coverage_id;
7712:
7713: --level element id
7714: CURSOR l_rule_csr (p_cle_id NUMBER)

Line 7741: FROM oks_k_lines_b

7737: -- bug start 3736860
7738: CURSOR get_oks_line_dtls (p_id NUMBER)
7739: IS
7740: SELECT ID, object_version_number
7741: FROM oks_k_lines_b
7742: WHERE cle_id = p_id;
7743:
7744: CURSOR l_bill_tax_csr (p_cle_id NUMBER)
7745: IS

Line 8064: FROM okc_k_lines_b okcl, oks_k_lines_b oksl

8060: /* Code added for Bug#14829043 */
8061: BEGIN
8062: SELECT okcl.price_unit,oksl.price_uom
8063: INTO l_covd_rec.list_price, l_covd_rec.price_uom
8064: FROM okc_k_lines_b okcl, oks_k_lines_b oksl
8065: WHERE okcl.id = p_kdtl_tbl (l_ctr).object_line_id
8066: AND okcl.id = oksl.cle_id;
8067: EXCEPTION WHEN OTHERS THEN
8068: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 8416: UPDATE oks_k_lines_b

8412: SET estimated_amount = estimated_amount + l_newamt
8413: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
8414:
8415: -- Update topline tax amount
8416: UPDATE oks_k_lines_b
8417: SET tax_amount = tax_amount + l_newtax
8418: WHERE cle_id = l_lineid;
8419:
8420: -- Update header tax amount

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

9447: IS
9448: CURSOR l_cov_csr (p_cle_id NUMBER)
9449: IS
9450: SELECT LN.transfer_option
9451: FROM oks_k_lines_b LN, okc_k_lines_b kl, oks_k_lines_b ks
9452: WHERE kl.ID = p_cle_id
9453: AND ks.cle_id = kl.ID
9454: AND LN.cle_id = ks.coverage_id;
9455:

Line 10276: FROM okc_k_lines_b okc, oks_k_lines_b oks

10272: IS
10273: CURSOR l_line_rule_csr (p_line_id NUMBER)
10274: IS
10275: SELECT oks.acct_rule_id, okc.inv_rule_id, okc.price_list_id
10276: FROM okc_k_lines_b okc, oks_k_lines_b oks
10277: WHERE okc.ID = p_line_id AND oks.cle_id = okc.ID;
10278:
10279: CURSOR l_party_csr (p_id NUMBER)
10280: IS

Line 12656: UPDATE oks_k_lines_b

12652: AND dnz_chr_id =
12653: l_merge_chr_id)
12654: WHERE ID = l_merge_line_id;
12655:
12656: UPDATE oks_k_lines_b
12657: SET tax_amount =
12658: NVL (tax_amount, 0)
12659: + NVL ((SELECT tax_amount
12660: FROM oks_k_lines_b

Line 12660: FROM oks_k_lines_b

12656: UPDATE oks_k_lines_b
12657: SET tax_amount =
12658: NVL (tax_amount, 0)
12659: + NVL ((SELECT tax_amount
12660: FROM oks_k_lines_b
12661: WHERE cle_id =
12662: l_subline_id),
12663: 0
12664: )

Line 12688: FROM oks_k_lines_b

12684: UPDATE oks_k_headers_b
12685: SET tax_amount =
12686: NVL (tax_amount, 0)
12687: + NVL ((SELECT tax_amount
12688: FROM oks_k_lines_b
12689: WHERE cle_id =
12690: l_subline_id),
12691: 0
12692: )

Line 12919: UPDATE oks_k_lines_b

12915: THEN
12916: RAISE g_exception_halt_validation;
12917: END IF;
12918:
12919: UPDATE oks_k_lines_b
12920: SET coverage_id = l_coverage_id,
12921: standard_cov_yn = 'N'
12922: WHERE cle_id = l_line_id;
12923: END IF;

Line 13203: UPDATE oks_k_lines_b

13199: AND dnz_chr_id =
13200: l_merge_chr_id)
13201: WHERE ID = l_line_id;
13202:
13203: UPDATE oks_k_lines_b
13204: SET tax_amount =
13205: NVL (tax_amount, 0)
13206: + NVL ((SELECT tax_amount
13207: FROM oks_k_lines_b

Line 13207: FROM oks_k_lines_b

13203: UPDATE oks_k_lines_b
13204: SET tax_amount =
13205: NVL (tax_amount, 0)
13206: + NVL ((SELECT tax_amount
13207: FROM oks_k_lines_b
13208: WHERE cle_id =
13209: l_subline_id),
13210: 0
13211: )

Line 13235: FROM oks_k_lines_b

13231: UPDATE oks_k_headers_b
13232: SET tax_amount =
13233: NVL (tax_amount, 0)
13234: + NVL ((SELECT tax_amount
13235: FROM oks_k_lines_b
13236: WHERE cle_id =
13237: l_subline_id),
13238: 0
13239: )

Line 13523: UPDATE oks_k_lines_b

13519: THEN
13520: RAISE g_exception_halt_validation;
13521: END IF;
13522:
13523: UPDATE oks_k_lines_b
13524: SET coverage_id = l_coverage_id,
13525: standard_cov_yn = 'N'
13526: WHERE cle_id = l_line_id;
13527: END IF;

Line 13706: UPDATE oks_k_lines_b

13702: WHERE cle_id = l_line_id
13703: AND dnz_chr_id = l_chr_id)
13704: WHERE ID = l_line_id;
13705:
13706: UPDATE oks_k_lines_b
13707: SET tax_amount =
13708: NVL (tax_amount, 0)
13709: + NVL ((SELECT tax_amount
13710: FROM oks_k_lines_b

Line 13710: FROM oks_k_lines_b

13706: UPDATE oks_k_lines_b
13707: SET tax_amount =
13708: NVL (tax_amount, 0)
13709: + NVL ((SELECT tax_amount
13710: FROM oks_k_lines_b
13711: WHERE cle_id = l_subline_id), 0)
13712: WHERE cle_id = l_line_id;
13713:
13714: UPDATE okc_k_headers_b

Line 13731: FROM oks_k_lines_b

13727: UPDATE oks_k_headers_b
13728: SET tax_amount =
13729: NVL (tax_amount, 0)
13730: + NVL ((SELECT tax_amount
13731: FROM oks_k_lines_b
13732: WHERE cle_id = l_subline_id), 0)
13733: WHERE chr_id = l_chr_id;
13734:
13735: IF p_kdtl_tbl (l_ctr).lse_id <> 18

Line 14880: FROM oks_k_lines_b LN, oks_k_lines_b kl

14876: -- Cursor to check cov attribute set
14877: CURSOR l_cov_csr (p_cle_id NUMBER)
14878: IS
14879: SELECT KL.sync_date_install
14880: FROM oks_k_lines_b LN, oks_k_lines_b kl
14881: WHERE LN.cle_id = p_cle_id AND kl.cle_id = LN.coverage_id;
14882:
14883: -- Cursor to check SR logged
14884: CURSOR l_checksr_csr (

Line 14939: FROM oks_k_lines_b

14935: --mmadhavi bug 3761489
14936: CURSOR get_oks_line_dtls (p_id NUMBER)
14937: IS
14938: SELECT ID, object_version_number
14939: FROM oks_k_lines_b
14940: WHERE cle_id = p_id;
14941:
14942: --mmadhavi bug 3761489
14943: CURSOR l_serv_csr (p_serv_line_id NUMBER)

Line 16127: UPDATE oks_k_lines_b

16123: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16124: and date_cancelled is null)
16125: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
16126:
16127: UPDATE oks_k_lines_b
16128: SET tax_amount =
16129: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16130: FROM oks_k_lines_b
16131: WHERE cle_id IN ( SELECT id

Line 16130: FROM oks_k_lines_b

16126:
16127: UPDATE oks_k_lines_b
16128: SET tax_amount =
16129: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16130: FROM oks_k_lines_b
16131: WHERE cle_id IN ( SELECT id
16132: FROM okc_k_lines_b
16133: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16134: AND lse_id IN (9,25)

Line 16150: FROM oks_k_lines_b

16146:
16147:
16148: UPDATE oks_k_headers_b
16149: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16150: FROM oks_k_lines_b
16151: WHERE cle_id IN (SELECT id
16152: FROM okc_k_lineS_b
16153: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16154: AND date_cancelled IS NULL

Line 16601: UPDATE oks_k_lines_b

16597: AND dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16598: AND date_cancelled is NULL)
16599: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
16600:
16601: UPDATE oks_k_lines_b
16602: SET tax_amount =
16603: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16604: FROM oks_k_lines_b
16605: WHERE cle_id IN ( SELECT id

Line 16604: FROM oks_k_lines_b

16600:
16601: UPDATE oks_k_lines_b
16602: SET tax_amount =
16603: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16604: FROM oks_k_lines_b
16605: WHERE cle_id IN ( SELECT id
16606: FROM okc_k_lines_b
16607: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16608: AND lse_id IN (9,25)

Line 16629: FROM oks_k_lines_b

16625: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16626:
16627: UPDATE oks_k_headers_b
16628: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16629: FROM oks_k_lines_b
16630: WHERE cle_id IN (SELECT id
16631: FROM okc_k_lineS_b
16632: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16633: AND date_cancelled IS NULL

Line 16814: UPDATE oks_k_lines_b

16810: p_kdtl_tbl (l_ctr).hdr_id
16811: AND date_cancelled IS NULL)
16812: WHERE ID = p_kdtl_tbl (l_ctr).service_line_id;
16813:
16814: UPDATE oks_k_lines_b
16815: SET tax_amount =
16816: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16817: FROM oks_k_lines_b
16818: WHERE cle_id IN ( SELECT id

Line 16817: FROM oks_k_lines_b

16813:
16814: UPDATE oks_k_lines_b
16815: SET tax_amount =
16816: (SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16817: FROM oks_k_lines_b
16818: WHERE cle_id IN ( SELECT id
16819: FROM okc_k_lines_b
16820: WHERE cle_id = p_kdtl_tbl (l_ctr).service_line_id
16821: AND lse_id IN (9,25)

Line 16843: FROM oks_k_lines_b

16839:
16840:
16841: UPDATE oks_k_headers_b
16842: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16843: FROM oks_k_lines_b
16844: WHERE cle_id IN (SELECT id
16845: FROM okc_k_lineS_b
16846: WHERE dnz_chr_id = p_kdtl_tbl (l_ctr).hdr_id
16847: AND date_cancelled IS NULL