VIEW: APPS.AR_CR_INF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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