VIEW: APPS.OKL_CONC_REQUESTS_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')