[Home] [Help]
View: AR_NET_REVENUE
Product: | AR - Receivables |
Description: | Determine the uncredited amount on a transaction line |
Implementation/DBA Data: |
APPS.AR_NET_REVENUE
|
View Text
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
Columns
Name |
CUSTOMER_TRX_LINE_ID |
REQUEST_ID |
GL_DATE |
AMOUNT |
PERIOD_SET_NAME |