How to get Asset details from GL_JE_HEADERS table with period range ?

Hello Expert,

I want to get data for given Period Range for Asset, but unable to get it ? can you please help me ?

If Provide same Period then query gives me result.

My query is :

SELECT UNIQUE

   -- fad.asset_id,

    GCC.SEGMENT1,

    HOU.name,

    fad.ASSET_NUMBER,

  fak.segment4 Equipment,

  fcb.segment2 Equipment_Category,

  gcc.segment5 Cost_Center,

  fl.SEGMENT1 Country,

  fl.SEGMENT2 State,

  fl.SEGMENT3 City,

  fl.SEGMENT4 County,

  fl.SEGMENT5 Address,

  FL.SEGMENT6 ZIP,

  --fbv.BOOK_TYPE_CODE,

  fbv.cost Current_Value,

  FBV.ORIGINAL_COST ORIGINAL_VALUE

    ,GJH.PERIOD_NAME

    ,GJH.POSTED_DATE

    ,GJH.DATE_CREATED

  FROM fa_additions fad,