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

Object Details

Object Name:	PER_ABS_ATTENDANCE_TYPES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_ABS_ATTENDANCE_TYPES_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
ROW_ID	ROWID	(10)
ABSENCE_ATTENDANCE_TYPE_ID	NUMBER	(9)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)
INPUT_VALUE_ID	NUMBER	(9)
DATE_EFFECTIVE	DATE		Yes
NAME	VARCHAR2	(30)	Yes
ABSENCE_CATEGORY	VARCHAR2	(30)
COMMENTS	CLOB	(4000)
DATE_END	DATE
HOURS_OR_DAYS	VARCHAR2	(1)
INCREASING_OR_DECREASING_FLAG	VARCHAR2	(1)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE16	VARCHAR2	(150)
ATTRIBUTE17	VARCHAR2	(150)
ATTRIBUTE18	VARCHAR2	(150)
ATTRIBUTE19	VARCHAR2	(150)
ATTRIBUTE20	VARCHAR2	(150)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
D_HOURS_OR_DAYS	VARCHAR2	(80)
D_INC_DEC_FLAG	VARCHAR2	(80)
D_ABSENCE_CATEGORY	VARCHAR2	(80)
D_ELEMENT_NAME	VARCHAR2	(80)
ELEMENT_TYPE_ID	NUMBER	(9)
D_INPUT_VALUE_NAME	VARCHAR2	(80)
VALUE_UOM	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Version number of current row
INFORMATION_CATEGORY	VARCHAR2	(30)		Context column for developer descriptive flexfield
INFORMATION1	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION2	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION3	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION4	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION5	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION6	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION7	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION8	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION9	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION10	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION11	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION12	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION13	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION14	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION15	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION16	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION17	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION18	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION19	VARCHAR2	(150)		Developer Descriptive flexfield column
INFORMATION20	VARCHAR2	(150)		Developer Descriptive flexfield column
USER_ROLE	VARCHAR2	(30)		Type of User who will be allowed to create Absence of this type.
ASSIGNMENT_STATUS_TYPE_ID	NUMBER	(15)		Represent the status used to update the primary assignment once absence of this type is approved.
ADVANCE_PAY	VARCHAR2	(30)		Determines whether Advance Pay can be requested for this Absence Type.
ABSENCE_OVERLAP_FLAG	VARCHAR2	(30)		Absence Overlap Flag

Query Text

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


SELECT ROW_ID
,      ABSENCE_ATTENDANCE_TYPE_ID
,      BUSINESS_GROUP_ID
,      INPUT_VALUE_ID
,      DATE_EFFECTIVE
,      NAME
,      ABSENCE_CATEGORY
,      COMMENTS
,      DATE_END
,      HOURS_OR_DAYS
,      INCREASING_OR_DECREASING_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      D_HOURS_OR_DAYS
,      D_INC_DEC_FLAG
,      D_ABSENCE_CATEGORY
,      D_ELEMENT_NAME
,      ELEMENT_TYPE_ID
,      D_INPUT_VALUE_NAME
,      VALUE_UOM
,      OBJECT_VERSION_NUMBER
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      USER_ROLE
,      ASSIGNMENT_STATUS_TYPE_ID
,      ADVANCE_PAY
,      ABSENCE_OVERLAP_FLAG
FROM APPS.PER_ABS_ATTENDANCE_TYPES_V;

Dependencies

[top of page]

APPS.PER_ABS_ATTENDANCE_TYPES_V references the following:

APPS: HR_API - show dependent code; HR_LOOKUPS; PAY_ELEMENT_TYPES_F; PAY_ELEMENT_TYPES_F_TL; PAY_INPUT_VALUES_F; PAY_INPUT_VALUES_F_TL; PER_ABSENCE_ATTENDANCE_TYPES; PER_ABS_ATTENDANCE_TYPES_TL

APPS.PER_ABS_ATTENDANCE_TYPES_V is not referenced by any database object