VIEW: APPS.AR_NET_REVENUE

Source

View Text - Preformatted

SELECT customer_trx_line_id , request_id , trunc(gl_date) , sum(amount) , period_set_name FROM AR_NET_REVENUE_ASSIGNMENTS group by customer_trx_line_id, trunc(gl_date), request_id, period_set_name

View Text - HTML Formatted

SELECT CUSTOMER_TRX_LINE_ID
, REQUEST_ID
, TRUNC(GL_DATE)
, SUM(AMOUNT)
, PERIOD_SET_NAME
FROM AR_NET_REVENUE_ASSIGNMENTS GROUP BY CUSTOMER_TRX_LINE_ID
, TRUNC(GL_DATE)
, REQUEST_ID
, PERIOD_SET_NAME