VIEW: APPS.AR_CASH_RECEIPT_HIST_ALL_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)