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.

[Home] [Help]

APPS.OKS_MASSCHANGE_PVT dependencies on OKS_K_LINES_V

Line 440: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

436: -- Old Value: NULL (-9999)
437: IF p_ctr_rec.old_value = '-9999' THEN
438: l_stmt := l_select||' ,NULL old_value'||
439: l_from||l_where||
440: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
441: WHERE okl.dnz_chr_id = okh.id
442: AND oksl.cle_id = okl.id
443: AND oksl.coverage_type is NULL )
444: AND okh.id = to_number(:update_level_value)' ;

Line 453: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

449:
450: l_old_value := p_ctr_rec.old_value;
451: l_stmt := l_select||' , :l_old_value old_value'||
452: l_from||
453: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
454: WHERE okl.dnz_chr_id = okh.id
455: AND oksl.cle_id = okl.id )
456: AND okh.id = to_number(:update_level_value)' ;
457: ELSE

Line 461: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

457: ELSE
458: l_old_value := p_ctr_rec.old_value;
459: l_stmt := l_select||' , :l_old_value old_value'||
460: l_from||
461: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
462: WHERE okl.dnz_chr_id = okh.id
463: AND oksl.cle_id = okl.id
464: AND oksl.coverage_type = :p_ctr_rec_old_value )
465: AND okh.id = to_number(:update_level_value)' ;

Line 1580: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

1576: -- Old Value: NULL (-9999)
1577: IF p_ctr_rec.old_value = '-9999' THEN
1578: l_stmt := l_select||' ,NULL old_value'||
1579: l_from||l_where||
1580: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
1581: WHERE okl.dnz_chr_id = okh.id
1582: AND oksl.cle_id = okl.id
1583: AND oksl.coverage_type is NULL )
1584: AND okh.org_id = to_number(:update_level_value)';

Line 1593: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

1589:
1590: l_old_value := p_ctr_rec.old_value;
1591: l_stmt := l_select||' , :l_old_value old_value'||
1592: l_from||
1593: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
1594: WHERE okl.dnz_chr_id = okh.id
1595: AND oksl.cle_id = okl.id )
1596: AND okh.org_id = to_number(:update_level_value)';
1597: -- Old Value: Other than NULL or ALL

Line 1602: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

1598: ELSE
1599: l_old_value := p_ctr_rec.old_value;
1600: l_stmt := l_select||' , :l_old_value old_value'||
1601: l_from||
1602: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
1603: WHERE okl.dnz_chr_id = okh.id
1604: AND oksl.cle_id = okl.id
1605: AND oksl.coverage_type = :p_ctr_rec_old_value )
1606: AND okh.org_id = to_number(:update_level_value)';

Line 2715: l_where||' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

2711: -- Old Value: NULL (-9999)
2712: IF p_ctr_rec.old_value = '-9999' THEN
2713: l_stmt := l_select||' ,NULL old_value'||
2714: l_from||',okc_k_party_roles_v okp1'||
2715: l_where||' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
2716: WHERE okl.dnz_chr_id = okh.id
2717: AND oksl.cle_id = okl.id
2718: AND oksl.coverage_type is NULL )
2719: AND okh.id = okp1.chr_id

Line 2730: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

2726:
2727: l_old_value := p_ctr_rec.old_value;
2728: l_stmt := l_select||' , :l_old_value old_value'||
2729: l_from||',okc_k_party_roles_v okp1'||
2730: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
2731: WHERE okl.dnz_chr_id = okh.id
2732: AND oksl.cle_id = okl.id )
2733: AND okh.id = okp1.chr_id
2734: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 2742: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

2738: ELSE
2739: l_old_value := p_ctr_rec.old_value;
2740: l_stmt := l_select||' , :l_old_value old_value'||
2741: l_from||',okc_k_party_roles_v okp1'||
2742: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
2743: WHERE okl.dnz_chr_id = okh.id
2744: AND oksl.cle_id = okl.id
2745: AND oksl.coverage_type = :p_ctr_rec_old_value )
2746: AND okh.id = okp1.chr_id

Line 4022: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

4018: -- Old Value: NULL (-9999)
4019: IF p_ctr_rec.old_value = '-9999' THEN
4020: l_stmt := l_select||' ,NULL old_value'||
4021: l_from||l_where||
4022: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
4023: WHERE okl.dnz_chr_id = okh.id
4024: AND oksl.cle_id = okl.id
4025: AND oksl.coverage_type is NULL )
4026: AND okh.scs_code = :update_level_value';

Line 4035: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

4031:
4032: l_old_value := p_ctr_rec.old_value;
4033: l_stmt := l_select||' , :l_old_value old_value'||
4034: l_from||
4035: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
4036: WHERE okl.dnz_chr_id = okh.id
4037: AND oksl.cle_id = okl.id )
4038: AND okh.scs_code = :update_level_value';
4039: -- Old Value: Other than NULL or ALL

Line 4044: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

4040: ELSE
4041: l_old_value := p_ctr_rec.old_value;
4042: l_stmt := l_select||' , :l_old_value old_value'||
4043: l_from||
4044: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
4045: WHERE okl.dnz_chr_id = okh.id
4046: AND oksl.cle_id = okl.id
4047: AND oksl.coverage_type = :p_ctr_rec_old_value )
4048: AND okh.scs_code = :update_level_value';

Line 5194: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl

5190:
5191: IF p_ctr_rec.old_value = '-9999' THEN
5192: l_stmt := l_select||' ,NULL old_value'||
5193: l_from||l_where||
5194: ' AND EXISTS (SELECT ''x'' from OKC_K_LINES_V okl, oks_k_lines_v oksl
5195: WHERE okl.dnz_chr_id = okh.id
5196: AND oksl.cle_id = okl.id
5197: AND oksl.coverage_type is NULL )
5198: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 5210: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

5206:
5207: l_old_value := p_ctr_rec.old_value;
5208: l_stmt := l_select||' , :l_old_value old_value'||
5209: l_from||
5210: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
5211: WHERE okl.dnz_chr_id = okh.id
5212: AND oksl.cle_id = okl.id )
5213: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1
5214: WHERE okg1.included_chr_id is not null

Line 5223: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl

5219: ELSE
5220: l_old_value := p_ctr_rec.old_value;
5221: l_stmt := l_select||' , :l_old_value old_value'||
5222: l_from||
5223: l_where||'AND EXISTS (SELECT ''x'' from okc_k_lines_v okl, oks_k_lines_v oksl
5224: WHERE okl.dnz_chr_id = okh.id
5225: AND oksl.cle_id = okl.id
5226: AND oksl.coverage_type = :p_ctr_rec_old_value )
5227: AND okh.id in( SELECT distinct okg1.included_chr_id from okc_k_grpings okg1

Line 7092: FROM okc_k_lines_v okl, oks_k_lines_v osl

7088: OR oat.sat_duration = p_old_value ) ;
7089:
7090: CURSOR Get_cov_type ( p_chr_id IN NUMBER , p_old_value IN Varchar2) IS
7091: SELECT osl.id , osl.object_version_number
7092: FROM okc_k_lines_v okl, oks_k_lines_v osl
7093: WHERE okl.id = osl.cle_id
7094: AND okl.dnz_chr_id = p_chr_id
7095: AND okl.lse_id in( 2,15,20)
7096: AND osl.coverage_type = p_old_value ;

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)';