DBA Data[Home] [Help]

VIEW: APPS.BIL_TX_WIN_PROBABILITY_V

Source

View Text - Preformatted

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'