View: PA_FP_PERIODS_V

Product:	PA - Projects
Description:	This view is used in Financial Planning webadi download to get all the planning periods detail.
Implementation/DBA Data:	APPS.PA_FP_PERIODS_V

View Text

SELECT ROW_NUMBER() OVER( PARTITION BY PIM.ORG_ID
, GL.PERIOD_SET_NAME
, GL.PERIOD_TYPE ORDER BY GL.START_DATE ) RN
, GL.START_DATE START_DATE
, GL.END_DATE END_DATE
, GL.PERIOD_NAME PERIOD_NAME
, GL.PERIOD_TYPE PERIOD_TYPE
, GL.PERIOD_SET_NAME PERIOD_SET_NAME
, GSB.PERIOD_SET_NAME GL_PERIOD_SET_NAME
, PIM.PERIOD_SET_NAME PA_PERIOD_SET_NAME
, PIM.PA_PERIOD_TYPE PA_PERIOD_TYPE
, GSB.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, PIM.ORG_ID
FROM GL_PERIODS GL
, PA_IMPLEMENTATIONS_ALL PIM
, GL_SETS_OF_BOOKS GSB
WHERE GSB.SET_OF_BOOKS_ID=PIM.SET_OF_BOOKS_ID
AND GL.ADJUSTMENT_PERIOD_FLAG ='N'

Columns