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

VIEW: APPS.PER_QUALIFICATION_TYPES_VL

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

View Type

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


multilingual view for qualification types


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION1 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION2 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION3 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION4 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION5 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION6 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION7 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION8 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION9 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION10 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION11 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION12 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION13 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION14 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION15 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION16 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION17 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION18 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION19 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION20 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION21 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION22 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION23 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION24 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION25 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION26 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION27 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION28 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION29 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION30 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
INFORMATION_CATEGORY VARCHAR2 (30)
Column selected from base table PER_QUALIFICATION_TYPES
QUALIFICATION_TYPE_ID NUMBER (9) Yes Column selected from base table PER_QUALIFICATION_TYPES
CATEGORY VARCHAR2 (30) Yes Column selected from base table PER_QUALIFICATION_TYPES
RANK NUMBER (9)
Column selected from base table PER_QUALIFICATION_TYPES
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE1 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE2 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE3 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE4 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE5 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE6 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE7 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE8 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE9 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE10 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE11 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE12 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE13 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE14 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE15 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE16 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE17 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE18 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE19 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
ATTRIBUTE20 VARCHAR2 (150)
Column selected from base table PER_QUALIFICATION_TYPES
LAST_UPDATE_DATE DATE

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

Column selected from base table PER_QUALIFICATION_TYPES
NAME VARCHAR2 (150) Yes Translated column selected from PER_QUALIFICATION_TYPES_TL
Query Text

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


SELECT ROW_ID
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION_CATEGORY
,      QUALIFICATION_TYPE_ID
,      CATEGORY
,      RANK
,      OBJECT_VERSION_NUMBER
,      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
,      NAME
FROM APPS.PER_QUALIFICATION_TYPES_VL;

Dependencies

[top of page]

APPS.PER_QUALIFICATION_TYPES_VL references the following:

SchemaAPPS
SynonymPER_QUALIFICATION_TYPES
SynonymPER_QUALIFICATION_TYPES_TL
APPS.PER_QUALIFICATION_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyBEN_PD_RATE_AND_CVG_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_ELPRO_MODULE - show dependent code
Package BodyBEN_PLAN_DESIGN_PROGRAM_MODULE - show dependent code
Package BodyHR_PUMP_GET - show dependent code
Package BodyIRC_UTILITIES_PKG - show dependent code
Package BodyPER_COMPETENCE_DATA_PUMP - show dependent code
Package BodyPER_JP_EMPDET_ARCHIVE_PKG - show dependent code