Sunday, March 20, 2016

Query to get the Customer Name, Account number, Transaction number , Receipt and Amount details

SELECT
  hca.account_number ,
  hp.party_name ,
  rcta.trx_number ,
  acra.receipt_number ,
  RCTA.TRX_DATE ,
  ACRA.CREATION_DATE ,
  acra.amount
FROM
HZ_PARTIES HP ,
HZ_CUST_ACCOUNTS HCA ,
RA_CUSTOMER_TRX_ALL RCTA ,
ar_cash_receipts_all acra ,
ar_receivable_applications_all aaa
WHERE AAA.APPLICATION_TYPE = 'CASH'
AND HP.PARTY_ID              = HCA.PARTY_ID
and RCTA.SOLD_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND AAA.CASH_RECEIPT_ID = ACRA.CASH_RECEIPT_ID
AND AAA.APPLIED_CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID

and acra.receipt_number      ='453753';

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect