SELECT DISTINCT FCR.REQUEST_ID

,FCP.USER_CONCURRENT_PROGRAM_NAME

,fcr.argument_text

,fcr.description

,FCR.HOLD_FLAG

,FR.RESPONSIBILITY_NAME

--,FCR.REQUEST_ID

,FCR.ACTUAL_COMPLETION_DATE

,fu.user_name

-- ,FCR.*

FROM APPS.FND_CONCURRENT_REQUESTS FCR

,APPS.FND_CONCURRENT_PROGRAMS_TL FCP

,APPS.FND_RESPONSIBILITY_TL FR

,APPS.fnd_user fu

WHERE FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID

AND FCP.LANGUAGE='US'

AND FCR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID

AND FR.LANGUAGE='US'

AND FCP.USER_CONCURRENT_PROGRAM_NAME IN ('')

-- AND fcr.description LIKE 'GEPS%Auto%Invoice%'

-- and fcr.description like

AND FCR.PHASE_CODE='P'

-- AND FCR.STATUS_CODE='C'

AND fr.responsibility_name IN ('')

-- AND fcr.argument15 IN (10094,10095)

AND fu.user_id=fcr.requested_by

AND FCR.HOLD_FLAG = 'Y'

-- AND FCR.REQUEST_ID=24111243

-- AND FU.USER_NAME='$UNIVERSEPA'

--and (fu.end_date>sysdate or fu.end_date is null)

-- AND FCR.ARGUMENT1='PS_IFS_GE_Timecard'

ORDER BY FCP.USER_CONCURRENT_PROGRAM_NAME,FR.RESPONSIBILITY_NAME DESC

ITPub博客

Concurrent Programs EBS