DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on JTF_RS_SALESREPS

Line 823: jtf_rs_salesreps srp,

819: CURSOR csr_k_salesrep IS
820: SELECT res.resource_name AS salesrep_name
821: FROM okc_k_headers_all_b khr,
822: okc_contacts ct,
823: jtf_rs_salesreps srp,
824: jtf_rs_resource_extns_vl res
825: WHERE khr.ID = ct.dnz_chr_id
826: AND ct.object1_id1 = srp.salesrep_id
827: AND srp.resource_id = res.resource_id

Line 3648: jtf_rs_salesreps srp,

3644: SELECT srp.email_address AS email_address,
3645: res.user_name AS username
3646: FROM okc_k_headers_all_b khr,
3647: okc_contacts ct,
3648: jtf_rs_salesreps srp,
3649: jtf_rs_resource_extns res
3650: WHERE khr.ID = ct.dnz_chr_id
3651: AND ct.object1_id1 = srp.salesrep_id
3652: AND srp.resource_id = res.resource_id