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.CN_WEBSERVICE_PUB dependencies on CN_SALESREPS

Line 84: , cn_salesreps rep

80: , NVL(cl.perf_achieved, 0) AS credit
81: , NVL(cl.commission_amount, 0) AS earnings
82: FROM cn_commission_headers ch
83: , cn_commission_lines cl
84: , cn_salesreps rep
85: , hz_parties hp
86: , hz_cust_accounts hca
87: WHERE cl.org_id = ch.org_id
88: AND rep.org_id = ch.org_id

Line 189: , cn_salesreps rep

185: 0
186: ) DESC NULLS LAST) AS comp_rank
187: FROM cn_commission_headers ch
188: , cn_commission_lines cl
189: , cn_salesreps rep
190: , hz_parties hp
191: , hz_cust_accounts hca
192: WHERE cl.org_id = ch.org_id
193: AND rep.org_id = ch.org_id

Line 293: cn_salesreps rep

289: MAX(NVL(cl.perf_achieved, 0)) AS credit,
290: MAX(NVL(ch.transaction_amount, 0)) AS transaction_amount
291: FROM cn_commission_headers ch,
292: cn_commission_lines cl,
293: cn_salesreps rep
294: WHERE cl.org_id = ch.org_id
295: AND rep.org_id = ch.org_id
296: AND cl.status = 'CALC'
297: AND cl.commission_header_id = ch.commission_header_id