EAM for Aviation Doubts

Dears,

Please I need your help to get better approach on below points:

Instance : we are using Oracle apps R12.1.3, database Oracle 11.1.0.7

1- An aircraft is defined as an asset, when WO created and closed it makes the subject of a spare part installation. EOD I need to get all installed parts(Actively installed, not installed then removed) list.

2-In the aircraft when a spare part is installed the location where installed we need to give an ID, how to do that? for example an aircraft is using two batteries first called battery left and second battery right both are using same item code and different SN#. If battery issued from inventory to aircraft we need to know where installed in the right or left location. Aircraft component location is unique and can contain only one inventory part. At the end we will get a list of aircraft component locations and its related installed part SN#s.