Install Base (IB) Important Queries in Oracle Apps R12

 --Get Address from IB Record

SELECT c.instance_id,

       c.serial_number,

       ca.party_id PartyId,

       ca.party_number,

       ca.party_name,

       ca.party_site_number,

       ca.address1,

       ca.address2,

       ca.address3,

       ca.address4,

       ca.city,

       ca.state,

       ca.zip PostalCode,

       ca.country,

       c.last_update_date IB_last_updated

FROM apps.csi_item_instances c,

         apps.csi_hzpty_addresses_v ca

WHERE     1 = 1

AND c.LOCATION_ID = ca.location --PARTY_SITE_ID

AND c.serial_number IN ('M9704CA9')

SELECT *

FROM APPS.CSI_INSTANCE_PARTY_V cipv, apps.csi_instance_details_v cidv

WHERE     1 = 1

AND cidv.instance_id = cipv.instance_id

--Query to get Bill To and Ship To from Install Base

select * from apps.CSI_INSTANCE_PARTY_V where instance_id ='28196679'