<select id="getInfoByTempAc01" parameterClass="string" resultClass="java.util.HashMap">
select b.aab001,
c.aab069,
a.aac001,
a.aac003,
a.aac147,
a.aac998,
a.aac007,
b.aac049,
b.aae206,
b.aae140,
a.aic162,
a.aac060
from ac01 a, ac02 b, ae10 c, temp_ac01 d
where a.aac001 = b.aac001(+)
and b.aab001 = c.aaz001(+)
and A.AAC001 = d.aac001 OR A.AAC998 = d.aac001 OR A.AAC147 = d.aac001
and d.hdid = #hdid#
</select>