VIEW: APPS.FND_AMP_REQUESTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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