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

Line 56: , okc_k_lines_b ocl';

52: ,org.name
53: ,okh.billed_at_source';
54:
55: l_from :=' FROM okc_k_headers_v okh,okc_k_party_roles_b okp,okx_parties_v oxp, hr_operating_units org,okc_assents_v oas
56: , okc_k_lines_b ocl';
57:
58: If p_ctr_rec.attribute in ('CONTRACT_START_DATE','CONTRACT_END_DATE') Then
59: IF p_ctr_rec.oie_id IS NOT NULL THEN
60:

Line 342: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln

338: -- Old Value: NULL (-9999)
339: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
340: l_stmt := l_select||' ,NULL old_value' ||
341: l_from||
342: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln
343: Where cln.dnz_chr_id = okh.id
344: AND cln.lse_id in(3,16,21)
345: AND cln.price_list_id is NULL)
346: AND okh.id = to_number(:update_level_value)';

Line 353: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

349: ELSIF p_ctr_rec.old_value = '-1111' THEN
350: l_old_value := p_ctr_rec.old_value;
351: l_stmt := l_select||' , :l_old_value old_value' ||
352: l_from||
353: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
354: Where cln.dnz_chr_id = okh.id
355: AND cln.lse_id in(3,16,21))
356: AND okh.id = to_number(:update_level_value)';
357:

Line 363: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

359: ELSE
360: l_old_value := p_ctr_rec.old_value;
361: l_stmt := l_select||' , :l_old_value old_value' ||
362: l_from||
363: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
364: Where cln.dnz_chr_id = okh.id
365: AND cln.lse_id in(3,16,21)
366: AND cln.price_list_id = to_number(:p_ctr_rec_old_value))
367: AND okh.id = to_number(:update_level_value)';

Line 983: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

979:
980: -- Old Value: NULL (-9999)
981: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
982: l_stmt := l_select||', NULL old_value'||
983: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
984: ' AND kl.dnz_chr_id = okh.id
985: AND kl.id = att.cle_id
986: And kl.lse_id in (4,17,22)
987: AND att.action_type_code = ''RSN''

Line 1003: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

999: ELSE
1000:
1001: l_old_value := p_ctr_rec.old_value;
1002: l_stmt := l_select||' , :l_old_value old_value'||
1003: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1004: ' AND kl.dnz_chr_id = okh.id
1005: AND kl.id = att.cle_id
1006: And kl.lse_id in (4,17,22)
1007: AND att.action_type_code = ''RSN''

Line 1027: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

1023:
1024: -- Old Value: NULL (-9999)
1025: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1026: l_stmt := l_select||', NULL old_value'||
1027: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1028: ' AND kl.dnz_chr_id = okh.id
1029: AND kl.id = att.cle_id
1030: And kl.lse_id in (4,17,22)
1031: AND att.action_type_code = ''RCN''

Line 1047: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

1043: ELSE
1044:
1045: l_old_value := p_ctr_rec.old_value;
1046: l_stmt := l_select||' , :l_old_value old_value'||
1047: l_from||', okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
1048: ' AND kl.dnz_chr_id = okh.id
1049: AND kl.id = att.cle_id
1050: And kl.lse_id in (4,17,22)
1051: AND att.action_type_code = ''RCN''

Line 1482: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln

1478: -- Old Value: NULL (-9999)
1479: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1480: l_stmt := l_select||' ,NULL old_value' ||
1481: l_from||
1482: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln
1483: Where cln.dnz_chr_id = okh.id
1484: AND cln.lse_id in(3,16,21)
1485: AND cln.price_list_id is NULL)
1486: AND okh.org_id = to_number(:update_level_value)';

Line 1493: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

1489: ELSIF p_ctr_rec.old_value = '-1111' THEN
1490: l_old_value := p_ctr_rec.old_value;
1491: l_stmt := l_select||' , :l_old_value old_value' ||
1492: l_from||
1493: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
1494: Where cln.dnz_chr_id = okh.id
1495: AND cln.lse_id in(3,16,21))
1496: AND okh.org_id = to_number(:update_level_value)';
1497:

Line 1503: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

1499: ELSE
1500: l_old_value := p_ctr_rec.old_value;
1501: l_stmt := l_select||' , :l_old_value old_value' ||
1502: l_from||
1503: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
1504: Where cln.dnz_chr_id = okh.id
1505: AND cln.lse_id in(3,16,21)
1506: AND cln.price_list_id = to_number(:p_ctr_rec_old_value))
1507: AND okh.org_id = to_number(:update_level_value)';

Line 2105: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

2101:
2102: -- Old Value: NULL (-9999)
2103: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2104: l_stmt := l_select||', NULL old_value'||
2105: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
2106: ' AND kl.dnz_chr_id = okh.id
2107: AND kl.id = att.cle_id
2108: And kl.lse_id in (4,17,22)
2109: AND att.action_type_code = ''RSN''

Line 2127: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2123: ELSE
2124: -- dbms_output.put_line('Inside else 111111');
2125: l_old_value := p_ctr_rec.old_value;
2126: l_stmt := l_select||' , :l_old_value old_value'||
2127: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2128: ' AND kl.dnz_chr_id = okh.id
2129: AND kl.id = att.cle_id
2130: And kl.lse_id in (4,17,22)
2131: AND att.action_type_code = ''RSN''

Line 2151: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2147:
2148: -- Old Value: NULL (-9999)
2149: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2150: l_stmt := l_select||', NULL old_value'||
2151: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2152: ' AND kl.dnz_chr_id = okh.id
2153: AND kl.id = att.cle_id
2154: And kl.lse_id in (4,17,22)
2155: AND att.action_type_code = ''RCN''

Line 2171: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

2167: ELSE
2168:
2169: l_old_value := p_ctr_rec.old_value;
2170: l_stmt := l_select||' , :l_old_value old_value'||
2171: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
2172: ' AND kl.dnz_chr_id = okh.id
2173: AND kl.id = att.cle_id
2174: And kl.lse_id in (4,17,22)
2175: AND att.action_type_code = ''RCN''

Line 2596: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln

2592: -- Old Value: NULL (-9999)
2593: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2594: l_stmt := l_select||' ,NULL old_value' ||
2595: l_from||' ,okc_k_party_roles_b okp1 '||
2596: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln
2597: Where cln.dnz_chr_id = okh.id
2598: AND cln.lse_id in(3,16,21)
2599: AND cln.price_list_id is NULL)
2600: AND okh.id = okp1.chr_id

Line 2609: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

2605: ELSIF p_ctr_rec.old_value = '-1111' THEN
2606: l_old_value := p_ctr_rec.old_value;
2607: l_stmt := l_select||' , :l_old_value old_value' ||
2608: l_from||' ,okc_k_party_roles_b okp1 '||
2609: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
2610: Where cln.dnz_chr_id = okh.id
2611: AND cln.lse_id in(3,16,21))
2612: AND okh.id = okp1.chr_id
2613: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2621: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

2617: ELSE
2618: l_old_value := p_ctr_rec.old_value;
2619: l_stmt := l_select||' , :l_old_value old_value' ||
2620: l_from||' ,okc_k_party_roles_b okp1 '||
2621: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
2622: Where cln.dnz_chr_id = okh.id
2623: AND cln.lse_id in(3,16,21)
2624: AND cln.price_list_id = to_number(:p_ctr_rec_old_value))
2625: AND okh.id = okp1.chr_id

Line 3376: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '|| l_where||

3372:
3373: -- Old Value: NULL (-9999)
3374: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3375: l_stmt := l_select||', NULL old_value'||
3376: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '|| l_where||
3377: ' AND kl.dnz_chr_id = okh.id
3378: AND kl.id = att.cle_id
3379: And kl.lse_id in (4,17,22)
3380: AND att.action_type_code = ''RSN''

Line 3399: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3395: ELSE
3396: -- dbms_output.put_line('Inside else 111111');
3397: l_old_value := p_ctr_rec.old_value;
3398: l_stmt := l_select||' , :l_old_value old_value'||
3399: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3400: ' AND kl.dnz_chr_id = okh.id
3401: AND kl.id = att.cle_id
3402: And kl.lse_id in (4,17,22)
3403: AND att.action_type_code = ''RSN''

Line 3425: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3421:
3422: -- Old Value: NULL (-9999)
3423: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3424: l_stmt := l_select||', NULL old_value'||
3425: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3426: ' AND kl.dnz_chr_id = okh.id
3427: AND kl.id = att.cle_id
3428: And kl.lse_id in (4,17,22)
3429: AND att.action_type_code = ''RCN''

Line 3447: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||

3443: ELSE
3444:
3445: l_old_value := p_ctr_rec.old_value;
3446: l_stmt := l_select||' , :l_old_value old_value'||
3447: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat,okc_k_party_roles_b okp1 '||l_where||
3448: ' AND kl.dnz_chr_id = okh.id
3449: AND kl.id = att.cle_id
3450: And kl.lse_id in (4,17,22)
3451: AND att.action_type_code = ''RCN''

Line 3920: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln

3916: -- Old Value: NULL (-9999)
3917: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3918: l_stmt := l_select||' ,NULL old_value' ||
3919: l_from||
3920: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln
3921: Where cln.dnz_chr_id = okh.id
3922: AND cln.lse_id in(3,16,21)
3923: AND cln.price_list_id is NULL)
3924: AND okh.scs_code = :update_level_value';

Line 3931: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

3927: ELSIF p_ctr_rec.old_value = '-1111' THEN
3928: l_old_value := p_ctr_rec.old_value;
3929: l_stmt := l_select||' , :l_old_value old_value' ||
3930: l_from||
3931: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
3932: Where cln.dnz_chr_id = okh.id
3933: AND cln.lse_id in(3,16,21))
3934: AND okh.scs_code = :update_level_value';
3935:

Line 3941: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

3937: ELSE
3938: l_old_value := p_ctr_rec.old_value;
3939: l_stmt := l_select||' , :l_old_value old_value' ||
3940: l_from||
3941: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
3942: Where cln.dnz_chr_id = okh.id
3943: AND cln.lse_id in(3,16,21)
3944: AND cln.price_list_id = to_number(:p_ctr_rec_old_value))
3945: AND okh.scs_code = :update_level_value';

Line 4559: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

4555:
4556: -- Old Value: NULL (-9999)
4557: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4558: l_stmt := l_select||', NULL old_value'||
4559: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
4560: ' AND kl.dnz_chr_id = okh.id
4561: AND kl.id = att.cle_id
4562: And kl.lse_id in (4,17,22)
4563: AND att.action_type_code = ''RSN''

Line 4580: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4576: ELSE
4577: -- dbms_output.put_line('Inside else 111111');
4578: l_old_value := p_ctr_rec.old_value;
4579: l_stmt := l_select||' , :l_old_value old_value'||
4580: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4581: ' AND kl.dnz_chr_id = okh.id
4582: AND kl.id = att.cle_id
4583: And kl.lse_id in (4,17,22)
4584: AND att.action_type_code = ''RSN''

Line 4604: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4600:
4601: -- Old Value: NULL (-9999)
4602: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4603: l_stmt := l_select||', NULL old_value'||
4604: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4605: ' AND kl.dnz_chr_id = okh.id
4606: AND kl.id = att.cle_id
4607: And kl.lse_id in (4,17,22)
4608: AND att.action_type_code = ''RCN''

Line 4622: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

4618: -- Old Value: Other than NULL or ALL
4619: ELSE
4620: l_old_value := p_ctr_rec.old_value;
4621: l_stmt := l_select||' , :l_old_value old_value'||
4622: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
4623: ' AND kl.dnz_chr_id = okh.id
4624: AND kl.id = att.cle_id
4625: And kl.lse_id in (4,17,22)
4626: AND att.action_type_code = ''RCN''

Line 5066: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln

5062: -- Old Value: NULL (-9999)
5063: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5064: l_stmt := l_select||' ,NULL old_value' ||
5065: l_from||
5066: l_where|| 'AND exists ( Select dnz_chr_id from okc_k_lines_b cln
5067: Where cln.dnz_chr_id = okh.id
5068: AND cln.lse_id in(3,16,21)
5069: AND cln.price_list_id is NULL)
5070: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5080: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

5076: ELSIF p_ctr_rec.old_value = '-1111' THEN
5077: l_old_value := p_ctr_rec.old_value;
5078: l_stmt := l_select||' , :l_old_value old_value' ||
5079: l_from||
5080: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
5081: Where cln.dnz_chr_id = okh.id
5082: AND cln.lse_id in(3,16,21))
5083: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5084: WHERE okg1.included_chr_id is not null

Line 5093: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln

5089: ELSE
5090: l_old_value := p_ctr_rec.old_value;
5091: l_stmt := l_select||' , :l_old_value old_value' ||
5092: l_from||
5093: l_where|| ' AND exists ( Select dnz_chr_id from okc_k_lines_b cln
5094: Where cln.dnz_chr_id = okh.id
5095: AND cln.lse_id in(3,16,21)
5096: AND cln.price_list_id = to_number(:p_ctr_rec_old_value))
5097: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5858: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||

5854:
5855: -- Old Value: NULL (-9999)
5856: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5857: l_stmt := l_select||', NULL old_value'||
5858: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '|| l_where||
5859: ' AND kl.dnz_chr_id = okh.id
5860: AND kl.id = att.cle_id
5861: And kl.lse_id in (4,17,22)
5862: AND att.action_type_code = ''RSN''

Line 5883: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5879: ELSE
5880: -- dbms_output.put_line('Inside else 111111');
5881: l_old_value := p_ctr_rec.old_value;
5882: l_stmt := l_select||' , :l_old_value old_value'||
5883: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5884: ' AND kl.dnz_chr_id = okh.id
5885: AND kl.id = att.cle_id
5886: And kl.lse_id in (4,17,22)
5887: AND att.action_type_code = ''RSN''

Line 5910: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5906:
5907: -- Old Value: NULL (-9999)
5908: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
5909: l_stmt := l_select||', NULL old_value'||
5910: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5911: ' AND kl.dnz_chr_id = okh.id
5912: AND kl.id = att.cle_id
5913: And kl.lse_id in (4,17,22)
5914: AND att.action_type_code = ''RCN''

Line 5931: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||

5927: -- Old Value: Other than NULL or ALL
5928: ELSE
5929: l_old_value := p_ctr_rec.old_value;
5930: l_stmt := l_select||' , :l_old_value old_value'||
5931: l_from||',okc_k_lines_b kl, oks_action_time_types_v att , oks_action_times_v oat '||l_where||
5932: ' AND kl.dnz_chr_id = okh.id
5933: AND kl.id = att.cle_id
5934: And kl.lse_id in (4,17,22)
5935: AND att.action_type_code = ''RCN''

Line 7022: , Okc_k_lines_b Kl

7018:
7019: CURSOR Get_LineSalesrep(p_chr_id IN Number, p_old_value IN Varchar2) IS
7020: SELECT srv.id, srv.object_version_number, kl.start_date
7021: FROM OKS_K_SALES_CREDITS_V srv
7022: , Okc_k_lines_b Kl
7023: WHERE srv.chr_id = p_chr_id
7024: And srv.Cle_id Is nOt null
7025: And Kl.id = srv.cle_id
7026: AND srv.ctc_id = to_number(p_old_value);

Line 7054: FROM okc_k_lines_b okl

7050: ** condition as part of Line Level Cancelation project
7051: */
7052: CURSOR Get_lines_csr(p_chr_id IN NUMBER) IS
7053: SELECT okl.id id
7054: FROM okc_k_lines_b okl
7055: ,Oks_k_lines_b oks
7056: WHERE okl.dnz_chr_id = p_chr_id
7057: AND okl.date_cancelled is NULL
7058: And okl.id = oks.cle_id

Line 7064: FROM okc_k_lines_b okl

7060: or (okl.lse_id = 12 and oks.usage_type in ('FRT','NPR'))) ;
7061:
7062: CURSOR Get_cle_id (p_chr_id IN NUMBER) IS
7063: SELECT okl.id id
7064: FROM okc_k_lines_b okl
7065: WHERE okl.dnz_chr_id = p_chr_id
7066: AND okl.date_cancelled is NULL
7067: AND okl.lse_id in (1,12,14,19,46) ;
7068:

Line 7100: FROM okc_k_lines_b cln

7096: AND osl.coverage_type = p_old_value ;
7097:
7098: CURSOR get_bp_lines (p_chr_id IN Number,p_old_value in Varchar2) IS
7099: SELECT cln.id , cln.object_version_number
7100: FROM okc_k_lines_b cln
7101: Where cln.dnz_chr_id = p_chr_id
7102: AND cln.lse_id in(3,16,21)
7103: AND cln.price_list_id = p_old_value ;
7104:

Line 7107: FROM okc_k_lines_b cln

7103: AND cln.price_list_id = p_old_value ;
7104:
7105: CURSOR get_bp_lines_all (p_chr_id IN Number) IS
7106: SELECT cln.id , cln.object_version_number
7107: FROM okc_k_lines_b cln
7108: Where cln.dnz_chr_id = p_chr_id
7109: AND cln.lse_id in(3,16,21);
7110:
7111: CURSOR get_bp_lines_null (p_chr_id IN Number) IS

Line 7113: FROM okc_k_lines_b cln

7109: AND cln.lse_id in(3,16,21);
7110:
7111: CURSOR get_bp_lines_null (p_chr_id IN Number) IS
7112: SELECT cln.id , cln.object_version_number
7113: FROM okc_k_lines_b cln
7114: Where cln.dnz_chr_id = p_chr_id
7115: AND cln.lse_id in(3,16,21)
7116: AND cln.price_list_id is null ;
7117:

Line 7475: FROM oks_k_lines_v ksl, okc_k_lines_b kcl

7471: i := 1;
7472: x_return_status := G_RET_STS_SUCCESS;
7473:
7474: l_stmt:= 'SELECT ksl.id,ksl.object_version_number,ksl.invoice_text
7475: FROM oks_k_lines_v ksl, okc_k_lines_b kcl
7476: WHERE kcl.date_cancelled is NULL
7477: AND kcl.dnz_chr_id = :p_chr_id
7478: AND kcl.id = ksl.cle_id
7479: AND kcl.lse_id IN (7,8,9,10,11,18,25,35,1,12,14,19)';

Line 7667: Exists (select 'x' from OKC_K_LINES_B cle

7663: RETURN Varchar2 IS
7664: CURSOR Warranty_lookup IS
7665: SELECT id FROM okc_k_headers_b okh
7666: WHERE
7667: Exists (select 'x' from OKC_K_LINES_B cle
7668: where cle.dnz_chr_id = okh.id
7669: and cle.lse_id = 14 )
7670: AND okh.id = p_chr_id ;
7671: l_chr_id Number;

Line 9604: Update Okc_k_lines_b set inv_rule_id = l_new_value_id

9600: LOG_MESSAGES('INV_RULE update status: '||l_return_status);
9601:
9602: FOR rec_line_id in Get_lines_csr (l_eligible_contracts_tbl(i).contract_id) LOOP
9603:
9604: Update Okc_k_lines_b set inv_rule_id = l_new_value_id
9605: Where id = rec_line_id.id;
9606:
9607: oks_bill_sch.update_bs_interface_date(
9608: p_top_line_id => rec_line_id.id,