[Home] [Help]
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
Name |
PREVIOUS_CUSTOMER_TRX_LINE_ID |
PREVIOUS_CUSTOMER_TRX_ID |
REQUEST_ID |
GL_DATE |
AMOUNT |
NET_UNIT_PRICE |
PERIOD_SET_NAME |