VIEW: APPS.FND_CONC_REQ_SUMMARY_V

Source

View Text - Preformatted

SELECT R.ROWID ROW_ID , R.REQUEST_ID , R.PHASE_CODE , R.STATUS_CODE , R.PRIORITY_REQUEST_ID , R.PRIORITY , R.REQUEST_DATE , R.REQUESTED_BY , R.REQUESTED_START_DATE , R.HOLD_FLAG , R.HAS_SUB_REQUEST , R.IS_SUB_REQUEST , R.UPDATE_PROTECTED , R.QUEUE_METHOD_CODE , R.RESPONSIBILITY_APPLICATION_ID , R.RESPONSIBILITY_ID , R.SAVE_OUTPUT_FLAG , R.LAST_UPDATE_DATE , R.LAST_UPDATED_BY , R.LAST_UPDATE_LOGIN , R.PRINTER , R.PRINT_STYLE , R.PARENT_REQUEST_ID , R.CONTROLLING_MANAGER , R.ACTUAL_START_DATE , R.ACTUAL_COMPLETION_DATE , R.COMPLETION_TEXT , R.ARGUMENT_TEXT , R.IMPLICIT_CODE , R.REQUEST_TYPE , R.PROGRAM_APPLICATION_ID , R.CONCURRENT_PROGRAM_ID , PB.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME , PB.EXECUTION_METHOD_CODE , PB.ENABLED_FLAG ENABLED , DECODE (R.DESCRIPTION, NULL, PT.USER_CONCURRENT_PROGRAM_NAME, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') PROGRAM , PB.PRINTER_NAME FCP_PRINTER , PB.OUTPUT_PRINT_STYLE FCP_PRINT_STYLE , PB.REQUIRED_STYLE FCP_REQUIRED_STYLE , U.USER_NAME REQUESTOR , S.USER_PRINTER_STYLE_NAME USER_PRINT_STYLE , R.DESCRIPTION DESCRIPTION , PT.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_PROGRAMS_TL PT, FND_CONCURRENT_PROGRAMS PB, FND_USER U, FND_PRINTER_STYLES_TL S, 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 S.PRINTER_STYLE_NAME(+) = R.PRINT_STYLE AND S.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.REQUEST_ID
, R.PHASE_CODE
, R.STATUS_CODE
, R.PRIORITY_REQUEST_ID
, R.PRIORITY
, R.REQUEST_DATE
, R.REQUESTED_BY
, R.REQUESTED_START_DATE
, R.HOLD_FLAG
, R.HAS_SUB_REQUEST
, R.IS_SUB_REQUEST
, R.UPDATE_PROTECTED
, R.QUEUE_METHOD_CODE
, R.RESPONSIBILITY_APPLICATION_ID
, R.RESPONSIBILITY_ID
, R.SAVE_OUTPUT_FLAG
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
, R.PRINTER
, R.PRINT_STYLE
, R.PARENT_REQUEST_ID
, R.CONTROLLING_MANAGER
, R.ACTUAL_START_DATE
, R.ACTUAL_COMPLETION_DATE
, R.COMPLETION_TEXT
, R.ARGUMENT_TEXT
, R.IMPLICIT_CODE
, R.REQUEST_TYPE
, R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID
, PB.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME
, PB.EXECUTION_METHOD_CODE
, PB.ENABLED_FLAG ENABLED
, DECODE (R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') PROGRAM
, PB.PRINTER_NAME FCP_PRINTER
, PB.OUTPUT_PRINT_STYLE FCP_PRINT_STYLE
, PB.REQUIRED_STYLE FCP_REQUIRED_STYLE
, U.USER_NAME REQUESTOR
, S.USER_PRINTER_STYLE_NAME USER_PRINT_STYLE
, R.DESCRIPTION DESCRIPTION
, PT.USER_CONCURRENT_PROGRAM_NAME USER_CONCURRENT_PROGRAM_NAME
FROM FND_CONCURRENT_PROGRAMS_TL PT
, FND_CONCURRENT_PROGRAMS PB
, FND_USER U
, FND_PRINTER_STYLES_TL S
, 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 S.PRINTER_STYLE_NAME(+) = R.PRINT_STYLE
AND S.LANGUAGE(+) = USERENV('LANG')