VIEW: APPS.AR_CASH_RECEIPTS_MRC_V

Source

View Text - Preformatted

SELECT PRIMARY.cash_receipt_id, mc.set_of_books_id, mc.exchange_rate_type, mc.exchange_rate, mc.exchange_date, last_updated_by, last_update_date, last_update_login, created_by, creation_date, amount, currency_code, receivables_trx_id, pay_from_customer, status, TYPE, receipt_number, receipt_date, misc_payment_source, comments, distribution_set_id, reversal_date, reversal_category, reversal_reason_code, reversal_comments, attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, remittance_bank_account_id, attribute11, attribute12, attribute13, attribute14, attribute15, confirmed_flag, customer_bank_account_id, customer_site_use_id, deposit_date, program_application_id, program_id, program_update_date, receipt_method_id, request_id, selected_for_factoring_flag, selected_remittance_batch_id, factor_discount_amount, ussgl_transaction_code, ussgl_transaction_code_context, doc_sequence_value, doc_sequence_id, vat_tax_id, reference_type, reference_id, customer_receipt_reference, override_remit_account_flag, org_id, anticipated_clearing_date, global_attribute1, global_attribute2, global_attribute3, global_attribute4, global_attribute5, global_attribute6, global_attribute7, global_attribute8, global_attribute9, global_attribute10, global_attribute11, global_attribute12, global_attribute13, global_attribute14, global_attribute15, global_attribute16, global_attribute17, global_attribute18, global_attribute19, global_attribute20, global_attribute_category, issuer_name, issue_date, issuer_bank_branch_id, customer_bank_branch_id, payment_server_order_num, approval_code, address_verification_code, tax_rate, actual_value_date, postmark_date FROM ar_cash_receipts PRIMARY, ar_mc_cash_receipts mc WHERE PRIMARY.cash_receipt_id = mc.cash_receipt_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_ID
, MC.SET_OF_BOOKS_ID
, MC.EXCHANGE_RATE_TYPE
, MC.EXCHANGE_RATE
, MC.EXCHANGE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, AMOUNT
, CURRENCY_CODE
, RECEIVABLES_TRX_ID
, PAY_FROM_CUSTOMER
, STATUS
, TYPE
, RECEIPT_NUMBER
, RECEIPT_DATE
, MISC_PAYMENT_SOURCE
, COMMENTS
, DISTRIBUTION_SET_ID
, REVERSAL_DATE
, REVERSAL_CATEGORY
, REVERSAL_REASON_CODE
, REVERSAL_COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REMITTANCE_BANK_ACCOUNT_ID
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONFIRMED_FLAG
, CUSTOMER_BANK_ACCOUNT_ID
, CUSTOMER_SITE_USE_ID
, DEPOSIT_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RECEIPT_METHOD_ID
, REQUEST_ID
, SELECTED_FOR_FACTORING_FLAG
, SELECTED_REMITTANCE_BATCH_ID
, FACTOR_DISCOUNT_AMOUNT
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, DOC_SEQUENCE_VALUE
, DOC_SEQUENCE_ID
, VAT_TAX_ID
, REFERENCE_TYPE
, REFERENCE_ID
, CUSTOMER_RECEIPT_REFERENCE
, OVERRIDE_REMIT_ACCOUNT_FLAG
, ORG_ID
, ANTICIPATED_CLEARING_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, ISSUER_NAME
, ISSUE_DATE
, ISSUER_BANK_BRANCH_ID
, CUSTOMER_BANK_BRANCH_ID
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE
, TAX_RATE
, ACTUAL_VALUE_DATE
, POSTMARK_DATE
FROM AR_CASH_RECEIPTS PRIMARY
, AR_MC_CASH_RECEIPTS MC
WHERE PRIMARY.CASH_RECEIPT_ID = MC.CASH_RECEIPT_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)