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

Line 798: okc_k_lines_b CLE,

794: CURSOR C2 is
795: SELECT contract_number, contract_number_modifier,
796: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
797: FROM okc_k_headers_b CHR,
798: okc_k_lines_b CLE,
799: okc_statuses_b STE,
800: okc_operation_lines OLI1,
801: okc_operation_lines OLI2,
802: okc_operation_instances OIE1,

Line 863: from OKC_K_LINES_B CLE,

859: and CHR.date_renewed is NOT NULL;
860:
861: cursor c2 is
862: select distinct 'Y'
863: from OKC_K_LINES_B CLE,
864: okc_operation_lines OLI,
865: okc_operation_instances OIE,
866: okc_class_operations COP
867: where cle.id = oli.object_cle_id

Line 925: okc_k_lines_b CLE,

921:
922: CURSOR c2 IS
923: SELECT distinct 'Y'
924: FROM okc_k_headers_b CHR,
925: okc_k_lines_b CLE,
926: okc_statuses_b STS,
927: okc_operation_lines OLI1,
928: okc_operation_lines OLI2,
929: okc_operation_instances OIE1, --**

Line 1011: okc_k_lines_b CLE,

1007:
1008: CURSOR c2 IS
1009: SELECT distinct 'Y'
1010: FROM okc_k_headers_b CHR,
1011: okc_k_lines_b CLE,
1012: okc_statuses_b STS,
1013: okc_operation_lines OLI1,
1014: okc_operation_lines OLI2,
1015: okc_operation_instances OIE1, --**

Line 1187: from okc_k_lines_b

1183: -- end of bug#6144856 --
1184:
1185: cursor c_top_line_chk is
1186: select id
1187: from okc_k_lines_b
1188: where id=p_cle_id
1189: and cle_id is null;
1190:
1191: l_top_line number;

Line 1329: from okc_k_lines_b L

1325: IF (l_top_line is not null) THEN
1326: IF (l_type = 'ENTERED' and l_old_type = 'CANCELLED' ) THEN
1327: --Query modified as part of bugfix for 6525864
1328: open c_lines for select L.id,p_new_sts_code code, L.lse_id,L.object_version_number
1329: from okc_k_lines_b L
1330: where L.dnz_chr_id = p_id
1331: and (L.id = p_cle_id or
1332: L.cle_id = p_cle_id)
1333: and EXISTS (select 'x'

Line 1342: from okc_k_lines_b L

1338:
1339: ELSE
1340: --Query modified as part of bugfix for 6525864
1341: open c_lines for select L.id, p_new_sts_code code, L.lse_id,L.object_version_number
1342: from okc_k_lines_b L
1343: where L.dnz_chr_id = p_id
1344: and (L.id = p_cle_id or
1345: L.cle_id = p_cle_id)
1346: and EXISTS( select 'x'

Line 1356: from okc_k_lines_b L

1352:
1353: END IF;
1354: ELSE
1355: open c_lines for select L.id, p_new_sts_code code, L.lse_id,L.object_version_number
1356: from okc_k_lines_b L
1357: where L.id = p_cle_id
1358: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE
1359: END IF;
1360:

Line 1820: Select sts_code, start_date, end_date from okc_k_lines_b where id = p_id;

1816: cursor get_k_hdr_cur (p_id in number) is
1817: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;
1818:
1819: cursor get_k_line_cur(p_cle_id in number) is
1820: Select sts_code, start_date, end_date from okc_k_lines_b where id = p_id;
1821:
1822: begin
1823:
1824: l_new_sts_code := p_new_sts_code;

Line 1996: from okc_k_lines_b

1992: --Cursor to get topline id for a particular subline; For a topline this will return NULL
1993:
1994: Cursor get_line_lvl_csr is
1995: Select cle_id
1996: from okc_k_lines_b
1997: where id = p_cle_id
1998: and dnz_chr_id = p_id;
1999:
2000:

Line 2005: from okc_k_lines_b cle, oks_k_lines_b sle

2001: --Cursor to fetch tax_amount for a particular subline
2002:
2003: Cursor get_subline_tax_amt_csr (p_cle_id NUMBER) IS
2004: Select sle.tax_amount
2005: from okc_k_lines_b cle, oks_k_lines_b sle
2006: where cle.id = p_cle_id
2007: and cle.dnz_chr_id = p_id
2008: and cle.id = sle.cle_id
2009: and cle.dnz_chr_id = sle.dnz_chr_id;

Line 2015: from okc_k_lines_b cle, oks_k_lines_b sle

2011: --Cursor to add tax_amount of all the toplines
2012:
2013: Cursor get_hdr_tax_amt_csr IS
2014: select nvl(sum(nvl(tax_amount,0)),0)
2015: from okc_k_lines_b cle, oks_k_lines_b sle
2016: where cle.dnz_chr_id = p_id
2017: and cle.lse_id in (1, 12, 14, 19, 46)
2018: and cle.cle_id is null
2019: and cle.id = sle.cle_id

Line 2027: from okc_k_lines_b

2023: --Cursor to fectch lse_id of topline
2024:
2025: Cursor get_lse_id_csr (p_cle_id NUMBER) IS
2026: select lse_id
2027: from okc_k_lines_b
2028: where id=p_cle_id;
2029:
2030:
2031: --/*Added for bug:8775250*/

Line 2034: from okc_k_lines_b cle, oks_k_lines_b sle

2030:
2031: --/*Added for bug:8775250*/
2032: Cursor get_sub_tax_amt_csr (p_cle_id NUMBER) IS
2033: Select cle.id,sle.tax_amount
2034: from okc_k_lines_b cle, oks_k_lines_b sle
2035: where cle.cle_id = p_cle_id
2036: and cle.dnz_chr_id = p_id
2037: and cle.lse_id in (7, 8, 9, 10, 11, 13, 18, 25, 35)
2038: and cle.term_cancel_source IN ('MANUAL','CUSTOMER') ---modified condition for bug 12956286

Line 2044: from okc_k_lines_b cle,

2040: and cle.dnz_chr_id = sle.dnz_chr_id;
2041:
2042: Cursor get_subline_csr(p_cle_id NUMBER) IS
2043: Select okslb.id,okslb.cancelled_amount
2044: from okc_k_lines_b cle,
2045: okc_k_lines_b okslb
2046: where cle.id = p_cle_id
2047: and okslb.lse_id in (7, 8, 9, 10, 11, 13, 18, 25, 35)
2048: and okslb.cle_id =cle.id

Line 2045: okc_k_lines_b okslb

2041:
2042: Cursor get_subline_csr(p_cle_id NUMBER) IS
2043: Select okslb.id,okslb.cancelled_amount
2044: from okc_k_lines_b cle,
2045: okc_k_lines_b okslb
2046: where cle.id = p_cle_id
2047: and okslb.lse_id in (7, 8, 9, 10, 11, 13, 18, 25, 35)
2048: and okslb.cle_id =cle.id
2049: and okslb.date_cancelled is null;

Line 2053: from okc_k_lines_b oklb,

2049: and okslb.date_cancelled is null;
2050:
2051: Cursor get_lines_id(p_id number) IS
2052: select oklb.id,oklb.price_negotiated
2053: from okc_k_lines_b oklb,
2054: okc_k_headers_all_b okhb
2055: where oklb.chr_id = okhb.id
2056: and okhb.id = p_id
2057: and oklb.lse_id in (1,12,14,19,46);

Line 2261: from okc_k_lines_b cle, oks_k_lines_b sle

2257:
2258: Update oks_k_lines_b
2259: set tax_amount=
2260: (Select nvl(sum(nvl(tax_amount,0)),0)
2261: from okc_k_lines_b cle, oks_k_lines_b sle
2262: where cle.cle_id = p_cle_id
2263: and cle.lse_id in (7,8,9,10,11,18,25,35)
2264: and cle.dnz_chr_id = p_id
2265: and cle.id = sle.cle_id

Line 2310: from okc_k_lines_b

2306: set tax_amount = 0
2307: where dnz_chr_id = p_id
2308: and cle_id IN
2309: (select id
2310: from okc_k_lines_b
2311: where cle_id is null
2312: and dnz_chr_id = p_id
2313: and lse_id in (1, 12, 14, 19, 46)
2314: );

Line 2354: from oks_k_lines_b oks2, okc_k_lines_b okc2

2350: update oks_k_lines_b oks1
2351: set oks1.tax_amount =
2352: (
2353: select nvl(sum(nvl(tax_amount,0)),0)
2354: from oks_k_lines_b oks2, okc_k_lines_b okc2
2355: where oks2.cle_id = okc2.id
2356: and oks2.dnz_chr_id = okc2.dnz_chr_id
2357: and okc2.dnz_chr_id = p_id
2358: and okc2.cle_id = oks1.cle_id

Line 2364: from okc_k_lines_b okc1

2360: )
2361: where oks1.dnz_chr_id = p_id
2362: and oks1.cle_id IN
2363: (select id
2364: from okc_k_lines_b okc1
2365: where okc1.cle_id is null
2366: and okc1.lse_id in (1, 12, 14, 19) --removed 46 (subscription type)
2367: and okc1.dnz_chr_id = p_id
2368: and okc1.date_cancelled IS NULL -- Bug 5474479.

Line 2467: from okc_k_lines_b

2463: IS
2464:
2465: Cursor get_K_subscription_lines IS
2466: select id
2467: from okc_k_lines_b
2468: where cle_id is null
2469: and lse_id = 46
2470: and dnz_chr_id = p_id;
2471: