VIEW: APPS.BIS_RS_TYPE_V

Source

View Text - Preformatted

SELECT Request_set_id rsid, REQUEST_SET_TYPE ID, BIS_REQUESTSET_VIEWHISTORY.get_sys_lookup_meaning( 'BIS_REQUEST_SET_TYPE',request_set_type) value from BIS_RS_RUN_HISTORY B WHERE B.PHASE_CODE ='C' and B.STATUS_CODE <> 'X' group by request_set_id,request_set_type
   

View Text - HTML Formatted

SELECT REQUEST_SET_ID RSID
, REQUEST_SET_TYPE ID
, BIS_REQUESTSET_VIEWHISTORY.GET_SYS_LOOKUP_MEANING( 'BIS_REQUEST_SET_TYPE'
, REQUEST_SET_TYPE) VALUE
FROM BIS_RS_RUN_HISTORY B
WHERE B.PHASE_CODE ='C'
AND B.STATUS_CODE <> 'X' GROUP BY REQUEST_SET_ID
, REQUEST_SET_TYPE