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

Object Details

Object Name:	HRI_OBI_CS_ABS_ABSENCE_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ABSN_ABSENCE_PK	NUMBER		Yes	ABSN_ABSENCE_PK
ABSN_ABSENCE_START_DATE	DATE			ABSN_ABSENCE_START_DATE
ABSN_ABSENCE_END_DATE	DATE			Absence End date
ABSN_NOTIFICATION_DATE	DATE			Notification Date
ABSN_PERSON_ABSENTEE_FK	NUMBER		Yes	Person Absentee Data
ABSN_ABSNCAT_FK	VARCHAR2	(30)		ABSN_ABSNCAT_FK
ABSN_ABSNRSN_FK	VARCHAR2	(30)	Yes	ABSN_ABSNRSN_FK
ABSN_STATUS_CODE	VARCHAR2	(30)		ABSN_STATUS_CODE
ABSN_DRTN_DAYS	NUMBER			ABSN_DRTN_DAYS
ABSN_DRTN_HRS	NUMBER			ABSN_DRTN_HRS

Query Text

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


SELECT ABSN_ABSENCE_PK
,      ABSN_ABSENCE_START_DATE
,      ABSN_ABSENCE_END_DATE
,      ABSN_NOTIFICATION_DATE
,      ABSN_PERSON_ABSENTEE_FK
,      ABSN_ABSNCAT_FK
,      ABSN_ABSNRSN_FK
,      ABSN_STATUS_CODE
,      ABSN_DRTN_DAYS
,      ABSN_DRTN_HRS
FROM APPS.HRI_OBI_CS_ABS_ABSENCE_V;

Dependencies

[top of page]

APPS.HRI_OBI_CS_ABS_ABSENCE_V references the following:

APPS: HRI_CS_ABSENCE_CT

APPS.HRI_OBI_CS_ABS_ABSENCE_V is not referenced by any database object