[Home] [Help] [Dependency Information]
Object Name: | CSF_R_RESOURCE_RESULTS# |
---|---|
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_RESULT_ID | NUMBER | Yes | ||
REQUEST_TASK_ID | NUMBER | Yes | ||
RESOURCE_ID | NUMBER | |||
RESOURCE_TYPE | VARCHAR2 | (30) | ||
GROUPING_ORDER | NUMBER | |||
GROUPING_OPERATION | VARCHAR2 | (30) | ||
DISTANCE | NUMBER | |||
ENABLED_FLAG | VARCHAR2 | (1) | ||
PREFERRED_RESOURCES_FLAG | VARCHAR2 | (1) | ||
TERRITORY_FLAG | VARCHAR2 | (1) | ||
GEOGRAPHY_FLAG | VARCHAR2 | (1) | ||
SKILL_FLAG | VARCHAR2 | (1) | ||
SPARE_FLAG | VARCHAR2 | (1) | ||
SECURITY_GROUP_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
TERRITORY_RANK | NUMBER | |||
TERRITORY_ID | NUMBER | |||
PLANWIN_START | DATE | |||
PLANWIN_END | DATE | |||
SKILL_LEVEL | NUMBER | |||
RESOURCE_SOURCE | VARCHAR2 | (30) |
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
, SKILL_LEVEL
, RESOURCE_SOURCE
FROM CSF.CSF_R_RESOURCE_RESULTS#;
|
|
|