AR_CR_INF_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CASH_RECEIPT_ID PARTY_NAME ACCOUNT_NUMBER RECEIPT_NUMBER DOC_SEQUENCE_VALUE RECEIPT_DATE NAME BU_NAME

Query

SQL_Statement

SELECT cr.cash_receipt_id , pty.party_name , ca.account_number , cr.receipt_number , cr.doc_sequence_value, cr.receipt_date , arm.NAME , bu.bu_name FROM ar_cash_receipts_all cr, hz_cust_accounts ca , hz_parties pty , ar_receipt_methods arm , fun_all_business_units_v bu 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 AND cr.org_id = bu.bu_id