Channel Revenue Management - EBS (MOSC)

MOSC Banner

What are the SQL Queries Used for the details of Claim amount

edited May 8, 2019 5:07AM in Channel Revenue Management - EBS (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center