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.OKI_REFRESH_PVT dependencies on OKC_CONTACTS

Line 4694: l_salesperson_code okc_contacts.cro_code%TYPE; -- 11510 Changes

4690:
4691: -- variables to set up the fast refresh job
4692: l_job_run_id NUMBER ;
4693:
4694: l_salesperson_code okc_contacts.cro_code%TYPE; -- 11510 Changes
4695:
4696: BEGIN
4697: retcode := '0';
4698:

Line 4797: ,okc_contacts ctt

4793: ,ctt.attribute14
4794: ,ctt.attribute15
4795: FROM
4796: oki_sales_k_hdrs shd
4797: ,okc_contacts ctt
4798: WHERE 1=1
4799: AND ctt.cro_code = l_salesperson_code -- 11510 Changes
4800: AND ctt.dnz_chr_id = shd.chr_id
4801: ;

Line 4916: l_salesperson_code okc_contacts.cro_code%TYPE; -- 11510 Changes

4912: l_job_curr_start_date DATE ;
4913: l_job_curr_end_date DATE ;
4914: l_table_name VARCHAR2(30) ;
4915:
4916: l_salesperson_code okc_contacts.cro_code%TYPE; -- 11510 Changes
4917:
4918: BEGIN
4919: l_retcode := '0';
4920: l_table_name := 'OKI_K_SALESREPS';

Line 5022: , okc_contacts ctt

5018: , ctt.attribute14
5019: , ctt.attribute15
5020: FROM
5021: oki_sales_k_hdrs shd
5022: , okc_contacts ctt
5023: , oki_job_run_dtl jrd
5024: WHERE 1=1
5025: AND ctt.cro_code = l_salesperson_code -- 11510 Changes
5026: AND ctt.dnz_chr_id = shd.chr_id