VIEW: APPS.FA_PRRUN_PERIODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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