SELECT R.REQUEST_ID, PB.CONCURRENT_PROGRAM_NAME,
PT.USER_CONCURRENT_PROGRAM_NAME,
FU.USER_NAME,
FL.MEANING PHASE_CODE,
FL1.MEANING STATUS_CODE,
R.ARGUMENT_TEXT PARAMETERS,
R.REQUEST_DATE,
R.ACTUAL_START_DATE,
R.ACTUAL_COMPLETION_DATE
FROM FND_CONCURRENT_PROGRAMS_TL PT,
FND_CONCURRENT_PROGRAMS PB,
FND_CONCURRENT_REQUESTS R,
FND_LOOKUPS FL,
FND_LOOKUPS FL1,
FND_USER FU
WHERE 1=1
AND PB.APPLICATION_ID = PT.APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID
AND PT.LANGUAGE = USERENV ('LANG')
AND PB.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
AND FL.LOOKUP_TYPE='CP_PHASE_CODE'
AND FL.LOOKUP_CODE=R.PHASE_CODE
AND FL1.LOOKUP_TYPE='CP_STATUS_CODE'
AND FL1.LOOKUP_CODE=R.STATUS_CODE
AND R.REQUESTED_BY=FU.USER_ID
AND PB.CONCURRENT_PROGRAM_NAME='BOMR018'