VIEW: APPS.BIS_REQUEST_SET_OPTIONS_V

Source

View Text - Preformatted

SELECT decode(f.user_request_set_name, null, b.request_set_name||'(DELETED)', f.user_request_set_name) user_request_set_name , b.request_set_name, b.set_app_id, b.option_name, flk.meaning user_option_name, b.option_value, decode(b.option_name, 'REFRESH_MODE', BIS_REQUESTSET_VIEWHISTORY.get_bis_lookup_meaning( 'BIS_REFRESH_MODE', b.option_value), BIS_REQUESTSET_VIEWHISTORY.get_sys_lookup_meaning( 'YES_NO', b.option_value) ) user_option_value from fnd_request_sets_vl f , bis_request_set_options b , fnd_common_lookups flk WHERE f. request_set_name(+)=b. request_set_name and flk.lookup_type='BIS_RSG_OPTION' and flk.enabled_flag='Y' and flk.lookup_code=b.option_name
   

View Text - HTML Formatted

SELECT DECODE(F.USER_REQUEST_SET_NAME
, NULL
, B.REQUEST_SET_NAME||'(DELETED)'
, F.USER_REQUEST_SET_NAME) USER_REQUEST_SET_NAME
, B.REQUEST_SET_NAME
, B.SET_APP_ID
, B.OPTION_NAME
, FLK.MEANING USER_OPTION_NAME
, B.OPTION_VALUE
, DECODE(B.OPTION_NAME
, 'REFRESH_MODE'
, BIS_REQUESTSET_VIEWHISTORY.GET_BIS_LOOKUP_MEANING( 'BIS_REFRESH_MODE'
, B.OPTION_VALUE)
, BIS_REQUESTSET_VIEWHISTORY.GET_SYS_LOOKUP_MEANING( 'YES_NO'
, B.OPTION_VALUE) ) USER_OPTION_VALUE
FROM FND_REQUEST_SETS_VL F
, BIS_REQUEST_SET_OPTIONS B
, FND_COMMON_LOOKUPS FLK
WHERE F. REQUEST_SET_NAME(+)=B. REQUEST_SET_NAME
AND FLK.LOOKUP_TYPE='BIS_RSG_OPTION'
AND FLK.ENABLED_FLAG='Y'
AND FLK.LOOKUP_CODE=B.OPTION_NAME