VIEW: APPS.AR_CASH_RECEIPT_HIST_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, PRIMARY.status, PRIMARY.trx_date, PRIMARY.amount, PRIMARY.postable_flag, PRIMARY.factor_flag, PRIMARY.gl_date, PRIMARY.current_record_flag, PRIMARY.batch_id, PRIMARY.account_code_combination_id, PRIMARY.reversal_gl_date, PRIMARY.reversal_cash_receipt_hist_id, PRIMARY.factor_discount_amount, PRIMARY.bank_charge_account_ccid, PRIMARY.last_update_login, PRIMARY.created_by, PRIMARY.creation_date, PRIMARY.last_update_date, PRIMARY.program_application_id, PRIMARY.program_id, PRIMARY.program_update_date, PRIMARY.request_id, MC.last_updated_by, PRIMARY.prv_stat_cash_receipt_hist_id, PRIMARY.reversal_created_from, PRIMARY.attribute1, PRIMARY.attribute2, PRIMARY.attribute3, PRIMARY.attribute4, PRIMARY.attribute5, PRIMARY.attribute6, PRIMARY.attribute7, PRIMARY.attribute8, PRIMARY.attribute9, PRIMARY.attribute10, PRIMARY.attribute11, PRIMARY.attribute12, PRIMARY.attribute13, PRIMARY.attribute14, PRIMARY.attribute15, PRIMARY.attribute_category, PRIMARY.note_status, PRIMARY.org_id 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 NVL(PRIMARY.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99) 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
, PRIMARY.STATUS
, PRIMARY.TRX_DATE
, PRIMARY.AMOUNT
, PRIMARY.POSTABLE_FLAG
, PRIMARY.FACTOR_FLAG
, PRIMARY.GL_DATE
, PRIMARY.CURRENT_RECORD_FLAG
, PRIMARY.BATCH_ID
, PRIMARY.ACCOUNT_CODE_COMBINATION_ID
, PRIMARY.REVERSAL_GL_DATE
, PRIMARY.REVERSAL_CASH_RECEIPT_HIST_ID
, PRIMARY.FACTOR_DISCOUNT_AMOUNT
, PRIMARY.BANK_CHARGE_ACCOUNT_CCID
, PRIMARY.LAST_UPDATE_LOGIN
, PRIMARY.CREATED_BY
, PRIMARY.CREATION_DATE
, PRIMARY.LAST_UPDATE_DATE
, PRIMARY.PROGRAM_APPLICATION_ID
, PRIMARY.PROGRAM_ID
, PRIMARY.PROGRAM_UPDATE_DATE
, PRIMARY.REQUEST_ID
, MC.LAST_UPDATED_BY
, PRIMARY.PRV_STAT_CASH_RECEIPT_HIST_ID
, PRIMARY.REVERSAL_CREATED_FROM
, PRIMARY.ATTRIBUTE1
, PRIMARY.ATTRIBUTE2
, PRIMARY.ATTRIBUTE3
, PRIMARY.ATTRIBUTE4
, PRIMARY.ATTRIBUTE5
, PRIMARY.ATTRIBUTE6
, PRIMARY.ATTRIBUTE7
, PRIMARY.ATTRIBUTE8
, PRIMARY.ATTRIBUTE9
, PRIMARY.ATTRIBUTE10
, PRIMARY.ATTRIBUTE11
, PRIMARY.ATTRIBUTE12
, PRIMARY.ATTRIBUTE13
, PRIMARY.ATTRIBUTE14
, PRIMARY.ATTRIBUTE15
, PRIMARY.ATTRIBUTE_CATEGORY
, PRIMARY.NOTE_STATUS
, PRIMARY.ORG_ID
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 NVL(PRIMARY.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)