eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CSF.CSF_R_RESOURCE_RESULTS#

Source

View Text - Preformatted


select RESOURCE_RESULT_ID RESOURCE_RESULT_ID, REQUEST_TASK_ID REQUEST_TASK_ID, RESOURCE_ID RESOURCE_ID, RESOURCE_TYPE RESOURCE_TYPE, GROUPING_ORDER GROUPING_ORDER, GROUPING_OPERATION GROUPING_OPERATION, DISTANCE DISTANCE, ENABLED_FLAG ENABLED_FLAG, PREFERRED_RESOURCES_FLAG PREFERRED_RESOURCES_FLAG, TERRITORY_FLAG TERRITORY_FLAG, GEOGRAPHY_FLAG GEOGRAPHY_FLAG, SKILL_FLAG SKILL_FLAG, SPARE_FLAG SPARE_FLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TERRITORY_RANK TERRITORY_RANK, TERRITORY_ID TERRITORY_ID, PLANWIN_START PLANWIN_START, PLANWIN_END PLANWIN_END, SKILL_LEVEL SKILL_LEVEL, RESOURCE_SOURCE RESOURCE_SOURCE from "CSF"."CSF_R_RESOURCE_RESULTS"

View Text - HTML Formatted

SELECT RESOURCE_RESULT_ID RESOURCE_RESULT_ID
, REQUEST_TASK_ID REQUEST_TASK_ID
, RESOURCE_ID RESOURCE_ID
, RESOURCE_TYPE RESOURCE_TYPE
, GROUPING_ORDER GROUPING_ORDER
, GROUPING_OPERATION GROUPING_OPERATION
, DISTANCE DISTANCE
, ENABLED_FLAG ENABLED_FLAG
, PREFERRED_RESOURCES_FLAG PREFERRED_RESOURCES_FLAG
, TERRITORY_FLAG TERRITORY_FLAG
, GEOGRAPHY_FLAG GEOGRAPHY_FLAG
, SKILL_FLAG SKILL_FLAG
, SPARE_FLAG SPARE_FLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TERRITORY_RANK TERRITORY_RANK
, TERRITORY_ID TERRITORY_ID
, PLANWIN_START PLANWIN_START
, PLANWIN_END PLANWIN_END
, SKILL_LEVEL SKILL_LEVEL
, RESOURCE_SOURCE RESOURCE_SOURCE
FROM "CSF"."CSF_R_RESOURCE_RESULTS"