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