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: CSR_RESOURCES_V

Product:	CSR - Scheduler
Description:	View of resources used by Oracle Resources
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RES.RESOURCE_ID
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_EMPLOYEE'
, 'PARTNER'
, 'RS_PARTNER'
, 'SUPPLIER_CONTACT'
, 'RS_SUPPLIER'
, 'PARTY'
, 'RS_PARTY'
, 'OTHER'
, 'RS_OTHER')
, RES.TIME_ZONE
, CSR_SCHEDULER_PVT.GET_LOCUS_SEGMENTID (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_SIDE (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_SPOT (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.LOCATION_FINDER_USED (LOC.GEOMETRY)
, LOC.LOCATION_ID
, CSR_SCHEDULER_PVT.GET_LOCUS_LAT (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_LON (LOC.GEOMETRY)
FROM JTF_RS_RESOURCE_EXTNS RES
, HZ_PARTY_SITES SIT
, HZ_LOCATIONS LOC
WHERE RES.ADDRESS_ID = SIT.PARTY_SITE_ID
AND SIT.LOCATION_ID = LOC.LOCATION_ID

Columns

Name
RESOURCE_ID
RESOURCE_TYPE
TIME_ZONE
LOCUS_SEGMENTID
LOCUS_SIDE
LOCUS_SPOT
LOCATION_FINDER_USED
LOCATION_ID
LOCUS_LAT
LOCUS_LON