Oracle EBS-SQL (INV-2):库存会计期间.sql
SELECT STATUS,
PERIOD_NAME,
PERIOD_NUMBER,
PERIOD_YEAR,
START_DATE,
END_DATE,
CLOSE_DATE,
REC_TYPE,
ORGANIZATION_ID
FROM ORG_ACCT_PERIODS_V
WHERE ((rec_type = 'ORG_PERIOD' ))
order by END_DATE desc