APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 824: jtf_rs_resource_extns_vl res

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
828: AND srp.org_id = khr.authoring_org_id

Line 841: FROM jtf_rs_resource_extns jtfrse,

837: CURSOR csr_party_helpdesk (
838: p_k_party_id IN NUMBER
839: ) IS
840: SELECT per.full_name help_desk_name
841: FROM jtf_rs_resource_extns jtfrse,
842: oks_k_defaults gcd,
843: per_all_people_f per
844: WHERE jtfrse.user_id = gcd.user_id
845: AND per.person_id = jtfrse.source_id

Line 869: FROM jtf_rs_resource_extns jtfrse,

865: CURSOR csr_org_helpdesk (
866: p_k_org_id IN NUMBER
867: ) IS
868: SELECT per.full_name help_desk_name
869: FROM jtf_rs_resource_extns jtfrse,
870: oks_k_defaults gcd,
871: per_all_people_f per
872: WHERE jtfrse.user_id = gcd.user_id
873: AND per.person_id = jtfrse.source_id

Line 895: FROM jtf_rs_resource_extns jtfrse,

891:
892: -- bug 5218842
893: CURSOR csr_global_helpdesk IS
894: SELECT per.full_name help_desk_name
895: FROM jtf_rs_resource_extns jtfrse,
896: oks_k_defaults gcd,
897: per_all_people_f per
898: WHERE jtfrse.user_id = gcd.user_id
899: AND per.person_id = jtfrse.source_id

Line 3649: jtf_rs_resource_extns res

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
3653: AND srp.org_id = khr.authoring_org_id