SQL & PL/SQL

Hi All,

Working in EBS Version 11.5.10.2

In this below query has same quote number with two quote versions, and can be any number for versions.

in the report we are showing only the last version

here in this case if the attributes has the data in first version and not in second version then we have to display the data in last version(2 version)

please need some help to achieve result

EXAMPLE :
----------------
QUOTE_NUMBER QUOTE_VERSION ATTRIBUTE11 ATTRIBUTE12

102469 1 2013/05/20 00:00:00 2013/05/19 00:00:00
102469 2

select ash.quote_number
,ash.quote_version
,asl.attribute11
,asl.attribute12
from aso_quote_headers_all ash
,aso_quote_lines_all asl
where ash.quote_header_id = asl.quote_header_id
and ash.quote_header_id in (117796, 117958)
and asl.line_number = 10000

Regards