VIEW: APPS.AR_MISC_CASH_DISTRIBUTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'