View: ARFV_CASH_RECEIPTS

Product:	AR - Receivables
Description:	This shows information about payments remitted by the customer as payment for goods or services.
Implementation/DBA Data:	APPS.ARFV_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
, '_DF:AR:AR_CASH_RECEIPTS:CR'
, '_DF:JG:JG_AR_CASH_RECEIPTS:CR'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, CUR.DESCRIPTION
, RM.NAME
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, SU.LOCATION
, RBB.BANK_NAME
, RBB.BANK_BRANCH_NAME
, RBA.BANK_ACCOUNT_NUM
, DECODE(EXTN.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, CBA.BANK_NAME
, 'CREDITCARD'
, CBA.CARD_ISSUER_NAME
, NULL)
, DECODE(EXTN.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, CBA.BRANCH_NAME
, NULL)
, DECODE(EXTN.INSTRUMENT_TYPE
, 'BANKACCOUNT'
, CBA.ACCOUNT_NUMBER
, 'CREDITCARD'
, CBA.CARD_NUMBER
, NULL)
, NBB.BANK_NAME
, NBB.BANK_BRANCH_NAME
, /* IDS */ CR.ORG_ID
, CR.CURRENCY_CODE
, CR.RECEIPT_METHOD_ID
, CR.PAY_FROM_CUSTOMER
, CR.CUSTOMER_SITE_USE_ID
, CR.REMIT_BANK_ACCT_USE_ID
, CR.PAYMENT_TRXN_EXTENSION_ID
, CR.ISSUER_BANK_BRANCH_ID
, /* WHO COLUMNS */ CR.LAST_UPDATE_DATE
, CR.LAST_UPDATED_BY
, CR.CREATION_DATE
, CR.CREATED_BY
FROM AR_CASH_RECEIPTS CR
, HR_ALL_ORGANIZATION_UNITS AOU
, FND_CURRENCIES_VL CUR
, AR_RECEIPT_METHODS RM
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_SITE_USES SU
, CE_BANK_ACCT_USES_ALL USES
, CE_BANK_ACCOUNTS RBA
, CE_BANK_BRANCHES_V RBB
, IBY_FNDCPT_PAYER_ASSGN_INSTR_V CBA
, IBY_TRXN_EXTENSIONS_V EXTN
, CE_BANK_BRANCHES_V NBB
WHERE CR.TYPE = 'CASH'
AND CR.ORG_ID = AOU.ORGANIZATION_ID(+)
AND CR.CURRENCY_CODE = CUR.CURRENCY_CODE
AND CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND CR.PAY_FROM_CUSTOMER = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CR.CUSTOMER_SITE_USE_ID = SU.SITE_USE_ID(+)
AND CR.REMIT_BANK_ACCT_USE_ID = USES.BANK_ACCT_USE_ID
AND RBA.BANK_ACCOUNT_ID=USES.BANK_ACCOUNT_ID
AND RBB.BRANCH_PARTY_ID = RBA.BANK_BRANCH_ID
AND CR.PAYMENT_TRXN_EXTENSION_ID=EXTN.TRXN_EXTENSION_ID(+)
AND EXTN.INSTRUMENT_ID = CBA.INSTRUMENT_ID(+)
AND EXTN.INSTR_ASSIGNMENT_ID = CBA.INSTR_ASSIGNMENT_ID(+)
AND CR.ISSUER_BANK_BRANCH_ID = NBB.BRANCH_PARTY_ID(+)
AND PARTY.PARTY_ID(+) = CUST_ACCT.PARTY_ID WITH READ ONLY

Columns