SELECT RCTA.TRX_NUMBER "invoice number"
,rcta.TRX_DATE "invoice date"
,acra.RECEIPT_NUMBER "receipt number"
,acra.RECEIPT_DATE "receipt date"
,acra.AMOUNT "receipt amount"
,acra.CURRENCY_CODE "currency code"
,arm.NAME "payment method"
,hp.PARTY_NAMe "customer name"
FROM RA_CUSTOMER_TRX_ALL RCTA
,HZ_CUST_ACCOUNTS HCA
,AR_CASH_RECEIPTS_ALL ACRA
,ar_receipt_methods arm
,hz_parties hp
WHERE RCTA.TRX_NUMBER='10020757'
AND HCA.CUST_ACCOUNT_ID=RCTA.SHIP_TO_CUSTOMER_ID
AND ACRA.PAY_FROM_CUSTOMER=HCA.CUST_ACCOUNT_ID
and arm.RECEIPT_METHOD_ID=acra.RECEIPT_METHOD_ID
and hp.PARTY_ID=hca.PARTY_ID
,rcta.TRX_DATE "invoice date"
,acra.RECEIPT_NUMBER "receipt number"
,acra.RECEIPT_DATE "receipt date"
,acra.AMOUNT "receipt amount"
,acra.CURRENCY_CODE "currency code"
,arm.NAME "payment method"
,hp.PARTY_NAMe "customer name"
FROM RA_CUSTOMER_TRX_ALL RCTA
,HZ_CUST_ACCOUNTS HCA
,AR_CASH_RECEIPTS_ALL ACRA
,ar_receipt_methods arm
,hz_parties hp
WHERE RCTA.TRX_NUMBER='10020757'
AND HCA.CUST_ACCOUNT_ID=RCTA.SHIP_TO_CUSTOMER_ID
AND ACRA.PAY_FROM_CUSTOMER=HCA.CUST_ACCOUNT_ID
and arm.RECEIPT_METHOD_ID=acra.RECEIPT_METHOD_ID
and hp.PARTY_ID=hca.PARTY_ID