View: FND_AMP_REQUESTS_V

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

View Text

SELECT R.REQUEST_ID
, DECODE ( R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ( '||PT.USER_CONCURRENT_PROGRAM_NAME||' ) ' ) PROGRAM
, R.PHASE_CODE
, R.STATUS_CODE
, FND_AMP_PRIVATE.GET_PHASE ( R.PHASE_CODE
, R.STATUS_CODE
, R.HOLD_FLAG
, P.ENABLED_FLAG
, R.REQUESTED_START_DATE
, R.REQUEST_ID ) PHASE
, FND_AMP_PRIVATE.GET_STATUS ( R.PHASE_CODE
, R.STATUS_CODE
, R.HOLD_FLAG
, P.ENABLED_FLAG
, R.REQUESTED_START_DATE
, R.REQUEST_ID ) STATUS
, U.USER_NAME
, RT.RESPONSIBILITY_NAME
, AT.APPLICATION_NAME
, R.REQUESTED_START_DATE
, R.ACTUAL_START_DATE
, R.ACTUAL_COMPLETION_DATE
, R.REQUEST_DATE
, R.PRIORITY
, R.ARGUMENT_TEXT
, R.ORACLE_SESSION_ID
, R.COMPLETION_TEXT
, R.CONTROLLING_MANAGER
, R.SINGLE_THREAD_FLAG
, R.REQUESTED_BY
, R.REQUEST_LIMIT
, R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID
, R.IS_SUB_REQUEST
, R.PARENT_REQUEST_ID
, R.QUEUE_METHOD_CODE
, R.CD_ID
, R.HOLD_FLAG
, P.RUN_ALONE_FLAG
, P.ENABLED_FLAG
, P.CONCURRENT_PROGRAM_NAME
, P.USER_CONCURRENT_PROGRAM_NAME
, R.OS_PROCESS_ID
, R.NLS_LANGUAGE
, R.NLS_TERRITORY
, R.NLS_NUMERIC_CHARACTERS
, R.DESCRIPTION
FROM FND_CONCURRENT_PROGRAMS_TL PT
, FND_RESPONSIBILITY_TL RT
, FND_APPLICATION_TL AT
, FND_CONCURRENT_PROGRAMS_VL P
, FND_USER U
, FND_CONCURRENT_REQUESTS R
WHERE R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
AND PT.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
AND PT.APPLICATION_ID = P.APPLICATION_ID
AND PT.LANGUAGE = USERENV ( 'LANG' )
AND U.USER_ID = R.REQUESTED_BY
AND RT.APPLICATION_ID = R.RESPONSIBILITY_APPLICATION_ID
AND RT.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
AND RT.LANGUAGE = USERENV ( 'LANG' )
AND AT.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
AND AT.LANGUAGE = USERENV ( 'LANG' )

Columns