Query to find out from Mass Addition which is not yet converted into Fixed assets from any Source
Fixed Assets - EBS 12.2.8
select b.FEEDER_SYSTEM_NAME,a.mass_addition_id, a.creation_date,a.asset_number,a.invoice_number,a.invoice_date, a.vendor_number,
a.PO_number,a.description "DESCRIPTION",a.fixed_assets_cost,a.payables_cost,a.queue_name,a.POSTING_STATUS
from fa_mass_additions A, FA_ASSET_INVOICES B
where A.invoice_Date is not null
and A.book_type_code=<Asset Book Name of Company>
and a.queue_name in ('SPLIT','ON HOLD','NEW')
--and a.invoice_number = 00580--
--and b.FEEDER_SYSTEM_NAME ='11i Oracle Assets'
and b.FEEDER_SYSTEM_NAME in ('11i Oracle Assets','DDA CORPORATE','DDA STORES','ORACLE PAYABLES','Spreadsheet')