View: BIS_RS_RUN_ALL_STAGES_V

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

View Text

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