Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AR_CASH_RECEIPTS_MRC_V |
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)