VIEW: APPS.AR_CM_NET_REVENUE_ASSIGNMENTS

Source

View Text - Preformatted

SELECT LN.CUSTOMER_TRX_LINE_ID , LN.PREVIOUS_CUSTOMER_TRX_LINE_ID , LN.PREVIOUS_CUSTOMER_TRX_ID , LN.REQUEST_ID , CMA.GL_DATE , DECODE(CT.COMPLETE_FLAG, 'N', 0, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND(AMOUNT, 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 TO_NUMBER(''), RA.CUSTOMER_TRX_LINE_ID, CTL.PREVIOUS_CUSTOMER_TRX_ID, CTL.REQUEST_ID, RA.GL_DATE, DECODE(CT.COMPLETE_FLAG, 'N', 0, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND(AMOUNT, PRECISION), ROUND(AMOUNT, FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ), RA.QUANTITY, NULL, PERIOD_SET_NAME FROM ar_revenue_assignments ra, fnd_currencies fc, ra_customer_trx ct, ra_customer_trx_lines ctl WHERE account_class = 'REV' AND ra.customer_trx_line_id = ctl.previous_customer_trx_line_id AND ct.customer_trx_id = ctl.previous_customer_trx_id AND fc.currency_code = ct.invoice_currency_code

View Text - HTML Formatted

SELECT LN.CUSTOMER_TRX_LINE_ID
, LN.PREVIOUS_CUSTOMER_TRX_LINE_ID
, LN.PREVIOUS_CUSTOMER_TRX_ID
, LN.REQUEST_ID
, CMA.GL_DATE
, DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT
, NULL
, ROUND(AMOUNT
, 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 TO_NUMBER('')
, RA.CUSTOMER_TRX_LINE_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.REQUEST_ID
, RA.GL_DATE
, DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT
, NULL
, ROUND(AMOUNT
, PRECISION)
, ROUND(AMOUNT
, FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) )
, RA.QUANTITY
, NULL
, PERIOD_SET_NAME
FROM AR_REVENUE_ASSIGNMENTS RA
, FND_CURRENCIES FC
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES CTL
WHERE ACCOUNT_CLASS = 'REV'
AND RA.CUSTOMER_TRX_LINE_ID = CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
AND CT.CUSTOMER_TRX_ID = CTL.PREVIOUS_CUSTOMER_TRX_ID
AND FC.CURRENCY_CODE = CT.INVOICE_CURRENCY_CODE