what is the part ID's for these?
select t1.part_id from parts as t1 join asset_parts as t2 on t1.part_id = t2.part_id group by t1.part_name
and the chargeable amount for these?
select chargeable_amount from parts as t1 join asset_parts as t2 on t1.part_id = t2.part_id group by t1.part_name