View: AR_CM_NET_REVENUE_FORM

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

View Text

SELECT PREVIOUS_CUSTOMER_TRX_LINE_ID
, PREVIOUS_CUSTOMER_TRX_ID
, TRUNC(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_REV_ASSIGNMENTS_FRM RA GROUP BY PREVIOUS_CUSTOMER_TRX_LINE_ID
, TRUNC(GL_DATE)
, PREVIOUS_CUSTOMER_TRX_ID
, PERIOD_SET_NAME

Columns