Need Help Trouble Shooting One Issue - repost

Avg Bid (USD)
Project Budget (USD)
$3000 - $5000

Project Description:

I need some help finding root cause of an issue that I am working. For some reason one query in Production is doubling measure values when i use SUM and GROUP by functions. That is if i have 10 $ as sales when i use sum and group by it is appearing as 20$. I am using approx about 8 tables with some joins. Same query is working perfect in DEV environment.

Length of the query is probably around 55 to 60 lines

Skills required:
Oracle, SQL
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 3000
in 20 days
$ 3000
in 10 days
$ 5555
in 30 days
Hire BhargavaB
$ 3000
in 1 days
$ 4210
in 3 days
Hire brentmccaw
$ 3000
in 3 days
Hire iftiOracle
$ 3000
in 6 days
$ 3333
in 5 days
Hire manojmareedu
$ 3444
in 15 days
$ 4444
in 30 days