[Home] [Help]
View: 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
Name |
P_NAME |
P_NUM |
F_YEAR |
P2_NUM |
F2_YEAR |
NUMBER_PER_FY |
CALENDAR_TYPE |
START_DATE |