VIEW: APPLSYS.FND_CONCURRENT_REQUESTS#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_DATE REQUEST_DATE, REQUESTED_BY REQUESTED_BY, PHASE_CODE PHASE_CODE, STATUS_CODE STATUS_CODE, PRIORITY_REQUEST_ID PRIORITY_REQUEST_ID, PRIORITY PRIORITY, REQUESTED_START_DATE REQUESTED_START_DATE, HOLD_FLAG HOLD_FLAG, ENFORCE_SERIALITY_FLAG ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG SINGLE_THREAD_FLAG, HAS_SUB_REQUEST HAS_SUB_REQUEST, IS_SUB_REQUEST IS_SUB_REQUEST, IMPLICIT_CODE IMPLICIT_CODE, UPDATE_PROTECTED UPDATE_PROTECTED, QUEUE_METHOD_CODE QUEUE_METHOD_CODE, ARGUMENT_INPUT_METHOD_CODE ARGUMENT_INPUT_METHOD_CODE, ORACLE_ID ORACLE_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, NUMBER_OF_ARGUMENTS NUMBER_OF_ARGUMENTS, NUMBER_OF_COPIES NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG SAVE_OUTPUT_FLAG, NLS_COMPLIANT NLS_COMPLIANT, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NLS_LANGUAGE NLS_LANGUAGE, NLS_TERRITORY NLS_TERRITORY, PRINTER PRINTER, PRINT_STYLE PRINT_STYLE, PRINT_GROUP PRINT_GROUP, REQUEST_CLASS_APPLICATION_ID REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID CONCURRENT_REQUEST_CLASS_ID, PARENT_REQUEST_ID PARENT_REQUEST_ID, CONC_LOGIN_ID CONC_LOGIN_ID, LANGUAGE_ID LANGUAGE_ID, DESCRIPTION DESCRIPTION, REQ_INFORMATION REQ_INFORMATION, RESUBMIT_INTERVAL RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_TIME RESUBMIT_TIME, RESUBMIT_END_DATE RESUBMIT_END_DATE, RESUBMITTED RESUBMITTED, CONTROLLING_MANAGER CONTROLLING_MANAGER, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE, COMPLETION_TEXT COMPLETION_TEXT, OUTCOME_PRODUCT OUTCOME_PRODUCT, OUTCOME_CODE OUTCOME_CODE, CPU_SECONDS CPU_SECONDS, LOGICAL_IOS LOGICAL_IOS, PHYSICAL_IOS PHYSICAL_IOS, LOGFILE_NAME LOGFILE_NAME, LOGFILE_NODE_NAME LOGFILE_NODE_NAME, OUTFILE_NAME OUTFILE_NAME, OUTFILE_NODE_NAME OUTFILE_NODE_NAME, ARGUMENT_TEXT ARGUMENT_TEXT, ARGUMENT1 ARGUMENT1, ARGUMENT2 ARGUMENT2, ARGUMENT3 ARGUMENT3, ARGUMENT4 ARGUMENT4, ARGUMENT5 ARGUMENT5, ARGUMENT6 ARGUMENT6, ARGUMENT7 ARGUMENT7, ARGUMENT8 ARGUMENT8, ARGUMENT9 ARGUMENT9, ARGUMENT10 ARGUMENT10, ARGUMENT11 ARGUMENT11, ARGUMENT12 ARGUMENT12, ARGUMENT13 ARGUMENT13, ARGUMENT14 ARGUMENT14, ARGUMENT15 ARGUMENT15, ARGUMENT16 ARGUMENT16, ARGUMENT17 ARGUMENT17, ARGUMENT18 ARGUMENT18, ARGUMENT19 ARGUMENT19, ARGUMENT20 ARGUMENT20, ARGUMENT21 ARGUMENT21, ARGUMENT22 ARGUMENT22, ARGUMENT23 ARGUMENT23, ARGUMENT24 ARGUMENT24, ARGUMENT25 ARGUMENT25, CRM_THRSHLD CRM_THRSHLD, CRM_TSTMP CRM_TSTMP, CRITICAL CRITICAL, REQUEST_TYPE REQUEST_TYPE, ORACLE_PROCESS_ID ORACLE_PROCESS_ID, ORACLE_SESSION_ID ORACLE_SESSION_ID, OS_PROCESS_ID OS_PROCESS_ID, PRINT_JOB_ID PRINT_JOB_ID, OUTPUT_FILE_TYPE OUTPUT_FILE_TYPE, RELEASE_CLASS_APP_ID RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID RELEASE_CLASS_ID, STALE_DATE STALE_DATE, CANCEL_OR_HOLD CANCEL_OR_HOLD, NOTIFY_ON_PP_ERROR NOTIFY_ON_PP_ERROR, CD_ID CD_ID, REQUEST_LIMIT REQUEST_LIMIT, CRM_RELEASE_DATE CRM_RELEASE_DATE, POST_REQUEST_STATUS POST_REQUEST_STATUS, COMPLETION_CODE COMPLETION_CODE, INCREMENT_DATES INCREMENT_DATES, RESTART RESTART, ENABLE_TRACE ENABLE_TRACE, RESUB_COUNT RESUB_COUNT, NLS_CODESET NLS_CODESET, OFILE_SIZE OFILE_SIZE, LFILE_SIZE LFILE_SIZE, STALE STALE, SECURITY_GROUP_ID SECURITY_GROUP_ID, RESOURCE_CONSUMER_GROUP RESOURCE_CONSUMER_GROUP, EXP_DATE EXP_DATE, QUEUE_APP_ID QUEUE_APP_ID, QUEUE_ID QUEUE_ID, OPS_INSTANCE OPS_INSTANCE, INTERIM_STATUS_CODE INTERIM_STATUS_CODE, ROOT_REQUEST_ID ROOT_REQUEST_ID, ORIGIN ORIGIN, NLS_NUMERIC_CHARACTERS NLS_NUMERIC_CHARACTERS, PP_START_DATE PP_START_DATE, PP_END_DATE PP_END_DATE, ORG_ID ORG_ID, RUN_NUMBER RUN_NUMBER, NODE_NAME1 NODE_NAME1, NODE_NAME2 NODE_NAME2, CONNSTR1 CONNSTR1, CONNSTR2 CONNSTR2, EDITION_NAME EDITION_NAME from "APPLSYS"."FND_CONCURRENT_REQUESTS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_DATE REQUEST_DATE
, REQUESTED_BY REQUESTED_BY
, PHASE_CODE PHASE_CODE
, STATUS_CODE STATUS_CODE
, PRIORITY_REQUEST_ID PRIORITY_REQUEST_ID
, PRIORITY PRIORITY
, REQUESTED_START_DATE REQUESTED_START_DATE
, HOLD_FLAG HOLD_FLAG
, ENFORCE_SERIALITY_FLAG ENFORCE_SERIALITY_FLAG
, SINGLE_THREAD_FLAG SINGLE_THREAD_FLAG
, HAS_SUB_REQUEST HAS_SUB_REQUEST
, IS_SUB_REQUEST IS_SUB_REQUEST
, IMPLICIT_CODE IMPLICIT_CODE
, UPDATE_PROTECTED UPDATE_PROTECTED
, QUEUE_METHOD_CODE QUEUE_METHOD_CODE
, ARGUMENT_INPUT_METHOD_CODE ARGUMENT_INPUT_METHOD_CODE
, ORACLE_ID ORACLE_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID
, RESPONSIBILITY_APPLICATION_ID RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, NUMBER_OF_ARGUMENTS NUMBER_OF_ARGUMENTS
, NUMBER_OF_COPIES NUMBER_OF_COPIES
, SAVE_OUTPUT_FLAG SAVE_OUTPUT_FLAG
, NLS_COMPLIANT NLS_COMPLIANT
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NLS_LANGUAGE NLS_LANGUAGE
, NLS_TERRITORY NLS_TERRITORY
, PRINTER PRINTER
, PRINT_STYLE PRINT_STYLE
, PRINT_GROUP PRINT_GROUP
, REQUEST_CLASS_APPLICATION_ID REQUEST_CLASS_APPLICATION_ID
, CONCURRENT_REQUEST_CLASS_ID CONCURRENT_REQUEST_CLASS_ID
, PARENT_REQUEST_ID PARENT_REQUEST_ID
, CONC_LOGIN_ID CONC_LOGIN_ID
, LANGUAGE_ID LANGUAGE_ID
, DESCRIPTION DESCRIPTION
, REQ_INFORMATION REQ_INFORMATION
, RESUBMIT_INTERVAL RESUBMIT_INTERVAL
, RESUBMIT_INTERVAL_UNIT_CODE RESUBMIT_INTERVAL_UNIT_CODE
, RESUBMIT_INTERVAL_TYPE_CODE RESUBMIT_INTERVAL_TYPE_CODE
, RESUBMIT_TIME RESUBMIT_TIME
, RESUBMIT_END_DATE RESUBMIT_END_DATE
, RESUBMITTED RESUBMITTED
, CONTROLLING_MANAGER CONTROLLING_MANAGER
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE
, COMPLETION_TEXT COMPLETION_TEXT
, OUTCOME_PRODUCT OUTCOME_PRODUCT
, OUTCOME_CODE OUTCOME_CODE
, CPU_SECONDS CPU_SECONDS
, LOGICAL_IOS LOGICAL_IOS
, PHYSICAL_IOS PHYSICAL_IOS
, LOGFILE_NAME LOGFILE_NAME
, LOGFILE_NODE_NAME LOGFILE_NODE_NAME
, OUTFILE_NAME OUTFILE_NAME
, OUTFILE_NODE_NAME OUTFILE_NODE_NAME
, ARGUMENT_TEXT ARGUMENT_TEXT
, ARGUMENT1 ARGUMENT1
, ARGUMENT2 ARGUMENT2
, ARGUMENT3 ARGUMENT3
, ARGUMENT4 ARGUMENT4
, ARGUMENT5 ARGUMENT5
, ARGUMENT6 ARGUMENT6
, ARGUMENT7 ARGUMENT7
, ARGUMENT8 ARGUMENT8
, ARGUMENT9 ARGUMENT9
, ARGUMENT10 ARGUMENT10
, ARGUMENT11 ARGUMENT11
, ARGUMENT12 ARGUMENT12
, ARGUMENT13 ARGUMENT13
, ARGUMENT14 ARGUMENT14
, ARGUMENT15 ARGUMENT15
, ARGUMENT16 ARGUMENT16
, ARGUMENT17 ARGUMENT17
, ARGUMENT18 ARGUMENT18
, ARGUMENT19 ARGUMENT19
, ARGUMENT20 ARGUMENT20
, ARGUMENT21 ARGUMENT21
, ARGUMENT22 ARGUMENT22
, ARGUMENT23 ARGUMENT23
, ARGUMENT24 ARGUMENT24
, ARGUMENT25 ARGUMENT25
, CRM_THRSHLD CRM_THRSHLD
, CRM_TSTMP CRM_TSTMP
, CRITICAL CRITICAL
, REQUEST_TYPE REQUEST_TYPE
, ORACLE_PROCESS_ID ORACLE_PROCESS_ID
, ORACLE_SESSION_ID ORACLE_SESSION_ID
, OS_PROCESS_ID OS_PROCESS_ID
, PRINT_JOB_ID PRINT_JOB_ID
, OUTPUT_FILE_TYPE OUTPUT_FILE_TYPE
, RELEASE_CLASS_APP_ID RELEASE_CLASS_APP_ID
, RELEASE_CLASS_ID RELEASE_CLASS_ID
, STALE_DATE STALE_DATE
, CANCEL_OR_HOLD CANCEL_OR_HOLD
, NOTIFY_ON_PP_ERROR NOTIFY_ON_PP_ERROR
, CD_ID CD_ID
, REQUEST_LIMIT REQUEST_LIMIT
, CRM_RELEASE_DATE CRM_RELEASE_DATE
, POST_REQUEST_STATUS POST_REQUEST_STATUS
, COMPLETION_CODE COMPLETION_CODE
, INCREMENT_DATES INCREMENT_DATES
, RESTART RESTART
, ENABLE_TRACE ENABLE_TRACE
, RESUB_COUNT RESUB_COUNT
, NLS_CODESET NLS_CODESET
, OFILE_SIZE OFILE_SIZE
, LFILE_SIZE LFILE_SIZE
, STALE STALE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, RESOURCE_CONSUMER_GROUP RESOURCE_CONSUMER_GROUP
, EXP_DATE EXP_DATE
, QUEUE_APP_ID QUEUE_APP_ID
, QUEUE_ID QUEUE_ID
, OPS_INSTANCE OPS_INSTANCE
, INTERIM_STATUS_CODE INTERIM_STATUS_CODE
, ROOT_REQUEST_ID ROOT_REQUEST_ID
, ORIGIN ORIGIN
, NLS_NUMERIC_CHARACTERS NLS_NUMERIC_CHARACTERS
, PP_START_DATE PP_START_DATE
, PP_END_DATE PP_END_DATE
, ORG_ID ORG_ID
, RUN_NUMBER RUN_NUMBER
, NODE_NAME1 NODE_NAME1
, NODE_NAME2 NODE_NAME2
, CONNSTR1 CONNSTR1
, CONNSTR2 CONNSTR2
, EDITION_NAME EDITION_NAME
FROM "APPLSYS"."FND_CONCURRENT_REQUESTS"