OraFAQ Forum: Reports & Discoverer » Query get duplicate values in Oracle discoverer 4i

Home » Developer & Programmer » Reports & Discoverer » Query get duplicate values in Oracle discoverer 4i (Discoverer 4i windowsXP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query get duplicate values in Oracle discoverer 4i [message #392558]

Wed, 18 March 2009 07:11

p samarpan
Messages: 2
Registered: November 2004

Junior Member

Could you please anybody help me on this query.

If i run the query in its giving exact values but if i run in the discoverer 4i it is giving duplicate rows.

SELECT arc.receipt_number
, arc.receipt_date
, arc.comments
, arc.document_number
, arc.payment_method_dsp
, arc.customer_name
, arc.customer_number
, arc.deposit_date
, arc.receipt_status
, arc.deposit_date
, arc.remit_bank_account
, arc.application_notes
, ceh.statement_date
--, MIN (fnd.user_name)
, arc.functional_amount - arc.applied_amount unapplied
, arc.functional_amount
, arc.applied_amount
FROM ar_cash_receipts_v arc,
ce_statement_headers_all ceh
WHERE 1=1
AND arc.remittance_bank_account_id = ceh.bank_account_id
AND arc.receipt_status = 'UNAPP'
AND ( arc.functional_amount-arc.applied_amount) <> 0
GROUP BY arc.functional_amount - arc.applied_amount,
arc.functional_amount,
arc.receipt_number,
arc.receipt_date,
arc.receipt_status,
arc.comments,
arc.document_number,
arc.payment_method_dsp,
arc.customer_name,
arc.customer_number,
arc.deposit_date,
arc.remit_bank_account,
arc.applied_amount,
arc.application_notes,
ceh.statement_date;

Thanks to advice urgently

Samarpan.

Report message to a moderator

Previous Topic:	Generate to File - Delimited problem
Next Topic:	Switching between two queries in report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:52:36 CST 2024