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_IB_UTIL_PVT dependencies on JTF_RS_SALESREPS

Line 61: jtf_rs_salesreps srp

57: NULL phone,
58: srp.email_address email
59: FROM jtf_rs_resource_extns rsc,
60: jtf_rs_resource_extns_tl rsctl, --Bug Fix #5456468 Dneetha
61: jtf_rs_salesreps srp
62: WHERE rsc.CATEGORY = 'OTHER'
63: AND srp.resource_id = rsc.resource_id
64: AND srp.org_id = p_org_id
65: AND rsc.resource_id = TO_NUMBER (p_object1_id1)

Line 114: JTF_RS_SALESREPS SRP

110: SELECT
111: SRP.NAME name, null phone ,srp.email_address email
112: FROM
113: JTF_RS_RESOURCE_EXTNS RSC ,
114: JTF_RS_SALESREPS SRP
115: WHERE
116: RSC.CATEGORY = 'OTHER'
117: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
118: AND SRP.ORG_ID = p_org_id

Line 136: JTF_RS_SALESREPS SRP

132: RSCTL.Resource_name name, null phone ,srp.email_address email
133: FROM
134: JTF_RS_RESOURCE_EXTNS RSC ,
135: JTF_RS_RESOURCE_EXTNS_tl RSCTL ,-- Bug Fix #5456468 dneetha
136: JTF_RS_SALESREPS SRP
137: WHERE
138: RSC.CATEGORY IN ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
139: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
140: AND SRP.ORG_ID = p_org_id

Line 362: From jtf_rs_salesreps jtf

358: Function get_salesrep_name(P_Contract_Id Number) return Varchar2 Is
359:
360: Cursor l_salesrep_csr Is
361: Select v.resource_name sales_person
362: From jtf_rs_salesreps jtf
363: , jtf_rs_resource_extns_vl v
364: , okc_contacts oc1
365: ,Okc_k_headers_all_b kh
366: