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 OKS_REV_DISTRIBUTIONS_V

Line 188: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

184: -- Old Value: NULL (-9999)
185: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
186: l_stmt := l_select||' ,NULL old_value'||
187: l_from||l_where||
188: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
189: WHERE rev.chr_id = okh.id
190: AND rev.code_combination_id is NULL)
191: AND okh.id = to_number(:update_level_value)' ; --||to_number(p_ctr_rec.update_level_value);
192:

Line 198: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

194: ELSIF p_ctr_rec.old_value = '-1111' THEN
195:
196: l_stmt := l_select||' ,NULL old_value'||
197: l_from||l_where||
198: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
199: WHERE rev.chr_id = okh.id)
200: AND okh.id = to_number(:update_level_value)';
201:
202: -- Old Value: Other than NULL or ALL

Line 208: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

204: ELSE
205: l_old_value := p_ctr_rec.old_value;
206: l_stmt := l_select||' , :l_old_value old_value'||
207: l_from||l_where||
208: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
209: WHERE rev.chr_id = okh.id
210: AND rev.code_combination_id = to_number(:p_ctr_rec_old_value))
211: AND okh.id = to_number(:update_level_value)';
212:

Line 1318: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

1314: -- Old Value: NULL (-9999)
1315: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
1316: l_stmt := l_select||' ,NULL old_value'||
1317: l_from||l_where||
1318: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
1319: WHERE rev.chr_id = okh.id
1320: AND rev.code_combination_id is NULL)
1321: AND okh.org_id = to_number(:update_level_value)';
1322:

Line 1329: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

1325: ELSIF p_ctr_rec.old_value = '-1111' THEN
1326:
1327: l_stmt := l_select||' ,NULL old_value'||
1328: l_from||l_where||
1329: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
1330: WHERE rev.chr_id = okh.id)
1331: AND okh.org_id = to_number(:update_level_value)';
1332:
1333: -- Old Value: Other than NULL or ALL

Line 1340: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

1336:
1337: l_old_value := p_ctr_rec.old_value;
1338: l_stmt := l_select||' , :l_old_value old_value'||
1339: l_from||l_where||
1340: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
1341: WHERE rev.chr_id = okh.id
1342: AND rev.code_combination_id = to_number(:p_ctr_rec_old_value))
1343: AND okh.org_id = to_number(:update_level_value)';
1344:

Line 2417: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

2413:
2414: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
2415: l_stmt := l_select||' ,NULL old_value'||
2416: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2417: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
2418: WHERE rev.chr_id = okh.id
2419: AND rev.code_combination_id is NULL)
2420: AND okh.id = okp1.chr_id
2421: AND okp1.rle_code in ( ''CUSTOMER'',''SUBSCRIBER'')

Line 2428: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

2424: ELSIF p_ctr_rec.old_value = '-1111' THEN
2425:
2426: l_stmt := l_select||' ,NULL old_value'||
2427: l_from||' ,okc_k_party_roles_b okp1 '||l_where||
2428: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
2429: WHERE rev.chr_id = okh.id)
2430: AND okh.id = okp1.chr_id
2431: AND okp1.rle_code in ( ''CUSTOMER'',''SUBSCRIBER'')
2432: AND okp1.object1_id1 = :update_level_value';

Line 2440: l_where||' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

2436: -- dbms_output.put_line('Inside else');
2437: l_old_value := p_ctr_rec.old_value;
2438: l_stmt := l_select||' , :l_old_value old_value'||
2439: l_from||' ,okc_k_party_roles_b okp1 '||
2440: l_where||' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
2441: WHERE rev.chr_id = okh.id
2442: AND rev.code_combination_id = to_number(:p_ctr_rec_old_value))
2443: AND okh.id = okp1.chr_id
2444: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 3763: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

3759:
3760: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
3761: l_stmt := l_select||' ,NULL old_value'||
3762: l_from||l_where||
3763: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
3764: WHERE rev.chr_id = okh.id
3765: AND rev.code_combination_id is NULL)
3766: AND okh.scs_code = :update_level_value';
3767:

Line 3772: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

3768: ELSIF p_ctr_rec.old_value = '-1111' THEN
3769:
3770: l_stmt := l_select||' ,NULL old_value'||
3771: l_from||l_where||
3772: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
3773: WHERE rev.chr_id = okh.id)
3774: AND okh.scs_code = :update_level_value';
3775:
3776: ELSE

Line 3780: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

3776: ELSE
3777: l_old_value := p_ctr_rec.old_value;
3778: l_stmt := l_select||' , :l_old_value old_value'||
3779: l_from||l_where||
3780: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
3781: WHERE rev.chr_id = okh.id
3782: AND rev.code_combination_id = to_number(:p_ctr_rec_old_value))
3783: AND okh.scs_code = :update_level_value';
3784: END IF;

Line 4874: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

4870:
4871: IF p_ctr_rec.old_value = '-9999' THEN -- For old Value as NULL
4872: l_stmt := l_select||' ,NULL old_value'||
4873: l_from||l_where||
4874: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
4875: WHERE rev.chr_id = okh.id
4876: AND rev.code_combination_id is NULL)
4877: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
4878: WHERE okg1.included_chr_id is not null

Line 4885: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

4881:
4882: ELSIF p_ctr_rec.old_value = '-1111' THEN
4883: l_stmt := l_select||' ,NULL old_value'||
4884: l_from||l_where||
4885: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
4886: WHERE rev.chr_id = okh.id)
4887: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
4888: WHERE okg1.included_chr_id is not null
4889: START WITH okg1.cgp_parent_id = to_number(:update_level_value)

Line 4897: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev

4893: ELSE
4894: l_old_value := p_ctr_rec.old_value;
4895: l_stmt := l_select||' , :l_old_value old_value'||
4896: l_from||l_where||
4897: ' AND EXISTS (SELECT ''x'' from OKS_REV_DISTRIBUTIONS_V rev
4898: WHERE rev.chr_id = okh.id
4899: AND rev.code_combination_id = to_number(:p_ctr_rec_old_value))
4900: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
4901: WHERE okg1.included_chr_id is not null

Line 7005: FROM oks_rev_distributions_v rev

7001: And Kh.id = oc.dnz_chr_id;
7002:
7003: CURSOR Get_revenue(p_chr_id IN Number, p_old_value IN Number) IS
7004: SELECT rev.id, rev.object_version_number
7005: FROM oks_rev_distributions_v rev
7006: WHERE rev.chr_id = p_chr_id
7007: AND rev.code_combination_id = p_old_value;
7008:
7009: CURSOR Get_Salesrep(p_chr_id IN Number, p_old_value IN Varchar2) IS