SQL query not selecting records
As Mihai said, use a LEFT JOIN on feat_attrib_type_4 and feat_attrib_type_5.  Either old style (as you have) or ANSI joins style would work.  For the former add (+) after every reference to a column in the where clause from those two aliases.  For the latter, convert the statement to ANSI join syntax and add LEFT before the word JOIN for those two tables.