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.

DBA Data [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		Yes	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; AST_LM_EVENTS_V; AST_LM_REL_EXPAND_W_ACC_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; INV_LABEL - show dependent code; IRC_NOTIFICATION_DATA_PKG - show dependent code; IRC_NOTIFICATION_WORKFLOW_PKG - show dependent code; JTF_RESOURCE_UTL - show dependent code; JTF_RS_RESOURCE_WF_PUB - show dependent code; JTF_TASKS_V; 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