VIEW: APPS.BIS_RS_NAMES_V

Source

View Text - Preformatted

SELECT b.request_set_ID id, user_request_set_name value, sysdate-max(B.last_update_date) days, request_set_type rstype from BIS_RS_RUN_HISTORY B, FND_REQUEST_SETS_VL F WHERE F.request_set_id = B.request_set_id AND B.PHASE_CODE ='C' and B.STATUS_CODE <> 'X' group by b.request_set_ID , user_request_set_name,request_set_type
   

View Text - HTML Formatted

SELECT B.REQUEST_SET_ID ID
, USER_REQUEST_SET_NAME VALUE
, SYSDATE-MAX(B.LAST_UPDATE_DATE) DAYS
, REQUEST_SET_TYPE RSTYPE
FROM BIS_RS_RUN_HISTORY B
, FND_REQUEST_SETS_VL F
WHERE F.REQUEST_SET_ID = B.REQUEST_SET_ID
AND B.PHASE_CODE ='C'
AND B.STATUS_CODE <> 'X' GROUP BY B.REQUEST_SET_ID
, USER_REQUEST_SET_NAME
, REQUEST_SET_TYPE