VIEW: APPS.BIS_RS_RUN_ALL_STAGES_V

Source

View Text - Preformatted

SELECT S.REQUEST_id id, user_stage_name value,S.set_request_id srid, REQUEST_SET_TYPE rstype from FND_REQUEST_SET_STAGES_vl F, BIS_RS_STAGE_RUN_HISTORY S,BIS_RS_RUN_HISTORY B WHERE F.request_set_id = S.request_set_id AND F.request_set_stage_id = S.stage_id and B.request_id = S.set_request_id
   

View Text - HTML Formatted

SELECT S.REQUEST_ID ID
, USER_STAGE_NAME VALUE
, S.SET_REQUEST_ID SRID
, REQUEST_SET_TYPE RSTYPE
FROM FND_REQUEST_SET_STAGES_VL F
, BIS_RS_STAGE_RUN_HISTORY S
, BIS_RS_RUN_HISTORY B
WHERE F.REQUEST_SET_ID = S.REQUEST_SET_ID
AND F.REQUEST_SET_STAGE_ID = S.STAGE_ID
AND B.REQUEST_ID = S.SET_REQUEST_ID