What are the SQL Queries Used for the details of Claim amount
I want get the details of claim amount and link to offer.
but i found the amount in below sql didn't equal to OZF_CLAIMS_ALL.amount.
How can i get the details of the OZF_CLAIMS_ALL.amount?
SELECT cust_name ,pay.claim_num , OFFER.offer_code , pay.claim_date , SUM(Pay.Amount ) aa ,pay.currency_code ,qh.descriptiON OFFER_NAME ,qh.comments FROM (SELECT cLU.amount ,CLA.currency_code ,cla.claim_date ,DECODE (UTIL.cust_account_id ,1117206,'TW-EXP-TO-NAR Dummy') cust_name ,CLA.claim_number claim_num ,UTIL.plan_id ,UTIL.Gl_Posted_Flag ,CLU.UTILIZATION_ID FROM APPS.OZF_CLAIMS_ALL CLA |
Tagged:
0