[Home] [Help]
[Dependency Information]
VIEW: APPS.FND_TIMEZONES_VL
Object Details
Object Name: | FND_TIMEZONES_VL |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.FND_TIMEZONES_VL
|
---|
Subobject Name: | |
Status: | VALID |
View Type
MultiLingual view (a language resolved view of the data.)
FND_TIMEZONES_VL
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
TIMEZONE_CODE |
VARCHAR2 |
(50) |
Yes |
the unique identifier of a timezone |
NAME |
VARCHAR2 |
(80) |
Yes |
Name of the timezone in the language specified |
ENABLED_FLAG |
VARCHAR2 |
(1) |
Yes |
Indicates whether the zone is currently enabled for use |
GMT_OFFSET |
NUMBER |
|
Yes |
The offset from gmt of this timezone under standard time |
DAYLIGHT_SAVINGS_FLAG |
VARCHAR2 |
(1) |
Yes |
Indicates whether this zone adjusts for daylight savings |
ACTIVE_TIMEZONE_CODE |
VARCHAR2 |
(50) |
|
Indicates which timezone is currently active with the same conversion rules |
UPGRADE_TZ_ID |
NUMBER |
|
|
Used for upgrade purposes from foreign key to hz_timezones |
CREATION_DATE |
DATE |
|
Yes |
CREATION_DATE |
CREATED_BY |
NUMBER |
|
Yes |
CREATED_BY |
LAST_UPDATE_DATE |
DATE |
|
Yes |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
NUMBER |
|
|
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
NUMBER |
|
|
LAST_UPDATE_LOGIN |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT TIMEZONE_CODE
, NAME
, ENABLED_FLAG
, GMT_OFFSET
, DAYLIGHT_SAVINGS_FLAG
, ACTIVE_TIMEZONE_CODE
, UPGRADE_TZ_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.FND_TIMEZONES_VL;
Dependencies
[top of page]
APPS.FND_TIMEZONES_VL references the following:
-
APPS
-
FND_TIMEZONES_B
-
FND_TIMEZONES_TL
APPS.FND_TIMEZONES_VL is referenced by following:
-
APPS
-
AHL_PRD_PRINT_PVT
- show dependent code
-
AMS_UTILITY_PVT
- show dependent code
-
AST_CONTACT_POINTS_V
-
CAC_VIEW_ACC_DAILY_VIEW_PVT
- show dependent code
-
CSC_CC_CONTACT_POINTS_V
-
CSF_GANTT_DATA_PKG
- show dependent code
-
CSF_TASK_ADDRESS_PVT
- show dependent code
-
CSZ_SERVICEREQUEST_UTIL_PVT
- show dependent code
-
CS_TZ_GET_DETAILS_PVT
- show dependent code
-
ECE_TIMEZONE_API
- show dependent code
-
FND_TIMEZONES
- show dependent code
-
HR_LOCATIONS_V
-
HR_LOC_BUS
- show dependent code
-
HZ_REGISTRY_VALIDATE_V2PUB
- show dependent code
-
HZ_TIMEZONE_PUB
- show dependent code
-
IEC_VALIDATE_PVT
- show dependent code
-
IEX_LOCATIONS_V
-
IRC_NOTIFICATION_DATA_PKG
- show dependent code
-
JTF_RESOURCE_UTL
- show dependent code
-
JTF_RS_RESOURCE_WF_PUB
- show dependent code
-
JTF_TASKS_V
-
MST_GEOCODING
- show dependent code
-
ORACLEAPPS
- show dependent code
-
OTA_TIMEZONE_UTIL
- show dependent code
-
PON_OA_UTIL_PKG
- show dependent code
-
PVX_UTILITY_PVT
- show dependent code
-
PV_ASSIGNMENT_PVT
- show dependent code
-
RRS_SITE_INFO
- show dependent code
-
WF_MAIL_UTIL
- show dependent code
-
WIP_DATETIMES
- show dependent code
-
WIP_EAM_WORKREQUEST_PVT
- show dependent code
-
WSH_LOCATIONS_PKG
- show dependent code