View: FND_CONC_REQUESTS_FORM_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_CONC_REQUESTS_FORM_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.ENFORCE_SERIALITY_FLAG
, R.SINGLE_THREAD_FLAG
, R.HAS_SUB_REQUEST
, R.IS_SUB_REQUEST
, R.IMPLICIT_CODE
, R.UPDATE_PROTECTED
, R.QUEUE_METHOD_CODE
, R.ARGUMENT_INPUT_METHOD_CODE
, R.ORACLE_ID
, R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.RESPONSIBILITY_ID
, R.NUMBER_OF_ARGUMENTS
, R.NUMBER_OF_COPIES
, R.SAVE_OUTPUT_FLAG
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
, R.PRINTER
, R.PRINT_STYLE
, R.PRINT_GROUP
, R.REQUEST_CLASS_APPLICATION_ID
, R.CONCURRENT_REQUEST_CLASS_ID
, R.PARENT_REQUEST_ID
, R.CONC_LOGIN_ID
, R.LANGUAGE_ID
, R.DESCRIPTION
, R.REQ_INFORMATION
, R.RESUBMIT_INTERVAL
, R.RESUBMIT_INTERVAL_UNIT_CODE
, R.RESUBMIT_INTERVAL_TYPE_CODE
, R.RESUBMIT_TIME
, R.RESUBMIT_END_DATE
, R.RESUBMITTED
, R.CONTROLLING_MANAGER
, R.ACTUAL_START_DATE
, R.ACTUAL_COMPLETION_DATE
, R.COMPLETION_TEXT
, R.OUTCOME_PRODUCT
, R.OUTCOME_CODE
, R.CPU_SECONDS
, R.LOGICAL_IOS
, R.PHYSICAL_IOS
, R.LOGFILE_NAME
, R.LOGFILE_NODE_NAME
, R.OUTFILE_NAME
, R.OUTFILE_NODE_NAME
, R.ARGUMENT_TEXT
, R.ARGUMENT1
, R.ARGUMENT2
, R.ARGUMENT3
, R.ARGUMENT4
, R.ARGUMENT5
, R.ARGUMENT6
, R.ARGUMENT7
, R.ARGUMENT8
, R.ARGUMENT9
, R.ARGUMENT10
, R.ARGUMENT11
, R.ARGUMENT12
, R.ARGUMENT13
, R.ARGUMENT14
, R.ARGUMENT15
, R.ARGUMENT16
, R.ARGUMENT17
, R.ARGUMENT18
, R.ARGUMENT19
, R.ARGUMENT20
, R.ARGUMENT21
, R.ARGUMENT22
, R.ARGUMENT23
, R.ARGUMENT24
, R.ARGUMENT25
, R.NLS_LANGUAGE
, R.NLS_TERRITORY
, R.CRM_THRSHLD
, R.CRM_TSTMP
, R.CRITICAL
, R.REQUEST_TYPE
, R.ORACLE_PROCESS_ID
, R.ORACLE_SESSION_ID
, R.OS_PROCESS_ID
, R.PRINT_JOB_ID
, R.OUTPUT_FILE_TYPE
, R.RELEASE_CLASS_APP_ID
, R.RELEASE_CLASS_ID
, R.STALE_DATE
, R.CANCEL_OR_HOLD
, R.NOTIFY_ON_PP_ERROR
, R.NLS_COMPLIANT
, R.CD_ID
, R.REQUEST_LIMIT
, R.CRM_RELEASE_DATE
, R.POST_REQUEST_STATUS
, R.COMPLETION_CODE
, R.INCREMENT_DATES
, R.RESTART
, R.ENABLE_TRACE
, R.RESUB_COUNT
, R.NLS_CODESET
, R.OFILE_SIZE
, R.LFILE_SIZE
, R.STALE
, R.SECURITY_GROUP_ID
, CD.USER_CD_NAME
, PB.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME
, PB.EXECUTION_METHOD_CODE
, PB.QUEUE_METHOD_CODE FCP_QUEUE_METHOD_CODE
, PB.QUEUE_CONTROL_FLAG
, PB.RUN_ALONE_FLAG RUN_ALONE
, PB.ENABLED_FLAG ENABLED
, PB.SRS_FLAG SRS_FLAG
, DECODE (R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') PROGRAM
, PT.USER_CONCURRENT_PROGRAM_NAME
, PB.PRINTER_NAME FCP_PRINTER
, PB.OUTPUT_PRINT_STYLE FCP_PRINT_STYLE
, PB.REQUIRED_STYLE FCP_REQUIRED_STYLE
, AB.APPLICATION_SHORT_NAME
, AT.APPLICATION_NAME
, U.USER_NAME REQUESTOR
, S.USER_PRINTER_STYLE_NAME USER_PRINT_STYLE
, DECODE (R.PRIORITY_REQUEST_ID
, R.REQUEST_ID
, NULL
, R.PRIORITY_REQUEST_ID) PARENT
, L1.MEANING RESUBMIT_INTERVAL_UNIT
, L2.MEANING RESUBMIT_INTERVAL_TYPE
, U2.USER_NAME UPDATED_BY_NAME
, FND_CONC_REQUEST_PKG.ENCODE_ATTRIBUTE_ORDER( PB.SRS_FLAG
, R.REQUESTED_BY
, R.RESPONSIBILITY_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.PROGRAM_APPLICATION_ID
, PB.CONCURRENT_PROGRAM_NAME) ATTRIBUTE_ORDER
, FLT.DESCRIPTION LANGUAGE
, R.ORG_ID
, H.NAME
, CB.APPLICATION_ID SCH_APP_ID
, CB.RELEASE_CLASS_ID SCH_ID
, CB.RELEASE_CLASS_NAME SCH_NAME
, CT.DESCRIPTION SCH_DESCRIPTION
, CB.DATE1 SCH_DATE1
, CB.DATE2 SCH_DATE2
, CB.CLASS_TYPE SCH_TYPE
, CB.CLASS_INFO SCH_CURR_VALUES
, CB.OWNER_REQ_ID SCH_OWNER_REQ_ID
, 1 SCH_EXISTS
, DECODE(CB.OWNER_REQ_ID
, NULL
, 1
, 0) SCH_PERM
FROM FND_APPLICATION AB
, FND_APPLICATION_TL AT
, FND_CONCURRENT_PROGRAMS PB
, FND_CONCURRENT_PROGRAMS_TL PT
, FND_USER U
, FND_USER U2
, FND_PRINTER_STYLES_TL S
, FND_LOOKUP_VALUES L1
, FND_LOOKUP_VALUES L2
, FND_CONCURRENT_REQUESTS R
, FND_CONFLICTS_DOMAIN CD
, FND_LANGUAGES FL
, FND_LANGUAGES_TL FLT
, FND_CONC_RELEASE_CLASSES CB
, FND_CONC_RELEASE_CLASSES_TL CT
, HR_ALL_ORGANIZATION_UNITS_TL H
WHERE PB.APPLICATION_ID(+) = R.PROGRAM_APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID(+) = R.CONCURRENT_PROGRAM_ID
AND PB.APPLICATION_ID = AB.APPLICATION_ID(+)
AND PB.APPLICATION_ID = PT.APPLICATION_ID(+)
AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID(+)
AND PT.LANGUAGE(+) = USERENV('LANG')
AND AB.APPLICATION_ID = AT.APPLICATION_ID(+)
AND AT.LANGUAGE(+) = USERENV('LANG')
AND U.USER_ID(+) = R.REQUESTED_BY
AND U2.USER_ID(+) = R.LAST_UPDATED_BY
AND S.PRINTER_STYLE_NAME(+) = R.PRINT_STYLE
AND S.LANGUAGE(+) = USERENV('LANG')
AND L1.LOOKUP_CODE(+) = R.RESUBMIT_INTERVAL_UNIT_CODE
AND L1.LOOKUP_TYPE(+) = 'CP_RESUBMIT_INTERVAL_UNIT'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 0
AND L1.SECURITY_GROUP_ID(+) = 0
AND L2.LOOKUP_CODE(+) = R.RESUBMIT_INTERVAL_TYPE_CODE
AND L2.LOOKUP_TYPE(+) = 'CP_RESUBMIT_INTERVAL_TYPE'
AND L2.LANGUAGE(+) = USERENV('LANG')
AND L2.VIEW_APPLICATION_ID(+) = 0
AND L2.SECURITY_GROUP_ID(+) = 0
AND CD.CD_ID (+) = R.CD_ID
AND R.RELEASE_CLASS_ID = CB.RELEASE_CLASS_ID(+)
AND R.RELEASE_CLASS_APP_ID = CB.APPLICATION_ID(+)
AND CT.LANGUAGE(+) = USERENV('LANG')
AND R.RELEASE_CLASS_ID = CT.RELEASE_CLASS_ID(+)
AND R.RELEASE_CLASS_APP_ID = CT.APPLICATION_ID(+)
AND FL.NLS_LANGUAGE(+) = R.NLS_LANGUAGE
AND FL.LANGUAGE_CODE = FLT.LANGUAGE_CODE(+)
AND FLT.LANGUAGE(+) = USERENV('LANG')
AND R.ORG_ID = H.ORGANIZATION_ID (+)
AND H.LANGUAGE(+) = USERENV('LANG')

Columns