View: OKL_CONC_REQUESTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CONC_REQUESTS_UV

View Text

SELECT R.ROWID ROW_ID
, R.REQUEST_ID
, R.PHASE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CP_PHASE_CODE'
, R.PHASE_CODE
, 0
, 0) PHASE_MEANING
, R.STATUS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CP_STATUS_CODE'
, R.STATUS_CODE
, 0
, 0) STATUS_MEANING
, R.PRIORITY_REQUEST_ID
, TRUNC(R.REQUEST_DATE) REQUEST_DATE
, TO_CHAR(R.REQUEST_DATE
, 'DD/MM/YYYY HH:MI:SS AM') REQUEST_DATE_DISPLAY
, R.REQUESTED_BY
, TRUNC(R.REQUESTED_START_DATE) REQUESTED_START_DATE
, TO_CHAR(R.REQUESTED_START_DATE
, 'DD/MM/YYYY HH:MI:SS AM') REQUESTED_START_DATE_DISPLAY
, TRUNC(R.ACTUAL_START_DATE) ACTUAL_START_DATE
, TO_CHAR(R.ACTUAL_START_DATE
, 'DD/MM/YYYY HH:MI:SS AM') ACTUAL_START_DATE_DISPLAY
, TRUNC(R.ACTUAL_COMPLETION_DATE) ACTUAL_COMPLETION_DATE
, TO_CHAR(R.ACTUAL_COMPLETION_DATE
, 'DD/MM/YYYY HH:MI:SS AM') ACTUAL_COMPLETION_DATE_DISPLAY
, R.COMPLETION_TEXT
, R.ARGUMENT_TEXT
, PT.USER_CONCURRENT_PROGRAM_NAME
, U.USER_NAME REQUESTOR
, R.LOGFILE_NAME
, R.OUTFILE_NAME
, FLT.DESCRIPTION LANGUAGE
, NULL LOG_URL
, NULL OUTPUT_URL
, NULL DIAGNOSTICS
FROM FND_CONCURRENT_PROGRAMS PB
, FND_CONCURRENT_PROGRAMS_TL PT
, FND_CONCURRENT_REQUESTS R
, FND_LANGUAGES FL
, FND_LANGUAGES_TL FLT
, FND_USER U
WHERE 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 U.USER_ID = R.REQUESTED_BY
AND R.NLS_LANGUAGE = FL.NLS_LANGUAGE
AND FL.LANGUAGE_CODE = FLT.LANGUAGE_CODE
AND FLT.LANGUAGE = USERENV('LANG')

Columns