--库存会计期
SELECT STATUS
,PERIOD_NAME
,PERIOD_NUMBER
,PERIOD_YEAR
,START_DATE
,END_DATE
,CLOSE_DATE
,REC_TYPE
,ORGANIZATION_ID
,ACCT_PERIOD_ID
,ROW_ID
,ACCOUNTED_PERIOD_TYPE
,PERIOD_SET_NAME
,LAST_UPDATE_DATE
,CREATION_DATE
,LAST_UPDATED_BY
,CREATED_BY
,LAST_UPDATE_LOGIN
FROM ORG_ACCT_PERIODS_V
WHERE (REC_TYPE = 'ORG_PERIOD' AND ORGANIZATION_ID = 4942)
--采购与总账会计期
SELECT ROW_ID
,APPLICATION_ID
,SET_OF_BOOKS_ID
,CLOSING_STATUS
,SHOW_STATUS
,PERIOD_NAME
,PERIOD_NUM
,PERIOD_YEAR
,START_DATE
,END_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,CREATION_DATE
,PERIOD_TYPE
,QUARTER_NUM
,ADJUSTMENT_PERIOD_FLAG
,CREATED_BY
,LAST_UPDATE_LOGIN
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,CONTEXT
FROM GL_PERIOD_STATUSES_V
WHERE APPLICATION_ID = 101
AND SET_OF_BOOKS_ID = 143
AND CLOSING_STATUS != 'N'
AND (PERIOD_NAME = 'Feb-12')
ORDER BY PERIOD_YEAR DESC
,PERIOD_NUM DESC