View: AR_CASH_RECEIPT_HIST_ALL_MRC_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CASH_RECEIPT_HIST_ALL_MRC_V

View Text

SELECT PRIMARY.CASH_RECEIPT_HISTORY_ID
, MC.SET_OF_BOOKS_ID
, PRIMARY.CASH_RECEIPT_ID
, PRIMARY.FIRST_POSTED_RECORD_FLAG
, MC.POSTING_CONTROL_ID
, PRIMARY.REVERSAL_POSTING_CONTROL_ID
, MC.GL_POSTED_DATE
, MC.REVERSAL_GL_POSTED_DATE
, MC.ACCTD_AMOUNT
, MC.ACCTD_FACTOR_DISCOUNT_AMOUNT
, MC.EXCHANGE_DATE
, MC.EXCHANGE_RATE
, MC.EXCHANGE_RATE_TYPE
, PRIMARY.CREATED_FROM
, STATUS
, TRX_DATE
, AMOUNT
, POSTABLE_FLAG
, FACTOR_FLAG
, GL_DATE
, CURRENT_RECORD_FLAG
, BATCH_ID
, ACCOUNT_CODE_COMBINATION_ID
, REVERSAL_GL_DATE
, REVERSAL_CASH_RECEIPT_HIST_ID
, FACTOR_DISCOUNT_AMOUNT
, BANK_CHARGE_ACCOUNT_CCID
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.LAST_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRIMARY.LAST_UPDATED_BY
, PRV_STAT_CASH_RECEIPT_HIST_ID
, REVERSAL_CREATED_FROM
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, NOTE_STATUS
, ORG_ID
, MRC_POSTING_CONTROL_ID
, MRC_GL_POSTED_DATE
, MRC_REVERSAL_GL_POSTED_DATE
, MRC_ACCTD_AMOUNT
, MRC_ACCTD_FACTOR_DISC_AMOUNT
, MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE
FROM AR_CASH_RECEIPT_HISTORY_ALL PRIMARY
, AR_MC_CASH_RECEIPT_HIST MC
WHERE PRIMARY.CASH_RECEIPT_HISTORY_ID = MC.CASH_RECEIPT_HISTORY_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)

Columns