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

VIEW: APPS.PER_QUALIFICATIONS_VL

Object Details
Object Name: PER_QUALIFICATIONS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_QUALIFICATIONS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


mls view for qualifications


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Column selected from base table PER_QUALIFICATIONS
QUALIFICATION_ID NUMBER (9) Yes Column selected from base table PER_QUALIFICATIONS
BUSINESS_GROUP_ID NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column selected from base table PER_QUALIFICATIONS
PERSON_ID NUMBER (10)
Column selected from base table PER_QUALIFICATIONS
TITLE VARCHAR2 (120)
Translated column selected from PER_QUALIFICATIONS_TL
GRADE_ATTAINED VARCHAR2 (100)
Translated column selected from PER_QUALIFICATIONS_TL
STATUS VARCHAR2 (30)
Column selected from base table PER_QUALIFICATIONS
AWARDED_DATE DATE

Column selected from base table PER_QUALIFICATIONS
FEE NUMBER (19)
Column selected from base table PER_QUALIFICATIONS
FEE_CURRENCY VARCHAR2 (15)
Column selected from base table PER_QUALIFICATIONS
TRAINING_COMPLETED_AMOUNT NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
REIMBURSEMENT_ARRANGEMENTS VARCHAR2 (2000)
Translated column selected from PER_QUALIFICATIONS_TL
TRAINING_COMPLETED_UNITS VARCHAR2 (100)
Translated column selected from PER_QUALIFICATIONS_TL
TOTAL_TRAINING_AMOUNT NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
START_DATE DATE

Column selected from base table PER_QUALIFICATIONS
END_DATE DATE

Column selected from base table PER_QUALIFICATIONS
LICENSE_NUMBER VARCHAR2 (60)
Column selected from base table PER_QUALIFICATIONS
EXPIRY_DATE DATE

Column selected from base table PER_QUALIFICATIONS
LICENSE_RESTRICTIONS VARCHAR2 (255)
Translated column selected from PER_QUALIFICATIONS_TL
PROJECTED_COMPLETION_DATE DATE

Column selected from base table PER_QUALIFICATIONS
AWARDING_BODY VARCHAR2 (100)
Translated column selected from PER_QUALIFICATIONS_TL
TUITION_METHOD VARCHAR2 (30)
Column selected from base table PER_QUALIFICATIONS
GROUP_RANKING VARCHAR2 (100)
Translated column selected from PER_QUALIFICATIONS_TL
COMMENTS VARCHAR2 (2000)
Column selected from base table PER_QUALIFICATIONS
QUALIFICATION_TYPE_ID NUMBER (9) Yes Column selected from base table PER_QUALIFICATIONS
ATTENDANCE_ID NUMBER (9)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE1 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE2 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE3 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE4 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE5 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE6 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE7 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE8 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE9 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE10 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE11 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE12 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE13 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE14 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE15 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE16 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE17 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE18 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE19 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
ATTRIBUTE20 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
LAST_UPDATE_DATE DATE

Column selected from base table PER_QUALIFICATIONS
LAST_UPDATED_BY NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
LAST_UPDATE_LOGIN NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
CREATED_BY NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
CREATION_DATE DATE

Column selected from base table PER_QUALIFICATIONS
PARTY_ID NUMBER (15)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION_CATEGORY VARCHAR2 (30)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION1 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION2 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION3 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION4 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION5 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION6 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION7 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION8 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION9 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION10 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION11 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION12 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION13 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION14 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION15 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION16 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION17 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION18 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION19 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
QUA_INFORMATION20 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATIONS
PROFESSIONAL_BODY_NAME VARCHAR2 (80)
Column selected from base table PER_QUALIFICATIONS
MEMBERSHIP_NUMBER VARCHAR2 (80)
Column selected from base table PER_QUALIFICATIONS
MEMBERSHIP_CATEGORY VARCHAR2 (80)
Translated column selected from PER_QUALIFICATIONS_TL
SUBSCRIPTION_PAYMENT_METHOD VARCHAR2 (80)
Column selected from base table PER_QUALIFICATIONS
Query Text

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


SELECT ROW_ID
,      QUALIFICATION_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      PERSON_ID
,      TITLE
,      GRADE_ATTAINED
,      STATUS
,      AWARDED_DATE
,      FEE
,      FEE_CURRENCY
,      TRAINING_COMPLETED_AMOUNT
,      REIMBURSEMENT_ARRANGEMENTS
,      TRAINING_COMPLETED_UNITS
,      TOTAL_TRAINING_AMOUNT
,      START_DATE
,      END_DATE
,      LICENSE_NUMBER
,      EXPIRY_DATE
,      LICENSE_RESTRICTIONS
,      PROJECTED_COMPLETION_DATE
,      AWARDING_BODY
,      TUITION_METHOD
,      GROUP_RANKING
,      COMMENTS
,      QUALIFICATION_TYPE_ID
,      ATTENDANCE_ID
,      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
,      PARTY_ID
,      QUA_INFORMATION_CATEGORY
,      QUA_INFORMATION1
,      QUA_INFORMATION2
,      QUA_INFORMATION3
,      QUA_INFORMATION4
,      QUA_INFORMATION5
,      QUA_INFORMATION6
,      QUA_INFORMATION7
,      QUA_INFORMATION8
,      QUA_INFORMATION9
,      QUA_INFORMATION10
,      QUA_INFORMATION11
,      QUA_INFORMATION12
,      QUA_INFORMATION13
,      QUA_INFORMATION14
,      QUA_INFORMATION15
,      QUA_INFORMATION16
,      QUA_INFORMATION17
,      QUA_INFORMATION18
,      QUA_INFORMATION19
,      QUA_INFORMATION20
,      PROFESSIONAL_BODY_NAME
,      MEMBERSHIP_NUMBER
,      MEMBERSHIP_CATEGORY
,      SUBSCRIPTION_PAYMENT_METHOD
FROM APPS.PER_QUALIFICATIONS_VL;

Dependencies

[top of page]

APPS.PER_QUALIFICATIONS_VL references the following:

SchemaAPPS
SynonymPER_QUALIFICATIONS
SynonymPER_QUALIFICATIONS_TL
APPS.PER_QUALIFICATIONS_VL is referenced by following:

SchemaAPPS
Package BodyPER_JP_EMPDET_ARCHIVE_PKG - show dependent code