A query to link between the financial inquiry and source line in the ASSET workbench

Hello Dears,

We need to select this columns

ASSET_ID,

VENDOR_NAME,

INVOICE_NUMBER,

FIXED_ASSETS_COST 

INVOICE_DATE

for all the transaction that happened in a certain year (the transaction date in a certain year) for all the asset

i use this query :"

select t.ASSET_ID,

     pv.VENDOR_NAME,

     t.INVOICE_NUMBER,

     t.AP_DISTRIBUTION_LINE_NUMBER INVOICE_LINE,

     t.FIXED_ASSETS_COST         INVOICE_LINE_AMOUNT,

     t.INVOICE_DATE

 from FA.FA_ASSET_INVOICES# t, APPS.PO_VENDORS PV

 where pv.VENDOR_ID = t.PO_VENDOR_ID

 and (t.INVOICE_DATE between to_date('1/1/2019', 'dd/mm/yyyy') and