View: AR_CR_INF_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CR_INF_V

View Text

SELECT CR.CASH_RECEIPT_ID
, PTY.PARTY_NAME
, CA.ACCOUNT_NUMBER
, CR.RECEIPT_NUMBER
, CR.DOC_SEQUENCE_VALUE
, CR.RECEIPT_DATE
, ARM.NAME
FROM AR_CASH_RECEIPTS_ALL CR
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PTY
, AR_RECEIPT_METHODS ARM
WHERE CR.PAY_FROM_CUSTOMER = CA.CUST_ACCOUNT_ID(+)
AND CA.PARTY_ID = PTY.PARTY_ID(+)
AND CR.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID

Columns