EBS:资产期间状态查询

EBS 资产期间状态查询 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

-- 资产期间状态 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