VIEW: APPS.BIL_TX_PERIOD_NAME_V

Source

View Text - Preformatted

SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM) ,period_name ,period_type ,start_date ,end_date FROM gl_periods WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR') AND sysdate BETWEEN ADD_MONTHS(start_date, -6) AND ADD_MONTHS(end_date, 6) AND ADJUSTMENT_PERIOD_FLAG = 'N' ORDER BY start_date

View Text - HTML Formatted

SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM)
, 1
, 0||QUARTER_NUM
, QUARTER_NUM)||DECODE(LENGTH(PERIOD_NUM)
, 1
, 0||PERIOD_NUM
, PERIOD_NUM)
, PERIOD_NAME
, PERIOD_TYPE
, START_DATE
, END_DATE
FROM GL_PERIODS
WHERE PERIOD_SET_NAME = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
AND SYSDATE BETWEEN ADD_MONTHS(START_DATE
, -6)
AND ADD_MONTHS(END_DATE
, 6)
AND ADJUSTMENT_PERIOD_FLAG = 'N' ORDER BY START_DATE