View: AR_CM_NET_REVENUE

Product:	AR - Receivables
Description:	Determine the uncredited amount
Implementation/DBA Data:	APPS.AR_CM_NET_REVENUE

View Text

SELECT PREVIOUS_CUSTOMER_TRX_LINE_ID
, PREVIOUS_CUSTOMER_TRX_ID
, REQUEST_ID
, GL_DATE
, SUM(AMOUNT)
, SUM(DECODE(CREDIT_METHOD_FOR_RULES
, 'UNIT'
, 0
, 'LIFO'
, 0
, AMOUNT) ) / DECODE(SUM(DECODE(CREDIT_METHOD_FOR_RULES
, ''
, QUANTITY
, 0) )
, 0
, 1
, SUM(DECODE(CREDIT_METHOD_FOR_RULES
, ''
, QUANTITY
, 0) ) )
, PERIOD_SET_NAME
FROM AR_CM_NET_REVENUE_ASSIGNMENTS RA GROUP BY PREVIOUS_CUSTOMER_TRX_LINE_ID
, GL_DATE
, REQUEST_ID
, PREVIOUS_CUSTOMER_TRX_ID
, PERIOD_SET_NAME

Columns