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


VIEW: APPS.PER_DISABILITIES_V

Object Details
Object Name: PER_DISABILITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_DISABILITIES_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
DISABILITY_ID NUMBER (10) Yes Refer to base table.
EFFECTIVE_START_DATE DATE
Yes Refer to base table.
EFFECTIVE_END_DATE DATE
Yes Refer to base table.
BUSINESS_GROUP_ID NUMBER (15) Yes Refer to base table.
PERSON_ID NUMBER (10) Yes Refer to base table.
INCIDENT_ID NUMBER (10)
Refer to base table.
INCIDENT_REFERENCE VARCHAR2 (30)
Refer to base table.
INCIDENT_DATE DATE

Refer to base table.
MEDICAL_ASSESSMENT_ID NUMBER (10)
Refer to base table.
CONSULTATION_DATE DATE

Refer to base table.
ORGANIZATION_ID NUMBER (15)
Refer to base table.
ORGANIZATION_NAME VARCHAR2 (240)
Refer to base table.
REGISTRATION_ID VARCHAR2 (30)
Refer to base table.
REGISTRATION_DATE DATE

Refer to base table.
REGISTRATION_EXP_DATE DATE

Refer to base table.
CATEGORY VARCHAR2 (30) Yes Refer to base table.
D_CATEGORY VARCHAR2 (80)
Refer to base table.
DESCRIPTION VARCHAR2 (2000)
Refer to base table.
DEGREE NUMBER (5)
Refer to base table.
STATUS VARCHAR2 (30)
Refer to base table.
D_STATUS VARCHAR2 (80)
Refer to base table.
FTE NUMBER (5) Yes Refer to base table.
REASON VARCHAR2 (30)
Refer to base table.
D_REASON VARCHAR2 (80)
Refer to base table.
PRE_REGISTRATION_JOB VARCHAR2 (30)
Refer to base table.
WORK_RESTRICTION VARCHAR2 (2000)
Refer to base table.
DIS_INFORMATION_CATEGORY VARCHAR2 (30)
Refer to base table.
DIS_INFORMATION1 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION2 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION3 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION4 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION5 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION6 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION7 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION8 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION9 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION10 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION11 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION12 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION13 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION14 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION15 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION16 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION17 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION18 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION19 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION20 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION21 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION22 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION23 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION24 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION25 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION26 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION27 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION28 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION29 VARCHAR2 (150)
Refer to base table.
DIS_INFORMATION30 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Refer to base table.
ATTRIBUTE1 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE2 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE3 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE4 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE5 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE6 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE7 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE8 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE9 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE10 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE11 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE12 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE13 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE14 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE15 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE16 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE17 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE18 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE19 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE20 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE21 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE22 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE23 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE24 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE25 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE26 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE27 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE28 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE29 VARCHAR2 (150)
Refer to base table.
ATTRIBUTE30 VARCHAR2 (150)
Refer to base table.
LAST_UPDATE_DATE DATE

Refer to base table.
LAST_UPDATED_BY NUMBER (15)
Refer to base table.
LAST_UPDATE_LOGIN NUMBER (15)
Refer to base table.
CREATED_BY NUMBER (15)
Refer to base table.
CREATION_DATE DATE

Refer to base table.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Refer to base table.
Query Text

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


SELECT DISABILITY_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      INCIDENT_ID
,      INCIDENT_REFERENCE
,      INCIDENT_DATE
,      MEDICAL_ASSESSMENT_ID
,      CONSULTATION_DATE
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      REGISTRATION_ID
,      REGISTRATION_DATE
,      REGISTRATION_EXP_DATE
,      CATEGORY
,      D_CATEGORY
,      DESCRIPTION
,      DEGREE
,      STATUS
,      D_STATUS
,      FTE
,      REASON
,      D_REASON
,      PRE_REGISTRATION_JOB
,      WORK_RESTRICTION
,      DIS_INFORMATION_CATEGORY
,      DIS_INFORMATION1
,      DIS_INFORMATION2
,      DIS_INFORMATION3
,      DIS_INFORMATION4
,      DIS_INFORMATION5
,      DIS_INFORMATION6
,      DIS_INFORMATION7
,      DIS_INFORMATION8
,      DIS_INFORMATION9
,      DIS_INFORMATION10
,      DIS_INFORMATION11
,      DIS_INFORMATION12
,      DIS_INFORMATION13
,      DIS_INFORMATION14
,      DIS_INFORMATION15
,      DIS_INFORMATION16
,      DIS_INFORMATION17
,      DIS_INFORMATION18
,      DIS_INFORMATION19
,      DIS_INFORMATION20
,      DIS_INFORMATION21
,      DIS_INFORMATION22
,      DIS_INFORMATION23
,      DIS_INFORMATION24
,      DIS_INFORMATION25
,      DIS_INFORMATION26
,      DIS_INFORMATION27
,      DIS_INFORMATION28
,      DIS_INFORMATION29
,      DIS_INFORMATION30
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_DISABILITIES_V;

Dependencies

[top of page]

APPS.PER_DISABILITIES_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_DISABILITIES_F
SynonymPER_MEDICAL_ASSESSMENTS
ViewPER_PEOPLE_F
SynonymPER_WORK_INCIDENTS
APPS.PER_DISABILITIES_V is referenced by following:

SchemaAPPS
Package BodyPER_KW_XDO_REPORT - show dependent code
Package BodyPER_MX_DISABILITY_API - show dependent code
Package BodyPQH_DE_CHILD_SEQ_PKG - show dependent code