Assets

To Query Asset Locations
========================

SELECT asset_number,  fv.description country,fv1.description city
  FROM fa_additions fa,
       fa_distribution_history fdh,
       fa_locations fl,
       fnd_flex_values_vl fv,
       fnd_flex_values_vl fv1
 WHERE fa.asset_id = fdh.asset_id
   AND fdh.location_id = fl.location_id
   AND fv.flex_value(+) = fl.segment1
   AND fv1.flex_value(+) = fl.segment3
   AND asset_number = '478069'