View: AR_CM_NET_DISTS_V

Product:	AR - Receivables
Description:	Determine the amount to credit for a given invoice line
Implementation/DBA Data:	APPS.AR_CM_NET_DISTS_V

View Text

SELECT LN.CUSTOMER_TRX_LINE_ID
, LN.PREVIOUS_CUSTOMER_TRX_LINE_ID
, LN.PREVIOUS_CUSTOMER_TRX_ID
, CMA.GL_DATE
, DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT
, NULL
, ROUND(AMOUNT
, FC.PRECISION)
, ROUND(AMOUNT / FC.MINIMUM_ACCOUNTABLE_UNIT ) * FC.MINIMUM_ACCOUNTABLE_UNIT ) )
, NVL(LN.QUANTITY_CREDITED
, 0)
, CT.CREDIT_METHOD_FOR_RULES
, SOB.PERIOD_SET_NAME
FROM AR_CREDIT_MEMO_AMOUNTS CMA
, FND_CURRENCIES FC
, GL_SETS_OF_BOOKS SOB
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES LN
WHERE LN.PREVIOUS_CUSTOMER_TRX_LINE_ID IS NOT NULL
AND LN.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND LN.CUSTOMER_TRX_LINE_ID = CMA.CUSTOMER_TRX_LINE_ID
AND FC.CURRENCY_CODE = CT.INVOICE_CURRENCY_CODE
AND CT.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT NULL
, CTL.CUSTOMER_TRX_LINE_ID
, CT.CUSTOMER_TRX_ID
, LGD.ORIGINAL_GL_DATE
, DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, SUM(LGD.AMOUNT))
, CTL.QUANTITY_INVOICED
, NULL
, GSB.PERIOD_SET_NAME
FROM RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUST_TRX_LINE_GL_DIST LGD
, GL_SETS_OF_BOOKS GSB
WHERE CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID
AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID
AND LGD.ACCOUNT_CLASS = 'REV'
AND LGD.ACCOUNT_SET_FLAG = 'N'
AND CTL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID GROUP BY CTL.CUSTOMER_TRX_LINE_ID
, CT.CUSTOMER_TRX_ID
, CT.COMPLETE_FLAG
, LGD.ORIGINAL_GL_DATE
, CTL.QUANTITY_INVOICED
, GSB.PERIOD_SET_NAME

Columns