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.HR_CALENDAR_USAGES_V

Object Details

Object Name:	HR_CALENDAR_USAGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_CALENDAR_USAGES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length
CALENDAR_ID	NUMBER
CALENDAR_USAGE_ID	NUMBER
PRIMARY_KEY_VALUE	NUMBER
PURPOSE_USAGE_ID	NUMBER
START_DATE	DATE
DATE_START	DATE
TIME_START	VARCHAR2	(5)
END_DATE	DATE
DATE_END	DATE
TIME_END	VARCHAR2	(5)
OBJECT_VERSION_NUMBER	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
ENTITY_NAME	VARCHAR2	(30)
ENTITY_NAME_MEANING	VARCHAR2	(80)
PATTERN_PURPOSE	VARCHAR2	(30)
PATTERN_PURPOSE_MEANING	VARCHAR2	(80)
PRIMARY_KEY_VALUE_MEANING	VARCHAR2	(700)

Query Text

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


SELECT CALENDAR_ID
,      CALENDAR_USAGE_ID
,      PRIMARY_KEY_VALUE
,      PURPOSE_USAGE_ID
,      START_DATE
,      DATE_START
,      TIME_START
,      END_DATE
,      DATE_END
,      TIME_END
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ENTITY_NAME
,      ENTITY_NAME_MEANING
,      PATTERN_PURPOSE
,      PATTERN_PURPOSE_MEANING
,      PRIMARY_KEY_VALUE_MEANING
FROM APPS.HR_CALENDAR_USAGES_V;

Dependencies

[top of page]

APPS.HR_CALENDAR_USAGES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; FND_SESSIONS; HR_API - show dependent code; HR_CALENDAR_USAGES; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_LOOKUPS; HR_ORGANIZATION_UNITS; HR_PATTERN_PURPOSE_USAGES; HR_POSITIONS_F; HR_SECURITY - show dependent code; PER_ALL_PEOPLE_F; PER_ASSIGNMENTS_F; PER_JOBS_TL

APPS.HR_CALENDAR_USAGES_V is referenced by following:

PUBLIC: HR_CALENDAR_USAGES_V