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

Line 207: FROM okc_k_lines_b

203:
204: CURSOR get_hdr_count
205: IS
206: SELECT COUNT (*)
207: FROM okc_k_lines_b
208: WHERE dnz_chr_id = p_id
209: AND lse_id IN (9, 18, 25);
210:
211: CURSOR get_line_count

Line 214: FROM okc_k_lines_b

210:
211: CURSOR get_line_count
212: IS
213: SELECT COUNT (*)
214: FROM okc_k_lines_b
215: WHERE cle_id = p_id AND lse_id IN (9, 18, 25);
216: l_temp_count NUMBER := 0;
217: l_count NUMBER := 0;
218: BEGIN

Line 260: From OKc_k_lines_b

256:
257:
258: Cursor l_lse_csr is
259: Select lse_id
260: From OKc_k_lines_b
261: Where id = p_line_id;
262:
263: Cursor l_prodSys_name_csr
264: Is

Line 460: FROM okc_k_lines_b Kl

456: Ks.price_uom,
457: Kh.period_start,
458: Kh.period_type
459:
460: FROM okc_k_lines_b Kl
461: ,Oks_k_headers_b Kh
462: ,oks_k_lines_b Ks
463:
464: WHERE Kl.ID = p_line_id

Line 630: , Okc_k_lines_b Kl

626: Select nvl(sum(bill.amount),0)
627: From Oks_bill_sub_lines bill
628: , Oks_instance_history ih
629: , Oks_inst_hist_details id
630: , Okc_k_lines_b Kl
631: , Oks_bill_cont_lines bcl
632: Where ih.batch_id = p_batch_id
633: And id.ins_id = ih.id
634: And bill.cle_id = Kl.Id

Line 645: From Okc_k_lines_b kl

641: And nvl(bcl.btn_id,0) <> -44;
642:
643: Cursor l_Hdr_credit_csr Is
644: Select nvl(sum(bill.amount),0)
645: From Okc_k_lines_b kl
646: , Oks_bill_sub_lines bill
647: , Oks_instance_history ih
648: , Oks_inst_hist_details id
649: , Oks_bill_cont_lines bcl

Line 722: , Okc_k_lines_b Kl

718: Select nvl(sum(bill.amount),0)
719: From Oks_bill_sub_lines bill
720: , Oks_instance_history ih
721: , Oks_inst_hist_details id
722: , Okc_k_lines_b Kl
723: , Oks_bill_cont_lines bcl
724: Where ih.batch_id = p_batch_id
725: And id.ins_id = ih.id
726: And bill.cle_id = Kl.Id

Line 735: From Okc_k_lines_b kl

731: And bcl.bill_action = 'RI';
732:
733: Cursor l_Hdr_billed_csr Is
734: Select nvl(sum(bill.amount),0)
735: From Okc_k_lines_b kl
736: , Oks_bill_sub_lines bill
737: , Oks_instance_history ih
738: , Oks_inst_hist_details id
739: , Oks_bill_cont_lines bcl

Line 818: , okc_k_lines_b kl

814: Cursor l_chr_csr Is
815: Select authoring_org_id,
816: inv_organization_id
817: From okc_k_headers_all_b kh
818: , okc_k_lines_b kl
819: Where kl.id = p_line_id
820: And kh.id = kl.dnz_chr_id;
821:
822: l_org_id Number;

Line 1215: From Okc_k_lines_b

1211: P_line_End_date Date
1212: ) return Number Is
1213: Cursor l_line_csr Is
1214: Select end_date
1215: From Okc_k_lines_b
1216: Where id = p_line_id;
1217:
1218: Begin
1219:

Line 1431: , OKC_K_LINES_B KL

1427: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, kl.end_date)
1428:
1429: From OKC_K_ITEMS KI
1430: , OKC_K_HEADERS_all_B KH
1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp
1434: , OKS_K_LINES_B KS
1435: , OKS_K_LINES_B KS1

Line 1486: , OKC_K_LINES_B KL

1482: , 0
1483: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1484: From OKC_K_ITEMS KI
1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp
1489: , OKC_STATUSES_B HST
1490: Where tmp.parent_id = p_batch_id

Line 1538: ,OKC_K_LINES_B KL

1534: , 0
1535: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1536: From OKC_K_ITEMS KI
1537: ,OKC_K_HEADERS_ALL_B KH
1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc
1541: , Oks_Instance_k_dtls_temp tmp
1542: , OKC_STATUSES_B HST

Line 1592: , OKC_K_LINES_B KL

1588: , 0
1589: , null
1590: From OKC_K_ITEMS_V KI
1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS
1595: , Oks_k_lines_b KS1
1596: , Oks_Instance_k_dtls_temp tmp

Line 1985: From OKC_K_LINES_B

1981: , X_date OUT NOCOPY Date
1982: ) Is
1983: Cursor l_Term_subline_csr Is
1984: Select max(date_terminated)
1985: From OKC_K_LINES_B
1986: Where cle_id = p_line_id
1987: and lse_id in (8,7,9,10,11,18,13,25,35)
1988: having Count(*) = count(decode(date_terminated, null, null, 'x')) ;
1989:

Line 1992: From OKC_K_LINES_B

1988: having Count(*) = count(decode(date_terminated, null, null, 'x')) ;
1989:
1990: Cursor l_term_topline_csr Is
1991: Select max(date_terminated)
1992: From OKC_K_LINES_B
1993: Where dnz_chr_id = p_line_id
1994: and lse_id in (1,12,14,19)
1995: having Count(*) = count(decode(date_terminated, null, null, 'x'));
1996:

Line 1999: From OKC_K_LINES_B

1995: having Count(*) = count(decode(date_terminated, null, null, 'x'));
1996:
1997: Cursor l_Cancel_subline_csr Is
1998: Select max(date_cancelled)
1999: From OKC_K_LINES_B
2000: Where cle_id = p_line_id
2001: and lse_id in (8,7,9,10,11,18,13,25,35)
2002: having count(*) = Count(decode(term_cancel_source,'IBTRANSFER','x','IBTERMINATE','x','IBRETURN','x',null))
2003: and Count(*) = count(decode(date_cancelled, null, null, 'x')) ;

Line 2007: From OKC_K_LINES_B

2003: and Count(*) = count(decode(date_cancelled, null, null, 'x')) ;
2004:
2005: Cursor l_Cancel_topline_csr Is
2006: Select max(date_cancelled)
2007: From OKC_K_LINES_B
2008: Where dnz_chr_id = p_line_id
2009: and lse_id in (1,12,14,19)
2010: having count(*) = Count(decode(term_cancel_source,'IBTRANSFER','x','IBTERMINATE','x','IBRETURN','x',null))
2011: and Count(*) = count(decode(date_cancelled, null, null, 'x'));

Line 2145: okc_k_lines_b ksl

2141: kh.authoring_org_id org_id,
2142: kh.inv_organization_id
2143: FROM okc_k_party_roles_b prl,
2144: okc_k_headers_all_b kh,
2145: okc_k_lines_b ksl
2146: WHERE ksl.ID = p_line_id
2147: AND ksl.dnz_chr_id = kh.ID
2148: AND prl.dnz_chr_id = kh.ID
2149: AND prl.chr_id IS NOT NULL

Line 2244: FROM okc_k_lines_b sl,

2240: CURSOR l_get_attr_csr IS
2241: SELECT csi.OWNER_PARTY_ID old_party_id,
2242: tls1.TRANSFER_OPTION transfer_option
2243:
2244: FROM okc_k_lines_b sl,
2245: oks_k_lines_b tls,
2246: oks_k_lines_b tls1,
2247: okc_k_items im,
2248: csi_item_instances csi

Line 2342: From OKC_K_LINES_B Kl, OKc_k_lines_b Kl1

2338:
2339: ) return Date Is
2340: Cursor l_line_csr Is
2341: Select max(Kl.date_renewed)
2342: From OKC_K_LINES_B Kl, OKc_k_lines_b Kl1
2343: Where Kl1.id = p_line_id
2344: and Kl.cle_id = Kl1.cle_id
2345: And Kl.lse_id in (8,7,9,10,11,13,35, 18, 25)
2346: having Count(*) = count(decode(kl.date_renewed, null, null, 'x')) ;

Line 2370: From OKC_K_LINES_B Kl, Okc_k_lines_b Kl1

2366:
2367: ) return Date Is
2368: Cursor l_line_csr Is
2369: Select max(Kl.date_renewed)
2370: From OKC_K_LINES_B Kl, Okc_k_lines_b Kl1
2371: Where Kl1.Id = p_line_id
2372: And Kl.dnz_chr_id = Kl1.dnz_chr_id
2373: and Kl.lse_id in (1,12,19)
2374: having Count(*) = count(decode(Kl.date_renewed, null, null, 'x')) ;

Line 2404: having count() = (select count() from Okc_k_lines_b

2400: IS
2401: SELECT max(date_terminated)
2402: FROM oks_Instance_k_dtls_temp temp
2403: where topline_id = p_Line_id
2404: having count(*) = (select count(*) from Okc_k_lines_b
2405: WHERE cle_id = p_line_id AND lse_id IN (8,7,9,10,11,13,35, 18, 25)
2406: );
2407:
2408:

Line 2419: From OKC_K_LINES_B line

2415:
2416:
2417: Cursor l_term_topline_csr Is
2418: Select max(line.date_terminated)
2419: From OKC_K_LINES_B line
2420: Where line.cle_id= p_line_id
2421: and line.lse_id in (8,7,9,10,11,13,18,25,35)
2422: And line.id not in (select subline_id from oks_instance_k_dtls_temp where topline_id = p_line_id)
2423: having Count(line.id) = count(decode(line.date_terminated, null, null, 'x'));

Line 2432: having count() = (select count() from Okc_k_lines_b

2428: IS
2429: SELECT max(date_terminated)
2430: FROM oks_Instance_k_dtls_temp
2431: where contract_id = p_Line_id
2432: having count(*) = (select count(*) from Okc_k_lines_b
2433: WHERE dnz_chr_id= p_line_id AND lse_id IN (8,7,9,10,11,13,35, 18, 25)
2434: );
2435:
2436:

Line 2449: From OKC_K_LINES_B line

2445:
2446:
2447: Cursor l_term_Hdr_csr Is
2448: Select max(line.date_terminated)
2449: From OKC_K_LINES_B line
2450: Where line.dnz_chr_id= p_line_id
2451: and line.lse_id in (8,7,9,10,11,13,18,25,35)
2452: And line.id not in (select subline_id from oks_instance_k_dtls_temp where Contract_id = p_line_id)
2453: having Count(*) = count(decode(line.date_terminated, null, null, 'x'));