View: BIS_REQUEST_SET_OPTIONS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_REQUEST_SET_OPTIONS_V

View Text

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