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


VIEW: APPS.HR_USAGE_EXCEPTIONS_V

Object Details
Object Name: HR_USAGE_EXCEPTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_USAGE_EXCEPTIONS_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 Mandatory Comments
EXCEPTION_ID NUMBER
Yes
EXCEPTION_USAGE_ID NUMBER
Yes
PATTERN_ID NUMBER
Yes
CALENDAR_ID NUMBER


CALENDAR_USAGE_ID NUMBER


EXCEPTION_CATEGORY VARCHAR2 (30)

EXCEPTION_START_TIME DATE
Yes
EXCEPTION_END_TIME DATE
Yes
EXCEPTION_NAME VARCHAR2 (80) Yes
PATTERN_NAME VARCHAR2 (80) Yes
EXCEPTION_CATEGORY_MEANING VARCHAR2 (80)

EXCEPTION_REASON VARCHAR2 (2000)

EX_USAGE_OBJECT_VERSION_NUMBER NUMBER


PAT_EX_OBJECT_VERSION_NUMBER NUMBER


Query Text

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


SELECT EXCEPTION_ID
,      EXCEPTION_USAGE_ID
,      PATTERN_ID
,      CALENDAR_ID
,      CALENDAR_USAGE_ID
,      EXCEPTION_CATEGORY
,      EXCEPTION_START_TIME
,      EXCEPTION_END_TIME
,      EXCEPTION_NAME
,      PATTERN_NAME
,      EXCEPTION_CATEGORY_MEANING
,      EXCEPTION_REASON
,      EX_USAGE_OBJECT_VERSION_NUMBER
,      PAT_EX_OBJECT_VERSION_NUMBER
FROM APPS.HR_USAGE_EXCEPTIONS_V;

Dependencies

[top of page]

APPS.HR_USAGE_EXCEPTIONS_V references the following:

SchemaAPPS
PL/SQL PackageHR_API - show dependent code
SynonymHR_EXCEPTION_USAGES
ViewHR_LOOKUPS
SynonymHR_PATTERNS
SynonymHR_PATTERN_EXCEPTIONS

APPS.HR_USAGE_EXCEPTIONS_V is not referenced by any database object