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_COMMISSION_HEADERS

Line 82: FROM cn_commission_headers ch

78: , NVL(ch.attribute1, inventory_item_id) AS product_name
79: , NVL(ch.transaction_amount, 0) AS transaction_amount
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

Line 187: FROM cn_commission_headers ch

183: , RANK () OVER (PARTITION BY hca.cust_account_id ORDER BY NVL
184: (cl.commission_amount,
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

Line 291: FROM cn_commission_headers ch,

287: MAX(NVL(cl.commission_amount, 0)) AS earnings,
288: MAX(NVL(cl.commission_rate, 0)) AS comm_rate,
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