VIEW: APPS.BIS_SET_PROCESSES_V

Source

View Text - Preformatted

SELECT c.row_id row_id, a.application_id set_application_id, d1.application_short_name set_app_short_name, a.REQUEST_SET_ID REQUEST_SET_ID, a.REQUEST_SET_NAME REQUEST_SET_NAME, a.USER_REQUEST_SET_NAME USER_REQUEST_SET_NAME, b.REQUEST_SET_STAGE_ID REQUEST_SET_STAGE_ID, e.stage_name stage_name, b.SEQUENCE prog_SEQUENCE, c.APPLICATION_ID PROG_APPLICATION_ID, d2.application_short_name prog_app_short_name, c.CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID, c.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_NAME, c.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME, c.LAST_UPDATE_DATE, c.LAST_UPDATED_BY, c.CREATION_DATE, c.CREATED_BY, c.LAST_UPDATE_LOGIN, bis_submit_requestset.get_parameter_flag(c.CONCURRENT_PROGRAM_NAME,c.application_id) parameter_flag from fnd_request_sets_vl a, fnd_request_set_programs b, fnd_concurrent_programs_vl c, fnd_application d1, fnd_application d2, fnd_request_set_stages e WHERE a.APPLICATION_ID=b.SET_APPLICATION_ID and a.REQUEST_SET_ID=b.REQUEST_SET_ID and b.PROGRAM_APPLICATION_ID=c.APPLICATION_ID and b.CONCURRENT_PROGRAM_ID=c.CONCURRENT_PROGRAM_ID and a.application_id=d1.application_id and c.application_id=d2.application_id and b.set_application_id=e.set_application_id and b.request_set_id=e.request_set_id and b.request_set_stage_id=e.request_set_stage_id

View Text - HTML Formatted

SELECT C.ROW_ID ROW_ID
, A.APPLICATION_ID SET_APPLICATION_ID
, D1.APPLICATION_SHORT_NAME SET_APP_SHORT_NAME
, A.REQUEST_SET_ID REQUEST_SET_ID
, A.REQUEST_SET_NAME REQUEST_SET_NAME
, A.USER_REQUEST_SET_NAME USER_REQUEST_SET_NAME
, B.REQUEST_SET_STAGE_ID REQUEST_SET_STAGE_ID
, E.STAGE_NAME STAGE_NAME
, B.SEQUENCE PROG_SEQUENCE
, C.APPLICATION_ID PROG_APPLICATION_ID
, D2.APPLICATION_SHORT_NAME PROG_APP_SHORT_NAME
, C.CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID
, C.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_NAME
, C.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_LOGIN
, BIS_SUBMIT_REQUESTSET.GET_PARAMETER_FLAG(C.CONCURRENT_PROGRAM_NAME
, C.APPLICATION_ID) PARAMETER_FLAG
FROM FND_REQUEST_SETS_VL A
, FND_REQUEST_SET_PROGRAMS B
, FND_CONCURRENT_PROGRAMS_VL C
, FND_APPLICATION D1
, FND_APPLICATION D2
, FND_REQUEST_SET_STAGES E
WHERE A.APPLICATION_ID=B.SET_APPLICATION_ID
AND A.REQUEST_SET_ID=B.REQUEST_SET_ID
AND B.PROGRAM_APPLICATION_ID=C.APPLICATION_ID
AND B.CONCURRENT_PROGRAM_ID=C.CONCURRENT_PROGRAM_ID
AND A.APPLICATION_ID=D1.APPLICATION_ID
AND C.APPLICATION_ID=D2.APPLICATION_ID
AND B.SET_APPLICATION_ID=E.SET_APPLICATION_ID
AND B.REQUEST_SET_ID=E.REQUEST_SET_ID
AND B.REQUEST_SET_STAGE_ID=E.REQUEST_SET_STAGE_ID