VIEW: APPS.BIS_BIA_REQUESTSET_V

Source

View Text - Preformatted

SELECT request_set_name ID, user_request_set_name VALUE FROM fnd_request_sets_vl WHERE request_set_name IN ( SELECT DISTINCT a.request_set_name FROM bis_request_set_options a WHERE option_name = 'REFRESH_MODE' AND option_value = 'INCR' OR option_value = 'INIT') ORDER BY user_request_set_name

View Text - HTML Formatted

SELECT REQUEST_SET_NAME ID
, USER_REQUEST_SET_NAME VALUE
FROM FND_REQUEST_SETS_VL
WHERE REQUEST_SET_NAME IN ( SELECT DISTINCT A.REQUEST_SET_NAME
FROM BIS_REQUEST_SET_OPTIONS A
WHERE OPTION_NAME = 'REFRESH_MODE'
AND OPTION_VALUE = 'INCR' OR OPTION_VALUE = 'INIT') ORDER BY USER_REQUEST_SET_NAME