ERPstuff - Oracle EBS Community

I want to generate Location wise Asset List. I need to know the SQL for that.

My requirement is

1. Asset No.
2.Description.
3.DPIS.
4.Location Details.

Thanks is advance.

Thanks.

Amitava

SELECT fab.asset_number, fab.serial_number, fab.tag_number,
fb.date_placed_in_service,
fl.segment1
|| '-'
|| fl.segment2
|| '-'
|| fl.segment3
|| '-'
|| fl.segment4
|| '-'
|| fl.segment5
|| '-'
|| fl.segment6 LOCATION
FROM fa_additions_b fab,
fa_books_v fb,
fa_distribution_history fdh,
fa_locations fl
WHERE fab.asset_id = fb.asset_id
AND fdh.asset_id = fab.asset_id
AND fdh.location_id = fl.location_id
AND asset_number = &asset_number