VIEW: APPS.FND_REQUEST_SET_STAGES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.SET_APPLICATION_ID , B.REQUEST_SET_ID , B.REQUEST_SET_STAGE_ID , B.STAGE_NAME , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.CRITICAL , B.OUTCOME , B.ALLOW_CONSTRAINTS_FLAG , B.DISPLAY_SEQUENCE , B.FUNCTION_APPLICATION_ID , B.FUNCTION_ID , B.SUCCESS_LINK , B.WARNING_LINK , B.ERROR_LINK , B.CONCURRENT_PROGRAM_ID , B.X , B.Y , B.ICON_NAME , T.USER_STAGE_NAME , T.DESCRIPTION FROM FND_REQUEST_SET_STAGES_TL T, FND_REQUEST_SET_STAGES B WHERE B.REQUEST_SET_ID = T.REQUEST_SET_ID AND B.SET_APPLICATION_ID = T.SET_APPLICATION_ID AND B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SET_APPLICATION_ID
, B.REQUEST_SET_ID
, B.REQUEST_SET_STAGE_ID
, B.STAGE_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CRITICAL
, B.OUTCOME
, B.ALLOW_CONSTRAINTS_FLAG
, B.DISPLAY_SEQUENCE
, B.FUNCTION_APPLICATION_ID
, B.FUNCTION_ID
, B.SUCCESS_LINK
, B.WARNING_LINK
, B.ERROR_LINK
, B.CONCURRENT_PROGRAM_ID
, B.X
, B.Y
, B.ICON_NAME
, T.USER_STAGE_NAME
, T.DESCRIPTION
FROM FND_REQUEST_SET_STAGES_TL T
, FND_REQUEST_SET_STAGES B
WHERE B.REQUEST_SET_ID = T.REQUEST_SET_ID
AND B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
AND B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
AND T.LANGUAGE = USERENV('LANG')