Query : To get the asset detail information

SELECT DISTINCT a.asset_number,
a.description,
a.asset_type,
d.segment1 asset_key,
c.segment1 major_category,
c.segment2 minor_category,
b.deprn_method_code,
b.life_in_months/12 life,
b.book_type_code,
b.date_placed_in_service,
b.depreciate_flag,
b.cost,
h.units_assigned UNITS,
g.segment1 COMPANY,
g.segment2 DEPARTMENT,
g.segment3 ACCOUNT,
l.segment1 country,
l.segment2 state,
l.segment3 city,
L.SEGMENT4 BUILDING
FROM fa_additions a,
fa_books_v b,
fa_categories c,
fa_asset_keywords d,
gl_code_combinations g,
fa_distribution_history h,
fa_locations l
WHERE a.asset_id = b.asset_id
AND a.asset_id = h.asset_id
AND a.asset_category_id = c.category_id
AND h.code_combination_id = g.code_combination_id
AND h.location_id = l.location_id
AND a.asset_key_ccid = d.CODE_COMBINATION_ID
AND b.book_type_code LIKE ' CORP BOOK'
AND H.TRANSACTION_HEADER_ID_OUT IS NULL