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 HZ_PARTIES

Line 85: , hz_parties hp

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
89: AND cl.status = 'CALC'

Line 190: , hz_parties hp

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
194: AND cl.status = 'CALC'

Line 383: hz_parties pi,

379: jtf_tasks_vl b,
380: jtf_task_references_b r,
381: hz_party_sites ps,
382: hz_locations hl,
383: hz_parties pi,
384: jtf_task_assignments jtb,
385: jtf_task_priorities_vl jtp
386: WHERE esc_t.task_id = r.task_id
387: AND esc_t.task_type_id = 22

Line 412: hz_parties pi,

408: FROM jtf_task_statuses_vl s,
409: jtf_tasks_vl b,
410: hz_party_sites ps,
411: hz_locations hl,
412: hz_parties pi,
413: jtf_task_assignments jtb,
414: jtf_task_priorities_vl jtp
415: WHERE jtb.task_id = b.task_id
416: AND s.task_status_id = jtb.assignment_status_id