VIEW: APPS.BIS_RS_ALL_RUNS_REQIDS_V

Source

View Text - Preformatted

SELECT distinct B.request_ID id, B.request_id value, B.request_set_id rsid, (sysdate-B.last_update_date) DAYS, B.request_set_type rstype from BIS_RS_RUN_HISTORY B WHERE B.PHASE_CODE= 'C' and B.STATUS_CODE <> 'X'
   

View Text - HTML Formatted

SELECT DISTINCT B.REQUEST_ID ID
, B.REQUEST_ID VALUE
, B.REQUEST_SET_ID RSID
, (SYSDATE-B.LAST_UPDATE_DATE) DAYS
, B.REQUEST_SET_TYPE RSTYPE
FROM BIS_RS_RUN_HISTORY B
WHERE B.PHASE_CODE= 'C'
AND B.STATUS_CODE <> 'X'