AR_CM_NET_REV_ASSIGNMENTS_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CUSTOMER_TRX_LINE_ID PREVIOUS_CUSTOMER_TRX_LINE_ID PREVIOUS_CUSTOMER_TRX_ID GL_DATE AMOUNT QUANTITY CREDIT_METHOD_FOR_RULES PERIOD_SET_NAME

Query

SQL_Statement

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 ) ) /* amount */ , 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, RA.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 ) ), /* amount */ 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