Payables and Cash Management - EBS (MOSC)

MOSC Banner

rows duplicating in query reuslt

edited Feb 26, 2013 5:49AM in Payables and Cash Management - EBS (MOSC) 8 commentsAnswered
Hi,
If we create a query and the output of query show duplicate rows,so what does it mean?how can i find the problem.

Below is my created query but it shows 4 rows ,it should be show only 2 rows.mean 2 rows are duplicating

SELECT *
FROM gl_import_references gli 
, xla_ae_lines xll 
, xla_ae_headers xlh 
, xla_distribution_links xld 
, ap_invoices_all api 
, ap_invoice_lines_all apl 
, ap_invoice_distributions_all adp 
, gl_je_lines jel 
, gl_je_headers jeh 
WHERE 1 = 1 
AND api.invoice_id = apl.invoice_id 
AND apl.invoice_id = adp.invoice_id 
AND apl.line_number = adp.invoice_line_number 

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