Total Pageviews

October 18, 2019

10/18/2019 01:57:00 PM
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
  
 
Related Posts Plugin for WordPress, Blogger...