VIEW: APPS.FND_REQ_SET_STAGES_FORM_V

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.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

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.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