SELECT probability_value , probability_value FROM as_forecast_prob_all_b WHERE trunc(start_date_active) <= trunc(SYSDATE) AND trunc(NVL(end_date_active, SYSDATE)) >= trunc(SYSDATE) AND enabled_flag = 'Y'
View Text - HTML Formatted
SELECT PROBABILITY_VALUE , PROBABILITY_VALUE FROM AS_FORECAST_PROB_ALL_B WHERE TRUNC(START_DATE_ACTIVE) <= TRUNC(SYSDATE) AND TRUNC(NVL(END_DATE_ACTIVE , SYSDATE)) >= TRUNC(SYSDATE) AND ENABLED_FLAG = 'Y'