Product: | FND - Application Object Library |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.FND_REQUEST_SET_STAGES_VL |
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')