VIEW: APPS.ARBV_CASH_RECEIPTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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