[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_CONC_REQUESTS_FORM_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.FND_CONC_REQUESTS_FORM_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| REQUEST_ID | NUMBER | (15) | Yes | |
| PHASE_CODE | VARCHAR2 | (1) | Yes | |
| STATUS_CODE | VARCHAR2 | (1) | Yes | |
| PRIORITY_REQUEST_ID | NUMBER | (15) | Yes | |
| PRIORITY | NUMBER | (15) | Yes | |
| REQUEST_DATE | DATE | Yes | ||
| REQUESTED_BY | 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 | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| 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) | ||
| NLS_LANGUAGE | VARCHAR2 | (30) | ||
| NLS_TERRITORY | VARCHAR2 | (30) | ||
| 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) | ||
| NLS_COMPLIANT | VARCHAR2 | (1) | Yes | |
| 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 | |||
| USER_CD_NAME | VARCHAR2 | (240) | ||
| PROGRAM_SHORT_NAME | VARCHAR2 | (30) | ||
| EXECUTION_METHOD_CODE | VARCHAR2 | (1) | ||
| FCP_QUEUE_METHOD_CODE | VARCHAR2 | (1) | ||
| QUEUE_CONTROL_FLAG | VARCHAR2 | (1) | ||
| RUN_ALONE | VARCHAR2 | (1) | ||
| ENABLED | VARCHAR2 | (1) | ||
| SRS_FLAG | VARCHAR2 | (1) | ||
| PROGRAM | VARCHAR2 | (483) | ||
| USER_CONCURRENT_PROGRAM_NAME | VARCHAR2 | (240) | ||
| FCP_PRINTER | VARCHAR2 | (30) | ||
| FCP_PRINT_STYLE | VARCHAR2 | (30) | ||
| FCP_REQUIRED_STYLE | VARCHAR2 | (1) | ||
| APPLICATION_SHORT_NAME | VARCHAR2 | (50) | ||
| APPLICATION_NAME | VARCHAR2 | (240) | ||
| REQUESTOR | VARCHAR2 | (100) | ||
| USER_PRINT_STYLE | VARCHAR2 | (80) | ||
| PARENT | VARCHAR2 | (40) | ||
| RESUBMIT_INTERVAL_UNIT | VARCHAR2 | (80) | ||
| RESUBMIT_INTERVAL_TYPE | VARCHAR2 | (80) | ||
| UPDATED_BY_NAME | VARCHAR2 | (100) | ||
| ATTRIBUTE_ORDER | VARCHAR2 | (4000) | ||
| LANGUAGE | VARCHAR2 | (255) | ||
| ORG_ID | NUMBER | (15) | ||
| OPERATING_UNIT | VARCHAR2 | (240) | ||
| SCH_APP_ID | NUMBER | |||
| SCH_ID | NUMBER | |||
| SCH_NAME | VARCHAR2 | (20) | ||
| SCH_DESCRIPTION | VARCHAR2 | (80) | ||
| SCH_DATE1 | DATE | |||
| SCH_DATE2 | DATE | |||
| SCH_TYPE | VARCHAR2 | (1) | ||
| SCH_CURR_VALUES | VARCHAR2 | (64) | ||
| SCH_OWNER_REQ_ID | NUMBER | |||
| SCH_EXISTS | NUMBER | |||
| SCH_PERM | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REQUEST_ID
, PHASE_CODE
, STATUS_CODE
, PRIORITY_REQUEST_ID
, PRIORITY
, REQUEST_DATE
, REQUESTED_BY
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, 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
, NLS_LANGUAGE
, NLS_TERRITORY
, 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
, NLS_COMPLIANT
, 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
, USER_CD_NAME
, PROGRAM_SHORT_NAME
, EXECUTION_METHOD_CODE
, FCP_QUEUE_METHOD_CODE
, QUEUE_CONTROL_FLAG
, RUN_ALONE
, ENABLED
, SRS_FLAG
, PROGRAM
, USER_CONCURRENT_PROGRAM_NAME
, FCP_PRINTER
, FCP_PRINT_STYLE
, FCP_REQUIRED_STYLE
, APPLICATION_SHORT_NAME
, APPLICATION_NAME
, REQUESTOR
, USER_PRINT_STYLE
, PARENT
, RESUBMIT_INTERVAL_UNIT
, RESUBMIT_INTERVAL_TYPE
, UPDATED_BY_NAME
, ATTRIBUTE_ORDER
, LANGUAGE
, ORG_ID
, OPERATING_UNIT
, SCH_APP_ID
, SCH_ID
, SCH_NAME
, SCH_DESCRIPTION
, SCH_DATE1
, SCH_DATE2
, SCH_TYPE
, SCH_CURR_VALUES
, SCH_OWNER_REQ_ID
, SCH_EXISTS
, SCH_PERM
FROM APPS.FND_CONC_REQUESTS_FORM_V;
APPS
FND_APPLICATION
FND_APPLICATION_TL
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_PROGRAMS_TL
FND_CONCURRENT_REQUESTS
FND_CONC_RELEASE_CLASSES
FND_CONC_RELEASE_CLASSES_TL
FND_CONC_REQUEST_PKG
- show dependent code
FND_CONFLICTS_DOMAIN
FND_LANGUAGES
FND_LANGUAGES_TL
FND_LOOKUP_VALUES
FND_PRINTER_STYLES_TL
FND_USER
HR_ALL_ORGANIZATION_UNITS_TL
APPS
FND_CONC_SSWA
- show dependent code
|
|
|
|