VIEW: APPS.OKC_QUE_LSNR_V

Source

View Text - Preformatted

SELECT R.REQUEST_ID, DECODE (R.DESCRIPTION, NULL,PT.USER_CONCURRENT_PROGRAM_NAME,R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') Listener, PB.CONCURRENT_PROGRAM_NAME Concurrent_Program, okc_util.decode_lookup('CP_PHASE_CODE', R.PHASE_CODE ) Phase, R.PHASE_CODE, okc_util.decode_lookup('CP_STATUS_CODE',R.STATUS_CODE ) Status, R.STATUS_CODE, R.RESPONSIBILITY_APPLICATION_ID Application_ID, R.REQUEST_DATE Submission_date, U.USER_NAME, R.COMPLETION_TEXT FROM FND_CONCURRENT_PROGRAMS_TL PT, FND_CONCURRENT_PROGRAMS PB, FND_USER U, FND_CONCURRENT_REQUESTS R WHERE PB.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND PB.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND PB.APPLICATION_ID = PT.APPLICATION_ID AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID AND PT.LANGUAGE = USERENV('LANG') AND U.USER_ID = R.REQUESTED_BY AND ( R.PHASE_CODE <> 'C' OR ( R.PHASE_CODE = 'C' and R.STATUS_CODE = 'E' ) ) and PB.CONCURRENT_PROGRAM_NAME in ('OKCRAQO', 'OKCRAQE')

View Text - HTML Formatted

SELECT R.REQUEST_ID
, DECODE (R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') LISTENER
, PB.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM
, OKC_UTIL.DECODE_LOOKUP('CP_PHASE_CODE'
, R.PHASE_CODE ) PHASE
, R.PHASE_CODE
, OKC_UTIL.DECODE_LOOKUP('CP_STATUS_CODE'
, R.STATUS_CODE ) STATUS
, R.STATUS_CODE
, R.RESPONSIBILITY_APPLICATION_ID APPLICATION_ID
, R.REQUEST_DATE SUBMISSION_DATE
, U.USER_NAME
, R.COMPLETION_TEXT
FROM FND_CONCURRENT_PROGRAMS_TL PT
, FND_CONCURRENT_PROGRAMS PB
, FND_USER U
, FND_CONCURRENT_REQUESTS R
WHERE PB.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
AND PB.APPLICATION_ID = PT.APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID
AND PT.LANGUAGE = USERENV('LANG')
AND U.USER_ID = R.REQUESTED_BY
AND ( R.PHASE_CODE <> 'C' OR ( R.PHASE_CODE = 'C'
AND R.STATUS_CODE = 'E' ) )
AND PB.CONCURRENT_PROGRAM_NAME IN ('OKCRAQO'
, 'OKCRAQE')