[Home] [Help]
View: CSF_SELECTED_RESOURCES_V
View Text
SELECT DISTINCT TR.RESOURCE_TYPE
, TR.RESOURCE_ID
, CSF_UTIL_PVT.GET_OBJECT_NAME(TR.RESOURCE_TYPE
, TR.RESOURCE_ID) RESOURCE_NAME
FROM JTF_TERR_ALL TA
, JTF_TERR_RSC_ALL TR
WHERE CSF_UTIL_PVT.IS_TERR_SELECTED(TA.TERR_ID) <> 0
AND TA.TERR_ID = TR.TERR_ID
Columns
Name |
RESOURCE_TYPE |
RESOURCE_ID |
RESOURCE_NAME |