[Home] [Help] [Dependency Information]
Object Name: | CSF_R_REQUEST_TASKS |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_R_REQUEST_TASKS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSF_R_REQUEST_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_TASK_ID |
CSF_R_REQUEST_TASKS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCHED_REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_TASK_ID | NUMBER | Yes | Primary key for table CSF_R_REQUEST_TASKS. | |
SCHED_REQUEST_ID | NUMBER | Yes | Foreign key to table CSF_R_SCHED_REQUESTS. | |
TASK_ID | NUMBER | Yes | The ID of the task to be processed. In a case a trip will be processed this column stores the ID of the first task in the trip. | |
RESULT_FLAG | VARCHAR2 | (1) | tores the result of the execution of the request. | |
SECURITY_GROUP_ID | NUMBER | Security group identifier. | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | The object version number is incremented by one at every update. The object version number is read when the row is read. When the record is updated a check is made that the update version number in the database has the same value as when the row was read. If the number was changed, some other process has updated the record and the row changes should be abandoned. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_TASK_ID
, SCHED_REQUEST_ID
, TASK_ID
, RESULT_FLAG
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM CSF.CSF_R_REQUEST_TASKS;
CSF.CSF_R_REQUEST_TASKS does not reference any database object
CSF.CSF_R_REQUEST_TASKS is referenced by following:
|
|
|