[Home] [Help]
View: CSR_WIN_PROMISES_V
Product: | CSR - Scheduler |
Description: | View on window to promises used by Oracle Scheduler for time zone conversion |
Implementation/DBA Data: |
APPS.CSR_WIN_PROMISES_V
|
View Text
SELECT ZON.TIMEZONE_ID
, WPR.START_TIME
, WPR.END_TIME
, CSR_SCHEDULER_PVT.CONVERT_TIMEZONE (WPR.START_TIME
, ZON.TIMEZONE_ID)
, CSR_SCHEDULER_PVT.CONVERT_TIMEZONE (WPR.END_TIME
, ZON.TIMEZONE_ID)
, WPR.WIN_PROMIS_ID
FROM CSR_WIN_PROMIS_ALL_B WPR
, HZ_TIMEZONES ZON
Columns
Name |
TIMEZONE_ID |
START_TIME |
END_TIME |
START_TIME_SERVER |
END_TIME_SERVER |
WIN_PROMIS_ID |