Home » Developer & Programmer » Reports & Discoverer » Query get duplicate values in Oracle discoverer 4i (Discoverer 4i windowsXP)
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.
Previous Topic: Generate to File - Delimited problem
Next Topic: Switching between two queries in report
Goto Forum:
  


Current Time: Thu Dec 08 03:58:56 CST 2016

Total time taken to generate the page: 0.09489 seconds