VIEW: AR.AR_MISC_CASH_DISTRIBUTIONS_AL#

Source

View Text - Preformatted

select MISC_CASH_DISTRIBUTION_ID MISC_CASH_DISTRIBUTION_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, CASH_RECEIPT_ID CASH_RECEIPT_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, GL_DATE GL_DATE, PERCENT PERCENT, AMOUNT AMOUNT, COMMENTS COMMENTS, GL_POSTED_DATE GL_POSTED_DATE, APPLY_DATE APPLY_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, POSTING_CONTROL_ID POSTING_CONTROL_ID, ACCTD_AMOUNT ACCTD_AMOUNT, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT, CREATED_FROM CREATED_FROM, REVERSAL_GL_DATE REVERSAL_GL_DATE, ORG_ID ORG_ID, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT, EVENT_ID EVENT_ID, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID from "AR"."AR_MISC_CASH_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT MISC_CASH_DISTRIBUTION_ID MISC_CASH_DISTRIBUTION_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GL_DATE GL_DATE
, PERCENT PERCENT
, AMOUNT AMOUNT
, COMMENTS COMMENTS
, GL_POSTED_DATE GL_POSTED_DATE
, APPLY_DATE APPLY_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, ACCTD_AMOUNT ACCTD_AMOUNT
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT USSGL_TRANSACTION_CODE_CONTEXT
, CREATED_FROM CREATED_FROM
, REVERSAL_GL_DATE REVERSAL_GL_DATE
, ORG_ID ORG_ID
, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE
, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID
, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT
, EVENT_ID EVENT_ID
, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
FROM "AR"."AR_MISC_CASH_DISTRIBUTIONS_ALL"