FND Design Data [Home] [Help]

View: PA_GL_PERIODS_V

Product: PA - Projects
Description: Displays details about GL periods.
Implementation/DBA Data: ViewAPPS.PA_GL_PERIODS_V
View Text

SELECT PS.PERIOD_NAME
, PS.START_DATE
, PS.END_DATE
, I.ORG_ID
FROM GL_PERIOD_STATUSES PS
, PA_IMPLEMENTATIONS I
WHERE I.SET_OF_BOOKS_ID = PS.SET_OF_BOOKS_ID
AND PS.APPLICATION_ID =PA_PERIOD_PROCESS_PKG.APPLICATION_ID
AND PS.ADJUSTMENT_PERIOD_FLAG = 'N'

Columns

Name
GL_PERIOD_NAME
START_DATE
END_DATE
ORG_ID