View: OKC_QUE_WF_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_QUE_WF_V

View Text

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 = 'FNDWFBG'
AND R.ARGUMENT1 = 'OKCALERT'

Columns