Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Query result shows duplicate records, what is the issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query result shows duplicate records, what is the issue

Accepted answer
16
Views
9
Comments
edited Jul 16, 2020 6:10AM in Reporting and Analytics for ERP 9 comments

Summary

Query result shows duplicate records, what is the issue

Content

 

Query result shows duplicate records, what is the issue?

select a.ORG_ID
, d.PARTY_SITE_NUMBER
, c.PARTY_NAME
, c.CITY
, a.TRX_NUMBER
, to_char(a.TRX_DATE, 'dd.mm.yyyy') TRX_DATE
, b.EXTENDED_AMOUNT
from RA_CUSTOMER_TRX_ALL a
, RA_CUSTOMER_TRX_LINES_ALL b
, HZ_PARTIES c
, HZ_PARTY_SITES d
where
a.CUSTOMER_TRX_ID = b.CUSTOMER_TRX_ID
and a.SHIP_TO_PARTY_ID = c.PARTY_ID
and c.PARTY_ID = d.PARTY_ID
and a.ORG_ID IN (300000002015095,300000002015255)
and a.TRX_DATE BETWEEN :P_From_Date and :P_To_Date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!