DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_TIMEZONES_V

Object Details
Object Name: OKX_TIMEZONES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_TIMEZONES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays information about timezones.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TIMEZONE_ID NUMBER (15) Yes Primary Key
GLOBAL_TIMEZONE_NAME VARCHAR2 (50) Yes Global Timezone Name which associates with a value of GMT Deviation Hour
GMT_DEVIATION_HOURS NUMBER
Yes Deviation Hours from Greenwich Mean Time
DAYLIGHT_SAVINGS_TIME_FLAG VARCHAR2 (1) Yes Deviation Hours from Greenwich Mean Time
BEGIN_DST_MONTH VARCHAR2 (3)
Month in which daylight savings begin
BEGIN_DST_DAY NUMBER

Day of the Month daylight savings begin
BEGIN_DST_WEEK_OF_MONTH NUMBER

Week of the Month daylight savings begin
BEGIN_DST_DAY_OF_MONTH NUMBER

Day of the Week daylight savings begin
BEGIN_DST_HOUR NUMBER

Hour of the day daylight savings begin
END_DST_MONTH VARCHAR2 (3)
Month in which daylight savings end
END_DST_DAY NUMBER

Day of the Month daylight savings end
END_DST_WEEK_OF_MONTH NUMBER

Week of the Month daylight savings end
END_DAY_OF_WEEK NUMBER

Day of the Week daylight savings end
END_DST_HOUR NUMBER

Hour of the day daylight savings end
NAME VARCHAR2 (80) Yes Timezone Name associated with a timezone id
DESCRIPTION VARCHAR2 (80) Yes Description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TIMEZONE_ID
,      GLOBAL_TIMEZONE_NAME
,      GMT_DEVIATION_HOURS
,      DAYLIGHT_SAVINGS_TIME_FLAG
,      BEGIN_DST_MONTH
,      BEGIN_DST_DAY
,      BEGIN_DST_WEEK_OF_MONTH
,      BEGIN_DST_DAY_OF_MONTH
,      BEGIN_DST_HOUR
,      END_DST_MONTH
,      END_DST_DAY
,      END_DST_WEEK_OF_MONTH
,      END_DAY_OF_WEEK
,      END_DST_HOUR
,      NAME
,      DESCRIPTION
FROM APPS.OKX_TIMEZONES_V;

Dependencies

[top of page]

APPS.OKX_TIMEZONES_V references the following:

SchemaAPPS
SynonymFND_TIMEZONES_B
SynonymFND_TIMEZONES_TL
SynonymHZ_TIMEZONES
SynonymHZ_TIMEZONES_TL
APPS.OKX_TIMEZONES_V is referenced by following:

SchemaAPPS
Package BodyOKC_CYL_PVT - show dependent code
Package BodyOKC_IGS_PVT - show dependent code
Package BodyOKC_ISE_PVT - show dependent code
Package BodyOKC_TAL_PVT - show dependent code
Package BodyOKC_TAV_PVT - show dependent code
Package BodyOKC_TGD_PVT - show dependent code
Package BodyOKC_TGN_PVT - show dependent code
Package BodyOKC_TIME_RES_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
ViewOKS_ENT_COVER_TIMES_V
Package BodyOKS_MASSCHANGE_PVT - show dependent code