[Home] [Help] [Dependency Information]
Object Name: | CSF_R_RESOURCE_RESULTS |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_R_RESOURCE_RESULTS |
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_RESOURCE_RESULTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESOURCE_RESULT_ID |
CSF_R_RESOURCE_RESULTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUEST_TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_RESULT_ID | NUMBER | Yes | Primary key of table CSF_R_RESOURCE_RESULTS. | |
REQUEST_TASK_ID | NUMBER | Yes | Foreign key to table CSF_R_REQUEST_TASKS. | |
RESOURCE_ID | NUMBER | The ID of the resource eligable for scheduling. | ||
RESOURCE_TYPE | VARCHAR2 | (30) | The resource type of the resource eligable for scheduling. | |
GROUPING_ORDER | NUMBER | Grouping order | ||
GROUPING_OPERATION | VARCHAR2 | (30) | Grouping operation | |
DISTANCE | NUMBER | Distance | ||
ENABLED_FLAG | VARCHAR2 | (1) | Enabled flag | |
PREFERRED_RESOURCES_FLAG | VARCHAR2 | (1) | Is the resource preferred | |
TERRITORY_FLAG | VARCHAR2 | (1) | Territory flag | |
GEOGRAPHY_FLAG | VARCHAR2 | (1) | Geography flag | |
SKILL_FLAG | VARCHAR2 | (1) | Skill flag | |
SPARE_FLAG | VARCHAR2 | (1) | Spare flag | |
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. | |
TERRITORY_RANK | NUMBER | The rank of the territory to which the resource is related. | ||
TERRITORY_ID | NUMBER | The territory ID to which the resource is related. | ||
PLANWIN_START | DATE | The start of the individual plan window. This window deviates from the task when the resource's skill is not available throughout the whole task plan window. | ||
PLANWIN_END | DATE | The end of the individual plan window. This window deviates from the task when the resource's skill is not available throughout the whole task plan window. |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_RESULT_ID
, REQUEST_TASK_ID
, RESOURCE_ID
, RESOURCE_TYPE
, GROUPING_ORDER
, GROUPING_OPERATION
, DISTANCE
, ENABLED_FLAG
, PREFERRED_RESOURCES_FLAG
, TERRITORY_FLAG
, GEOGRAPHY_FLAG
, SKILL_FLAG
, SPARE_FLAG
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, TERRITORY_RANK
, TERRITORY_ID
, PLANWIN_START
, PLANWIN_END
FROM CSF.CSF_R_RESOURCE_RESULTS;
CSF.CSF_R_RESOURCE_RESULTS does not reference any database object
CSF.CSF_R_RESOURCE_RESULTS is referenced by following:
|
|
|