View: FND_CONC_REQ_SUMMARY_V

Product:	FND - Application Object Library
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FND_CONC_REQ_SUMMARY_V

View Text

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

Columns