VIEW: APPS.PA_FP_PERIODS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'