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

Line 373: FROM okc_k_lines_b lines

369: where job = l_job;
370:
371: cursor l_check_mig_csr is
372: select 'x'
373: FROM okc_k_lines_b lines
374: where lines.lse_id = 19
375: and ( exists ( select 1 from okc_k_rel_objs rel
376: where rel.cle_id = lines.id )
377: or

Line 379: okc_k_lines_b line2

375: and ( exists ( select 1 from okc_k_rel_objs rel
376: where rel.cle_id = lines.id )
377: or
378: exists ( select 1 from okc_k_rel_objs rel2 ,
379: okc_k_lines_b line2
380: where line2.cle_id = lines.id
381: and rel2.cle_id = line2.id
382: and line2.lse_id = 25 )
383: )

Line 487: From okc_k_lines_b ln

483: ,hdr.CURRENCY_CODE
484: ,hdr.AUTHORING_ORG_ID
485: From OKC_K_HEADERS_B hdr
486: Where exists (Select 1
487: From okc_k_lines_b ln
488: ,oks_bill_cont_lines bcl
489: Where hdr.id = ln.dnz_chr_id
490: and ln.id = bcl.cle_id );
491:

Line 499: ,OKC_K_LINES_B kln

495: ,bcl.CLE_ID LineID
496: ,bcl.AMOUNT Amount
497: ,bcl.CURRENCY_CODE
498: From OKS_BILL_CONT_LINES bcl
499: ,OKC_K_LINES_B kln
500: Where kln.DNZ_CHR_ID = p_dnz_chr_id
501: and bcl.CLE_ID = kln.ID
502: and bcl.BTN_ID is Null
503: and bcl.BILL_ACTION = 'RI' for update;

Line 549: from OKC_K_LINES_B kln

545:
546: Update OKS_BILL_CONT_LINES
547: Set CURRENCY_CODE = l_cont_rec.CURRENCY_CODE
548: Where CLE_ID in (select kln.ID
549: from OKC_K_LINES_B kln
550: Where kln.DNZ_CHR_ID = l_cont_rec.ID )
551: And BTN_ID is Not Null;
552:
553:

Line 623: from OKC_K_LINES_B kln

619:
620: Update OKS_BILL_CONT_LINES
621: Set CURRENCY_CODE = l_cont_rec.CURRENCY_CODE
622: Where CLE_ID in (select kln.ID
623: from OKC_K_LINES_B kln
624: Where kln.DNZ_CHR_ID = l_cont_rec.ID )
625: And BTN_ID is Null;
626:
627: -- dbms_output.put_line('After Updating the bill cont lines for Contract- BTN ID null'||l_cont_rec.ID) ;

Line 696: FROM okc_k_lines_b lines,okc_rule_groups_b rgp

692: SELECT lines.id,lines.lse_id lse_id,lines.cle_id,lines.dnz_chr_id,
693: lines.start_date,NVL(lines.date_terminated,lines.end_date) end_date,
694: lines.date_terminated,
695: rgp.id rgp_id
696: FROM okc_k_lines_b lines,okc_rule_groups_b rgp
697: WHERE lines.dnz_chr_id = rgp.dnz_chr_id
698: AND lines.id = rgp.cle_id
699: AND lines.lse_id IN (1,12,19)
700: and lines.id = p_cle_id;

Line 708: FROM okc_k_lines_b lines

704: CURSOR line_grp_csr (p_cle_id NUMBER) IS
705: SELECT lines.id,lines.lse_id lse_id,lines.cle_id,lines.dnz_chr_id,
706: lines.start_date,NVL(lines.date_terminated,lines.end_date) end_date,
707: lines.date_terminated
708: FROM okc_k_lines_b lines
709: WHERE lines.cle_id = p_cle_id
710: AND lines.lse_id in (7,8,9,10,11,13,18,25,35);
711:
712:

Line 1147: from okc_k_lines_b where cle_id = pl_top_line_id and lse_id = 25;

1143:
1144:
1145: cursor l_price_csr(pl_top_line_id in number) is
1146: select sum(nvl(price_negotiated , 0))
1147: from okc_k_lines_b where cle_id = pl_top_line_id and lse_id = 25;
1148:
1149:
1150: cursor l_sub_line_csr (p_top_line_id in number ) is
1151: select lines.id sub_line_id

Line 1156: from okc_k_lines_b lines

1152: ,lines.start_date sub_line_start_date
1153: ,lines.end_date sub_line_end_date
1154: ,lines.date_terminated sub_line_date_terminated
1155: ,lines.price_negotiated sub_line_price_negotiated
1156: from okc_k_lines_b lines
1157: where lines.cle_id = p_top_line_id
1158: AND lines.lse_id = 25;
1159:
1160: l_sub_line_rec l_sub_line_csr%rowtype ;

Line 1265: FROM okc_k_lines_b lines,

1261: SELECT lines.id id,lines.lse_id lse_id,lines.dnz_chr_id dnz_chr_id,
1262: lines.start_date start_date,NVL(lines.date_terminated,lines.end_date) end_date,
1263: lines.date_terminated date_terminated,lines.upg_orig_system_ref upg_orig_system_ref,
1264: lines.upg_orig_system_ref_id upg_orig_system_ref_id
1265: FROM okc_k_lines_b lines,
1266: okc_k_headers_b hdr,
1267: okc_statuses_b sta
1268: where hdr.id BETWEEN p_chr_id_lo AND p_chr_id_hi
1269: and sta.ste_code not in ('TERMINATED','ENTERED','CANCELLED')

Line 1280: okc_k_lines_b line2

1276: and ( exists ( select 1 from okc_k_rel_objs rel
1277: where rel.cle_id = lines.id )
1278: or
1279: exists ( select 1 from okc_k_rel_objs rel2 ,
1280: okc_k_lines_b line2
1281: where line2.cle_id = lines.id
1282: and rel2.cle_id = line2.id
1283: and line2.lse_id = 25 ) );
1284:

Line 1420: FROM okc_k_lines_b lines,

1416: CURSOR top_line_grp_csr IS
1417: SELECT lines.id id,lines.lse_id lse_id,lines.cle_id cle_id,lines.dnz_chr_id,
1418: lines.start_date start_date,NVL(lines.date_terminated,lines.end_date) end_date,
1419: lines.date_terminated date_terminated, rgp.id rgp_id, rul.object1_id1 inv_rul_id
1420: FROM okc_k_lines_b lines,
1421: okc_rule_groups_b rgp,
1422: okc_rules_b rul
1423: WHERE lines.id = rgp.cle_id
1424: AND lines.lse_id in (1,12,19)

Line 1471: FROM okc_k_lines_b lines

1467: CURSOR line_grp_csr (p_cle_id NUMBER) IS
1468: SELECT lines.id,lines.lse_id lse_id,lines.cle_id,lines.dnz_chr_id,
1469: lines.start_date,NVL(lines.date_terminated,lines.end_date) end_date,
1470: lines.date_terminated
1471: FROM okc_k_lines_b lines
1472: WHERE lines.cle_id = p_cle_id
1473: AND lines.lse_id in (7,8,9,10,11,13,18,25,35)
1474: and not exists ( select 1 from okc_k_rel_objs rel
1475: where rel.cle_id = lines.id );

Line 2055: FROM OKC_K_LINES_B LINE

2051:
2052:
2053: CURSOR L_LINES_CSR (P_DNZ_CHR_ID NUMBER )IS
2054: SELECT LINE.ID , LINE.START_DATE , LINE.END_DATE ,UPG_ORIG_SYSTEM_REF , LINE.DATE_TERMINATED
2055: FROM OKC_K_LINES_B LINE
2056: WHERE LINE.DNZ_CHR_ID = P_DNZ_CHR_ID
2057: AND LINE.LSE_ID = 19 ;
2058:
2059:

Line 2062: FROM OKC_K_LINES_B LINE

2058:
2059:
2060: CURSOR L_SUB_LINES_CSR (P_CLE_ID NUMBER )IS
2061: SELECT LINE.ID , LINE.START_DATE , LINE.END_DATE , PRICE_NEGOTIATED, UPG_ORIG_SYSTEM_REF , LINE.DATE_TERMINATED
2062: FROM OKC_K_LINES_B LINE
2063: WHERE LINE.CLE_ID = P_CLE_ID
2064: AND LINE.LSE_ID = 25 ;
2065:
2066: CURSOR L_GET_BCL_ID_CSR ( P_CLE_ID NUMBER ) IS

Line 2073: FROM OKC_K_LINES_B LINE

2069: WHERE CLE_ID = P_CLE_ID ;
2070:
2071: CURSOR L_LINE_AMT_CSR ( P_CLE_ID NUMBER ) IS
2072: SELECT SUM(PRICE_NEGOTIATED)
2073: FROM OKC_K_LINES_B LINE
2074: WHERE LINE.CLE_ID = P_CLE_ID
2075: AND LINE.LSE_ID = 25 ;
2076:
2077: CURSOR L_BCL_CONT_LINE_EXISTS_CSR ( P_CLE_ID NUMBER ) IS

Line 2189: update okc_k_lines_b

2185: values
2186: (lin_id, p_top_line_id , p_top_line_start_date, p_top_line_end_date, 'N',
2187: 1, 1, sysdate, 1, sysdate, 'RI', -44);
2188:
2189: update okc_k_lines_b
2190: set UPG_ORIG_SYSTEM_REF = NVL(p_top_line_UPG_ORIG_SYSTEM_REF, 'ORDER')
2191: where id = p_top_line_id;
2192:
2193: FOR L_SUB_LINES_REC IN L_SUB_LINES_CSR ( p_top_line_id )

Line 2211: update okc_k_lines_b

2207: OPEN L_GET_ORDER_NUMBER_CSR ( L_SUB_LINES_REC.ID );
2208: FETCH L_GET_ORDER_NUMBER_CSR INTO L_GET_ORDER_NUMBER_REC ;
2209: CLOSE L_GET_ORDER_NUMBER_CSR ;
2210:
2211: update okc_k_lines_b
2212: set UPG_ORIG_SYSTEM_REF = NVL(L_SUB_LINES_REC.UPG_ORIG_SYSTEM_REF, 'ORDER_LINE'),
2213: UPG_ORIG_SYSTEM_REF_ID = L_GET_ORDER_NUMBER_REC.OBJECT1_ID1
2214: where id = L_SUB_LINES_REC.ID;
2215: