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

VIEW: APPS.PER_SUBJECTS_TAKEN_VL

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

View Type

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


Single langauge join of PER_SUBJECTS_TAKEN and PER_SUBJECTS_TAKEN_TL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Column selected from base table PER_SUBJECTS_TAKEN
SUBJECTS_TAKEN_ID NUMBER (9) Yes Column selected from base table PER_SUBJECTS_TAKEN
START_DATE DATE
Yes Column selected from base table PER_SUBJECTS_TAKEN
MAJOR VARCHAR2 (30)
Column selected from base table PER_SUBJECTS_TAKEN
SUBJECT_STATUS VARCHAR2 (30) Yes Column selected from base table PER_SUBJECTS_TAKEN
SUBJECT VARCHAR2 (30) Yes Column selected from base table PER_SUBJECTS_TAKEN
GRADE_ATTAINED VARCHAR2 (100)
Translated column selected from PER_SUBJECTS_TAKEN_TL
END_DATE DATE

Column selected from base table PER_SUBJECTS_TAKEN
QUALIFICATION_ID NUMBER (9) Yes Column selected from base table PER_SUBJECTS_TAKEN
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE1 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE2 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE3 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE4 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE5 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE6 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE7 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE8 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE9 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE10 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE11 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE12 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE13 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE14 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE15 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE16 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE17 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE18 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE19 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
ATTRIBUTE20 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
LAST_UPDATE_DATE DATE

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

Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION_CATEGORY VARCHAR2 (30)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION1 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION2 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION3 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION4 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION5 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION6 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION7 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION8 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION9 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION10 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION11 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION12 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION13 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION14 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION15 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION16 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION17 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION18 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION19 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
SUB_INFORMATION20 VARCHAR2 (150)
Column selected from base table PER_SUBJECTS_TAKEN
Query Text

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


SELECT ROW_ID
,      SUBJECTS_TAKEN_ID
,      START_DATE
,      MAJOR
,      SUBJECT_STATUS
,      SUBJECT
,      GRADE_ATTAINED
,      END_DATE
,      QUALIFICATION_ID
,      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
,      SUB_INFORMATION_CATEGORY
,      SUB_INFORMATION1
,      SUB_INFORMATION2
,      SUB_INFORMATION3
,      SUB_INFORMATION4
,      SUB_INFORMATION5
,      SUB_INFORMATION6
,      SUB_INFORMATION7
,      SUB_INFORMATION8
,      SUB_INFORMATION9
,      SUB_INFORMATION10
,      SUB_INFORMATION11
,      SUB_INFORMATION12
,      SUB_INFORMATION13
,      SUB_INFORMATION14
,      SUB_INFORMATION15
,      SUB_INFORMATION16
,      SUB_INFORMATION17
,      SUB_INFORMATION18
,      SUB_INFORMATION19
,      SUB_INFORMATION20
FROM APPS.PER_SUBJECTS_TAKEN_VL;

Dependencies

[top of page]

APPS.PER_SUBJECTS_TAKEN_VL references the following:

SchemaAPPS
SynonymPER_SUBJECTS_TAKEN
SynonymPER_SUBJECTS_TAKEN_TL
APPS.PER_SUBJECTS_TAKEN_VL is referenced by following:

SchemaPUBLIC
SynonymPER_SUBJECTS_TAKEN_VL