[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 |