SELECT DISTINCT period_type ,user_period_type ,number_per_fiscal_year FROM gl_periods_v WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR') union all select 'Day' ID, 'Day' VALUE, 365 NUMBER_PER from dual
SELECT DISTINCT PERIOD_TYPE
, USER_PERIOD_TYPE
, NUMBER_PER_FISCAL_YEAR
FROM GL_PERIODS_V
WHERE PERIOD_SET_NAME = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR') UNION ALL SELECT 'DAY' ID
, 'DAY' VALUE
, 365 NUMBER_PER
FROM DUAL
|
|
|