View: CSF_SELECTED_RESOURCES_V

Product:	CSF - Field Service
Description:	This view holds the UI selected resources
Implementation/DBA Data:	APPS.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