DBA Data[Home] [Help]

VIEW: APPS.BIL_TX_PERIOD_TYPE_ALL_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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