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
标签：状态,NAME,PERIOD,查询,FDP,EBS,DATE From： https://www.cnblogs.com/samrv/p/16821980.html