VIEW: APPS.CN_SRP_WORKSHEETS

Source

View Text - Preformatted

SELECT salesrep_id, org_id, payrun_id, sum(total_paid) total_paid from cn_srp_worksheets_v group by salesrep_id, org_id,payrun_id

View Text - HTML Formatted

SELECT SALESREP_ID
, ORG_ID
, PAYRUN_ID
, SUM(TOTAL_PAID) TOTAL_PAID
FROM CN_SRP_WORKSHEETS_V GROUP BY SALESREP_ID
, ORG_ID
, PAYRUN_ID