Product: | FND - Application Object Library |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FND_REQ_SET_STAGES_FORM_V |
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.SUCCESS_LINK
, B.WARNING_LINK
, B.ERROR_LINK
, B.OUTCOME
, B.CRITICAL
, B.ALLOW_CONSTRAINTS_FLAG
, B.CONCURRENT_PROGRAM_ID
, B.X
, B.Y
, B.ICON_NAME
, B.DISPLAY_SEQUENCE
, B.FUNCTION_ID
, B.FUNCTION_APPLICATION_ID
, E.USER_EXECUTABLE_NAME
, A.APPLICATION_NAME
, T.DESCRIPTION
, T.USER_STAGE_NAME
, T3.USER_STAGE_NAME SUCCESS_LINK_NAME
, T4.USER_STAGE_NAME WARNING_LINK_NAME
, T5.USER_STAGE_NAME ERROR_LINK_NAME
, L.MEANING OUTCOME_MEANING
FROM FND_REQUEST_SET_STAGES B
, FND_REQUEST_SET_STAGES_TL T
, FND_LOOKUPS L
, FND_REQUEST_SET_STAGES_TL T3
, FND_REQUEST_SET_STAGES_TL T4
, FND_REQUEST_SET_STAGES_TL T5
, FND_APPLICATION_VL A
, FND_EXECUTABLES_VL E
WHERE B.SET_APPLICATION_ID = T.SET_APPLICATION_ID
AND B.REQUEST_SET_ID = T.REQUEST_SET_ID
AND B.REQUEST_SET_STAGE_ID = T.REQUEST_SET_STAGE_ID
AND T.LANGUAGE = USERENV('LANG')
AND L.LOOKUP_CODE = B.OUTCOME
AND L.LOOKUP_TYPE = 'CP_SET_OUTCOME'
AND T3.SET_APPLICATION_ID(+) = B.SET_APPLICATION_ID
AND T3.REQUEST_SET_ID(+) = B.REQUEST_SET_ID
AND T3.REQUEST_SET_STAGE_ID(+) = B.SUCCESS_LINK
AND T3.LANGUAGE(+) = USERENV('LANG')
AND T4.SET_APPLICATION_ID(+) = B.SET_APPLICATION_ID
AND T4.REQUEST_SET_ID(+) = B.REQUEST_SET_ID
AND T4.REQUEST_SET_STAGE_ID(+) = B.WARNING_LINK
AND T4.LANGUAGE(+) = USERENV('LANG')
AND T5.SET_APPLICATION_ID(+) = B.SET_APPLICATION_ID
AND T5.REQUEST_SET_ID(+) = B.REQUEST_SET_ID
AND T5.REQUEST_SET_STAGE_ID(+) = B.ERROR_LINK
AND T5.LANGUAGE(+) = USERENV('LANG')
AND A.APPLICATION_ID(+) = B.FUNCTION_APPLICATION_ID
AND E.APPLICATION_ID(+) = B.FUNCTION_APPLICATION_ID
AND E.EXECUTABLE_ID(+) = B.FUNCTION_ID