[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_CONCURRENT_WORKER_REQUESTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.FND_CONCURRENT_WORKER_REQUESTS
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| REQUEST_DATE | DATE | Yes | ||
| REQUESTED_BY | NUMBER | (15) | Yes | |
| PHASE_CODE | VARCHAR2 | (1) | Yes | |
| STATUS_CODE | VARCHAR2 | (1) | Yes | |
| PRIORITY_REQUEST_ID | NUMBER | (15) | Yes | |
| PRIORITY | NUMBER | (15) | Yes | |
| REQUESTED_START_DATE | DATE | Yes | ||
| HOLD_FLAG | VARCHAR2 | (1) | Yes | |
| ENFORCE_SERIALITY_FLAG | VARCHAR2 | (1) | Yes | |
| SINGLE_THREAD_FLAG | VARCHAR2 | (1) | Yes | |
| HAS_SUB_REQUEST | VARCHAR2 | (1) | Yes | |
| IS_SUB_REQUEST | VARCHAR2 | (1) | Yes | |
| IMPLICIT_CODE | VARCHAR2 | (1) | Yes | |
| UPDATE_PROTECTED | VARCHAR2 | (1) | Yes | |
| QUEUE_METHOD_CODE | VARCHAR2 | (1) | Yes | |
| ARGUMENT_INPUT_METHOD_CODE | VARCHAR2 | (1) | Yes | |
| ORACLE_ID | NUMBER | (15) | Yes | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Yes | |
| CONCURRENT_PROGRAM_ID | NUMBER | (15) | Yes | |
| RESPONSIBILITY_APPLICATION_ID | NUMBER | (15) | Yes | |
| RESPONSIBILITY_ID | NUMBER | (15) | Yes | |
| NUMBER_OF_ARGUMENTS | NUMBER | (3) | Yes | |
| NUMBER_OF_COPIES | NUMBER | (15) | Yes | |
| SAVE_OUTPUT_FLAG | VARCHAR2 | (1) | Yes | |
| NLS_COMPLIANT | VARCHAR2 | (1) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| NLS_LANGUAGE | VARCHAR2 | (30) | ||
| NLS_TERRITORY | VARCHAR2 | (30) | ||
| PRINTER | VARCHAR2 | (30) | ||
| PRINT_STYLE | VARCHAR2 | (30) | ||
| PRINT_GROUP | VARCHAR2 | (1) | ||
| REQUEST_CLASS_APPLICATION_ID | NUMBER | (15) | ||
| CONCURRENT_REQUEST_CLASS_ID | NUMBER | (15) | ||
| PARENT_REQUEST_ID | NUMBER | (15) | ||
| CONC_LOGIN_ID | NUMBER | (15) | ||
| LANGUAGE_ID | NUMBER | (15) | ||
| DESCRIPTION | VARCHAR2 | (240) | ||
| REQ_INFORMATION | VARCHAR2 | (240) | ||
| RESUBMIT_INTERVAL | NUMBER | (15) | ||
| RESUBMIT_INTERVAL_UNIT_CODE | VARCHAR2 | (30) | ||
| RESUBMIT_INTERVAL_TYPE_CODE | VARCHAR2 | (30) | ||
| RESUBMIT_TIME | VARCHAR2 | (8) | ||
| RESUBMIT_END_DATE | DATE | |||
| RESUBMITTED | VARCHAR2 | (1) | ||
| CONTROLLING_MANAGER | NUMBER | (15) | ||
| ACTUAL_START_DATE | DATE | |||
| ACTUAL_COMPLETION_DATE | DATE | |||
| COMPLETION_TEXT | VARCHAR2 | (240) | ||
| OUTCOME_PRODUCT | VARCHAR2 | (20) | ||
| OUTCOME_CODE | NUMBER | (15) | ||
| CPU_SECONDS | NUMBER | (15) | ||
| LOGICAL_IOS | NUMBER | (15) | ||
| PHYSICAL_IOS | NUMBER | (15) | ||
| LOGFILE_NAME | VARCHAR2 | (255) | ||
| LOGFILE_NODE_NAME | VARCHAR2 | (30) | ||
| OUTFILE_NAME | VARCHAR2 | (255) | ||
| OUTFILE_NODE_NAME | VARCHAR2 | (30) | ||
| ARGUMENT_TEXT | VARCHAR2 | (240) | ||
| ARGUMENT1 | VARCHAR2 | (240) | ||
| ARGUMENT2 | VARCHAR2 | (240) | ||
| ARGUMENT3 | VARCHAR2 | (240) | ||
| ARGUMENT4 | VARCHAR2 | (240) | ||
| ARGUMENT5 | VARCHAR2 | (240) | ||
| ARGUMENT6 | VARCHAR2 | (240) | ||
| ARGUMENT7 | VARCHAR2 | (240) | ||
| ARGUMENT8 | VARCHAR2 | (240) | ||
| ARGUMENT9 | VARCHAR2 | (240) | ||
| ARGUMENT10 | VARCHAR2 | (240) | ||
| ARGUMENT11 | VARCHAR2 | (240) | ||
| ARGUMENT12 | VARCHAR2 | (240) | ||
| ARGUMENT13 | VARCHAR2 | (240) | ||
| ARGUMENT14 | VARCHAR2 | (240) | ||
| ARGUMENT15 | VARCHAR2 | (240) | ||
| ARGUMENT16 | VARCHAR2 | (240) | ||
| ARGUMENT17 | VARCHAR2 | (240) | ||
| ARGUMENT18 | VARCHAR2 | (240) | ||
| ARGUMENT19 | VARCHAR2 | (240) | ||
| ARGUMENT20 | VARCHAR2 | (240) | ||
| ARGUMENT21 | VARCHAR2 | (240) | ||
| ARGUMENT22 | VARCHAR2 | (240) | ||
| ARGUMENT23 | VARCHAR2 | (240) | ||
| ARGUMENT24 | VARCHAR2 | (240) | ||
| ARGUMENT25 | VARCHAR2 | (240) | ||
| CRM_THRSHLD | NUMBER | (15) | ||
| CRM_TSTMP | DATE | |||
| CRITICAL | VARCHAR2 | (1) | ||
| REQUEST_TYPE | VARCHAR2 | (1) | ||
| ORACLE_PROCESS_ID | VARCHAR2 | (30) | ||
| ORACLE_SESSION_ID | NUMBER | (15) | ||
| OS_PROCESS_ID | VARCHAR2 | (240) | ||
| PRINT_JOB_ID | VARCHAR2 | (240) | ||
| OUTPUT_FILE_TYPE | VARCHAR2 | (4) | ||
| RELEASE_CLASS_APP_ID | NUMBER | |||
| RELEASE_CLASS_ID | NUMBER | |||
| STALE_DATE | DATE | |||
| CANCEL_OR_HOLD | VARCHAR2 | (1) | ||
| NOTIFY_ON_PP_ERROR | VARCHAR2 | (255) | ||
| CD_ID | NUMBER | |||
| REQUEST_LIMIT | VARCHAR2 | (1) | ||
| CRM_RELEASE_DATE | DATE | |||
| POST_REQUEST_STATUS | VARCHAR2 | (1) | ||
| COMPLETION_CODE | VARCHAR2 | (30) | ||
| INCREMENT_DATES | VARCHAR2 | (1) | ||
| RESTART | VARCHAR2 | (1) | ||
| ENABLE_TRACE | VARCHAR2 | (1) | ||
| RESUB_COUNT | NUMBER | |||
| NLS_CODESET | VARCHAR2 | (30) | ||
| OFILE_SIZE | NUMBER | (15) | ||
| LFILE_SIZE | NUMBER | (15) | ||
| STALE | VARCHAR2 | (1) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| RESOURCE_CONSUMER_GROUP | VARCHAR2 | (30) | ||
| EXP_DATE | DATE | |||
| QUEUE_APP_ID | NUMBER | (15) | ||
| QUEUE_ID | NUMBER | (15) | ||
| OPS_INSTANCE | NUMBER | (15) | Yes | |
| INTERIM_STATUS_CODE | VARCHAR2 | (1) | ||
| ROOT_REQUEST_ID | NUMBER | (15) | ||
| ORIGIN | VARCHAR2 | (1) | ||
| NLS_NUMERIC_CHARACTERS | VARCHAR2 | (2) | ||
| PP_START_DATE | DATE | |||
| PP_END_DATE | DATE | |||
| ORG_ID | NUMBER | (15) | ||
| RUN_NUMBER | NUMBER | (5) | ||
| NODE_NAME1 | VARCHAR2 | (30) | ||
| NODE_NAME2 | VARCHAR2 | (30) | ||
| CONNSTR1 | VARCHAR2 | (255) | ||
| CONNSTR2 | VARCHAR2 | (255) | ||
| EDITION_NAME | VARCHAR2 | (30) | ||
| QUEUE_APPLICATION_ID | NUMBER | (15) | Yes | |
| CONCURRENT_QUEUE_ID | NUMBER | (15) | Yes | |
| CONCURRENT_QUEUE_NAME | VARCHAR2 | (30) | Yes | |
| CONTROL_CODE | VARCHAR2 | (1) | ||
| PROCESSOR_APPLICATION_ID | NUMBER | (15) | Yes | |
| CONCURRENT_PROCESSOR_ID | NUMBER | (15) | Yes | |
| RUNNING_PROCESSES | NUMBER | (4) | Yes | |
| MAX_PROCESSES | NUMBER | (4) | Yes | |
| CACHE_SIZE | NUMBER | (3) | ||
| TARGET_NODE | VARCHAR2 | (30) | ||
| QUEUE_DESCRIPTION | VARCHAR2 | (240) | ||
| CONCURRENT_PROGRAM_NAME | VARCHAR2 | (30) | Yes | |
| EXECUTION_METHOD_CODE | VARCHAR2 | (1) | Yes | |
| ARGUMENT_METHOD_CODE | VARCHAR2 | (1) | Yes | |
| QUEUE_CONTROL_FLAG | VARCHAR2 | (1) | Yes | |
| RUN_ALONE_FLAG | VARCHAR2 | (1) | Yes | |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
| PROGRAM_DESCRIPTION | VARCHAR2 | (240) | ||
| USER_CONCURRENT_PROGRAM_NAME | VARCHAR2 | (240) | Yes | |
| REQUEST_DESCRIPTION | VARCHAR2 | (483) |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_DATE
, REQUESTED_BY
, PHASE_CODE
, STATUS_CODE
, PRIORITY_REQUEST_ID
, PRIORITY
, REQUESTED_START_DATE
, HOLD_FLAG
, ENFORCE_SERIALITY_FLAG
, SINGLE_THREAD_FLAG
, HAS_SUB_REQUEST
, IS_SUB_REQUEST
, IMPLICIT_CODE
, UPDATE_PROTECTED
, QUEUE_METHOD_CODE
, ARGUMENT_INPUT_METHOD_CODE
, ORACLE_ID
, PROGRAM_APPLICATION_ID
, CONCURRENT_PROGRAM_ID
, RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID
, NUMBER_OF_ARGUMENTS
, NUMBER_OF_COPIES
, SAVE_OUTPUT_FLAG
, NLS_COMPLIANT
, LAST_UPDATE_LOGIN
, NLS_LANGUAGE
, NLS_TERRITORY
, PRINTER
, PRINT_STYLE
, PRINT_GROUP
, REQUEST_CLASS_APPLICATION_ID
, CONCURRENT_REQUEST_CLASS_ID
, PARENT_REQUEST_ID
, CONC_LOGIN_ID
, LANGUAGE_ID
, DESCRIPTION
, REQ_INFORMATION
, RESUBMIT_INTERVAL
, RESUBMIT_INTERVAL_UNIT_CODE
, RESUBMIT_INTERVAL_TYPE_CODE
, RESUBMIT_TIME
, RESUBMIT_END_DATE
, RESUBMITTED
, CONTROLLING_MANAGER
, ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE
, COMPLETION_TEXT
, OUTCOME_PRODUCT
, OUTCOME_CODE
, CPU_SECONDS
, LOGICAL_IOS
, PHYSICAL_IOS
, LOGFILE_NAME
, LOGFILE_NODE_NAME
, OUTFILE_NAME
, OUTFILE_NODE_NAME
, ARGUMENT_TEXT
, ARGUMENT1
, ARGUMENT2
, ARGUMENT3
, ARGUMENT4
, ARGUMENT5
, ARGUMENT6
, ARGUMENT7
, ARGUMENT8
, ARGUMENT9
, ARGUMENT10
, ARGUMENT11
, ARGUMENT12
, ARGUMENT13
, ARGUMENT14
, ARGUMENT15
, ARGUMENT16
, ARGUMENT17
, ARGUMENT18
, ARGUMENT19
, ARGUMENT20
, ARGUMENT21
, ARGUMENT22
, ARGUMENT23
, ARGUMENT24
, ARGUMENT25
, CRM_THRSHLD
, CRM_TSTMP
, CRITICAL
, REQUEST_TYPE
, ORACLE_PROCESS_ID
, ORACLE_SESSION_ID
, OS_PROCESS_ID
, PRINT_JOB_ID
, OUTPUT_FILE_TYPE
, RELEASE_CLASS_APP_ID
, RELEASE_CLASS_ID
, STALE_DATE
, CANCEL_OR_HOLD
, NOTIFY_ON_PP_ERROR
, CD_ID
, REQUEST_LIMIT
, CRM_RELEASE_DATE
, POST_REQUEST_STATUS
, COMPLETION_CODE
, INCREMENT_DATES
, RESTART
, ENABLE_TRACE
, RESUB_COUNT
, NLS_CODESET
, OFILE_SIZE
, LFILE_SIZE
, STALE
, SECURITY_GROUP_ID
, RESOURCE_CONSUMER_GROUP
, EXP_DATE
, QUEUE_APP_ID
, QUEUE_ID
, OPS_INSTANCE
, INTERIM_STATUS_CODE
, ROOT_REQUEST_ID
, ORIGIN
, NLS_NUMERIC_CHARACTERS
, PP_START_DATE
, PP_END_DATE
, ORG_ID
, RUN_NUMBER
, NODE_NAME1
, NODE_NAME2
, CONNSTR1
, CONNSTR2
, EDITION_NAME
, QUEUE_APPLICATION_ID
, CONCURRENT_QUEUE_ID
, CONCURRENT_QUEUE_NAME
, CONTROL_CODE
, PROCESSOR_APPLICATION_ID
, CONCURRENT_PROCESSOR_ID
, RUNNING_PROCESSES
, MAX_PROCESSES
, CACHE_SIZE
, TARGET_NODE
, QUEUE_DESCRIPTION
, CONCURRENT_PROGRAM_NAME
, EXECUTION_METHOD_CODE
, ARGUMENT_METHOD_CODE
, QUEUE_CONTROL_FLAG
, RUN_ALONE_FLAG
, ENABLED_FLAG
, PROGRAM_DESCRIPTION
, USER_CONCURRENT_PROGRAM_NAME
, REQUEST_DESCRIPTION
FROM APPS.FND_CONCURRENT_WORKER_REQUESTS;
APPS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_PROGRAMS_TL
FND_CONCURRENT_QUEUES
FND_CONCURRENT_QUEUES_TL
FND_CONCURRENT_REQUESTS
FND_CONFLICTS_DOMAIN
FND_ORACLE_USERID
APPS
FND_CONC
- show dependent code
FND_CONC_REQUEST_PKG
- show dependent code
FND_CONC_WAITING_REQUESTS
FND_CONC_WEB_UTIL
- show dependent code
FND_DCP
- show dependent code
FND_DIAG_REQUEST_ANALYZER
- show dependent code
FND_OAM_CPCHARTS_COL
- show dependent code
|
|
|
|