View: ARBV_CASH_RECEIPTS

Product:	AR - Receivables
Description:	This shows information about receipts remitted by the customer as payment for goods or services.
Implementation/DBA Data:	APPS.ARBV_CASH_RECEIPTS

View Text

SELECT /* UNIQUE ATTRIBUTES */ CR.CASH_RECEIPT_ID
, /* REGULAR ATTRIBUTES */ CR.RECEIPT_NUMBER
, CR.AMOUNT
, CR.RECEIPT_DATE
, CR.DOC_SEQUENCE_VALUE
, CR.EXCHANGE_RATE
, CR.EXCHANGE_RATE_TYPE
, CR.EXCHANGE_DATE
, CR.DEPOSIT_DATE
, '_LA:CR.STATUS:AR_LOOKUPS:CHECK_STATUS:MEANING'
, '_LA:CR.REVERSAL_REASON_CODE:AR_LOOKUPS:CKAJST_REASON:MEANING'
, CR.REVERSAL_DATE
, CR.REVERSAL_COMMENTS
, '_LA:CR.REVERSAL_CATEGORY:AR_LOOKUPS:REVERSAL_CATEGORY_TYPE:MEANING'
, CR.CUSTOMER_RECEIPT_REFERENCE
, '_LA:CR.SELECTED_FOR_FACTORING_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CR.FACTOR_DISCOUNT_AMOUNT
, '_LA:CR.OVERRIDE_REMIT_ACCOUNT_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CR.ANTICIPATED_CLEARING_DATE
, CR.ISSUER_NAME
, CR.ISSUE_DATE
, CR.COMMENTS
, CR.USSGL_TRANSACTION_CODE
, /* IDS */ CR.ORG_ID
, CR.CURRENCY_CODE
, CR.RECEIPT_METHOD_ID
, CR.PAY_FROM_CUSTOMER
, CR.CUSTOMER_SITE_USE_ID
, CR.REMITTANCE_BANK_ACCOUNT_ID
, CR.CUSTOMER_BANK_ACCOUNT_ID
, CR.ISSUER_BANK_BRANCH_ID
, CR.SET_OF_BOOKS_ID
, /* WHO COLUMNS */ CR.LAST_UPDATE_DATE
, CR.LAST_UPDATED_BY
, CR.CREATION_DATE
, CR.CREATED_BY
, CR.STATUS
FROM AR_CASH_RECEIPTS CR
WHERE CR.TYPE = 'CASH' WITH READ ONLY

Columns