View: AR_MISC_CASH_DISTRIBUTIONS_V

Product:	AR - Receivables
Description:	(Release 115 Only)
Implementation/DBA Data:	APPS.AR_MISC_CASH_DISTRIBUTIONS_V

View Text

SELECT /* PURPOSE: THE VIEW AR_MISC_CASH_DISTRIBUTIONS_V IS USED IN THE */ /* MISC CASH DISTRIBUTIONS WINDOW OF THE RECEIPT GATEWAY */ MCD.ROWID ROW_ID
, MCD.MISC_CASH_DISTRIBUTION_ID MISC_CASH_DISTRIBUTION_ID
, MCD.CASH_RECEIPT_ID CASH_RECEIPT_ID
, MCD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, MCD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, MCD.PERCENT PERCENT
, DECODE(SIGN(MCD.AMOUNT)
, 1
, SIGN(MCD.AMOUNT)*DIST.AMOUNT_CR
, -1
, SIGN(MCD.AMOUNT)*DIST.AMOUNT_DR
, 0
, SIGN(MCD.AMOUNT)*DIST.AMOUNT_CR) AMOUNT
, DECODE(SIGN(MCD.ACCTD_AMOUNT)
, 1
, SIGN(MCD.ACCTD_AMOUNT)*DIST.ACCTD_AMOUNT_CR
, -1
, SIGN(MCD.ACCTD_AMOUNT)*DIST.ACCTD_AMOUNT_DR
, 0
, SIGN(MCD.ACCTD_AMOUNT)*DIST.ACCTD_AMOUNT_CR) ACCTD_AMOUNT
, CR.CURRENCY_CODE CURRENCY_CODE
, CR.EXCHANGE_RATE EXCHANGE_RATE
, MCD.COMMENTS COMMENTS
, MCD.GL_POSTED_DATE GL_POSTED_DATE
, MCD.GL_DATE GL_DATE
, MCD.APPLY_DATE APPLY_DATE
, MCD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MCD.ATTRIBUTE1 ATTRIBUTE1
, MCD.ATTRIBUTE2 ATTRIBUTE2
, MCD.ATTRIBUTE3 ATTRIBUTE3
, MCD.ATTRIBUTE4 ATTRIBUTE4
, MCD.ATTRIBUTE5 ATTRIBUTE5
, MCD.ATTRIBUTE6 ATTRIBUTE6
, MCD.ATTRIBUTE7 ATTRIBUTE7
, MCD.ATTRIBUTE8 ATTRIBUTE8
, MCD.ATTRIBUTE9 ATTRIBUTE9
, MCD.ATTRIBUTE10 ATTRIBUTE10
, MCD.ATTRIBUTE11 ATTRIBUTE11
, MCD.ATTRIBUTE12 ATTRIBUTE12
, MCD.ATTRIBUTE13 ATTRIBUTE13
, MCD.ATTRIBUTE14 ATTRIBUTE14
, MCD.ATTRIBUTE15 ATTRIBUTE15
, MCD.POSTING_CONTROL_ID POSTING_CONTROL_ID
, MCD.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, /* ------------------------- WHO COLUMS: -------------------------- */ MCD.CREATED_BY CREATED_BY
, MCD.CREATION_DATE CREATION_DATE
, MCD.LAST_UPDATED_BY LAST_UPDATED_BY
, MCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MCD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MCD.REQUEST_ID REQUEST_ID
, MCD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MCD.PROGRAM_ID PROGRAM_ID
, MCD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MCD.REVERSAL_GL_DATE
FROM AR_MISC_CASH_DISTRIBUTIONS MCD
, AR_CASH_RECEIPTS CR
, AR_DISTRIBUTIONS DIST
, AR_SYSTEM_PARAMETERS ASP
WHERE CR.CASH_RECEIPT_ID = MCD.CASH_RECEIPT_ID
AND MCD.MISC_CASH_DISTRIBUTION_ID = DIST.SOURCE_ID
AND (DIST.SOURCE_TYPE = 'MISCCASH')
AND MCD.REVERSAL_GL_DATE IS NULL AND ASP.ACCOUNTING_METHOD= 'ACCRUAL' UNION ALL SELECT MCD.ROWID ROW_ID
, MCD.MISC_CASH_DISTRIBUTION_ID MISC_CASH_DISTRIBUTION_ID
, MCD.CASH_RECEIPT_ID CASH_RECEIPT_ID
, MCD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, MCD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, MCD.PERCENT PERCENT
, MCD.AMOUNT
, MCD.ACCTD_AMOUNT
, CR.CURRENCY_CODE CURRENCY_CODE
, CR.EXCHANGE_RATE EXCHANGE_RATE
, MCD.COMMENTS COMMENTS
, MCD.GL_POSTED_DATE GL_POSTED_DATE
, MCD.GL_DATE GL_DATE
, MCD.APPLY_DATE APPLY_DATE
, MCD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MCD.ATTRIBUTE1 ATTRIBUTE1
, MCD.ATTRIBUTE2 ATTRIBUTE2
, MCD.ATTRIBUTE3 ATTRIBUTE3
, MCD.ATTRIBUTE4 ATTRIBUTE4
, MCD.ATTRIBUTE5 ATTRIBUTE5
, MCD.ATTRIBUTE6 ATTRIBUTE6
, MCD.ATTRIBUTE7 ATTRIBUTE7
, MCD.ATTRIBUTE8 ATTRIBUTE8
, MCD.ATTRIBUTE9 ATTRIBUTE9
, MCD.ATTRIBUTE10 ATTRIBUTE10
, MCD.ATTRIBUTE11 ATTRIBUTE11
, MCD.ATTRIBUTE12 ATTRIBUTE12
, MCD.ATTRIBUTE13 ATTRIBUTE13
, MCD.ATTRIBUTE14 ATTRIBUTE14
, MCD.ATTRIBUTE15 ATTRIBUTE15
, MCD.POSTING_CONTROL_ID POSTING_CONTROL_ID
, MCD.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, /* ------------------------- WHO COLUMS: -------------------------- */ MCD.CREATED_BY CREATED_BY
, MCD.CREATION_DATE CREATION_DATE
, MCD.LAST_UPDATED_BY LAST_UPDATED_BY
, MCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MCD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MCD.REQUEST_ID REQUEST_ID
, MCD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MCD.PROGRAM_ID PROGRAM_ID
, MCD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MCD.REVERSAL_GL_DATE
FROM AR_MISC_CASH_DISTRIBUTIONS MCD
, AR_CASH_RECEIPTS CR
, AR_SYSTEM_PARAMETERS ASP
WHERE CR.CASH_RECEIPT_ID = MCD.CASH_RECEIPT_ID
AND ASP.ACCOUNTING_METHOD ='CASH'

Columns