EBS:资产期间状态查询

EBS 资产期间状态查询 

-- 资产期间状态
select 140 AS application_id,
       'OFA' APPLICATION_SHORT_NAME,
       301 AS ORGANIZATION_ID,
      2141 AS LEDGER_ID, 
      FDP.PERIOD_NAME,
      case WHEN FDP.PERIOD_CLOSE_DATE IS NULL THEN '打开' 
       else '关闭'
      end  AS SHOW_STATUS ,
      FDP.PERIOD_OPEN_DATE AS LAST_UPDATE_DATE ,
      -1 AS last_updated_by
 from fa_deprn_periods FDP 
where book_type_code like 'FA_BOOK_CUX'
AND FDP.PERIOD_CLOSE_DATE IS NULL
ORDER BY PERIOD_NAME