APPS.OKS_MASSCHANGE_PVT dependencies on OKS_K_SALES_CREDITS_V

Line 716: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

712: where oc.dnz_chr_id = okh.id
713: and oc.cro_code = ''SALESPERSON''
714: and oc.object1_id1 is null
715: and oc.jtot_object1_code = ''OKX_SALEPERS'')
716: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
717: Where osc.chr_id = okh.id
718: and osc.ctc_id is NULL))
719: AND okh.id = to_number(:update_level_value)';
720:

Line 743: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

739: where oc.dnz_chr_id = okh.id
740: and oc.cro_code = ''SALESPERSON''
741: and oc.object1_id1=:p_ctr_rec_old_value
742: and oc.jtot_object1_code = ''OKX_SALEPERS'')
743: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
744: Where osc.chr_id = okh.id
745: and osc.ctc_id = to_number(:p_ctr_rec_old_value)))
746: AND okh.id = to_number(:update_level_value)';
747:

Line 1884: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

1880: where oc.dnz_chr_id = okh.id
1881: and oc.cro_code = ''SALESPERSON''
1882: and oc.object1_id1= :p_ctr_rec_old_value
1883: and oc.jtot_object1_code = ''OKX_SALEPERS'')
1884: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
1885: Where osc.chr_id = okh.id
1886: and osc.ctc_id = to_number(:p_ctr_rec_old_value)))
1887: AND okh.org_id = to_number(:update_level_value)';
1888:

Line 3063: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

3059: where oc.dnz_chr_id = okh.id
3060: and oc.cro_code = ''SALESPERSON''
3061: and oc.object1_id1= :p_ctr_rec_old_value
3062: and oc.jtot_object1_code = ''OKX_SALEPERS'')
3063: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
3064: Where osc.chr_id = okh.id
3065: and osc.ctc_id = to_number(:p_ctr_rec_old_value)))
3066: AND okh.id = okp1.chr_id
3067: AND okp1.rle_code in (''CUSTOMER'',''SUBSCRIBER'')

Line 4303: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

4299: where oc.dnz_chr_id = okh.id
4300: and oc.cro_code = ''SALESPERSON''
4301: and oc.object1_id1=:p_ctr_rec_old_value
4302: and oc.jtot_object1_code = ''OKX_SALEPERS'')
4303: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
4304: Where osc.chr_id = okh.id
4305: and osc.ctc_id = to_number(:p_ctr_rec_old_value)))
4306: AND okh.scs_code = :update_level_value';
4307:

Line 5548: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc

5544: where oc.dnz_chr_id = okh.id
5545: and oc.cro_code = ''SALESPERSON''
5546: and oc.object1_id1=:p_ctr_rec_old_value
5547: and oc.jtot_object1_code = ''OKX_SALEPERS'')
5548: OR EXISTS (Select ''x'' from oks_k_sales_credits_v osc
5549: Where osc.chr_id = okh.id
5550: and osc.ctc_id = to_number(:p_ctr_rec_old_value)))
5551: AND okh.id in (SELECT okg1.included_chr_id from okc_k_grpings okg1
5552: WHERE okg1.included_chr_id is not null

Line 7011: FROM OKS_K_SALES_CREDITS_V srv

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
7010: SELECT srv.id, srv.object_version_number, kh.start_date
7011: FROM OKS_K_SALES_CREDITS_V srv
7012: , Okc_k_headers_b Kh
7013: WHERE srv.cle_id Is Null
7014: And kh.id = p_chr_id
7015: And kh.id = srv.chr_id

Line 7021: FROM OKS_K_SALES_CREDITS_V srv

7017:
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