View: FA_PRRUN_PERIODS_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_PRRUN_PERIODS_V

View Text

SELECT CP.PERIOD_NAME P_NAME
, CP.PERIOD_NUM P_NUM
, FY.FISCAL_YEAR F_YEAR
, CP2.PERIOD_NUM P2_NUM
, FY2.FISCAL_YEAR F2_YEAR
, CT.NUMBER_PER_FISCAL_YEAR NUMBER_PER_FY
, CP.CALENDAR_TYPE CALENDAR_TYPE
, CP.START_DATE START_DATE
FROM FA_FISCAL_YEAR FY
, FA_FISCAL_YEAR FY2
, FA_CALENDAR_PERIODS CP
, FA_CALENDAR_PERIODS CP2
, FA_CALENDAR_TYPES CT
WHERE CP.START_DATE BETWEEN FY.START_DATE
AND FY.END_DATE
AND FY.FISCAL_YEAR_NAME = CT.FISCAL_YEAR_NAME
AND CT.CALENDAR_TYPE = CP.CALENDAR_TYPE
AND CP.CALENDAR_TYPE = CP2.CALENDAR_TYPE
AND FY2.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
AND CP2.START_DATE BETWEEN FY2.START_DATE
AND FY2.END_DATE

Columns