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_QUALIFICATIONS1_DFV

Object Details

Object Name:	PER_QUALIFICATIONS1_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
ALLOWANCE_DATE	DATE
ESTABLISHMENT_TYPE	VARCHAR2	(150)
COURSE_TYPE	VARCHAR2	(150)
LICENSE_TYPE	VARCHAR2	(150)
CERT_PRESENTED	VARCHAR2	(150)
EDUCATION_CODE	NUMBER
PREFERRED_LEVEL__	VARCHAR2	(150)
DECISION_NUMBER	VARCHAR2	(150)
DATE_OF_DECISION	DATE
TYPE_OF_DECISION	VARCHAR2	(150)
NAME_OF_FOREIGN_DIPLOMA	VARCHAR2	(150)
TYPE_OF_RECORD	VARCHAR2	(150)
EDUCATIONAL_LEVEL	VARCHAR2	(150)
QUALIFICATION_LEVEL	VARCHAR2	(150)
NUS_2000_CODE	VARCHAR2	(150)
HIGHEST_LEVEL	VARCHAR2	(150)
GRADE_POINT_AVERAGE	VARCHAR2	(150)
NUMBER_OF_CREDITS	NUMBER
COURSE_NAME	VARCHAR2	(150)
QUALIFICATION_IMPROVEMENT_TYPE	VARCHAR2	(150)
DOCUMENT_NAME	VARCHAR2	(150)
DIPLOMA_CERTIFICATE_SERIES	VARCHAR2	(150)
DIPLOMA_CERTIFICATE_NUMBER	VARCHAR2	(150)
PROFESSIONAL_QUALIFICATION	VARCHAR2	(150)
PROFESSION_CODE	VARCHAR2	(150)
SUN_CODE	VARCHAR2	(150)
EDUCATION_COURSE	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1087)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      ALLOWANCE_DATE
,      ESTABLISHMENT_TYPE
,      COURSE_TYPE
,      LICENSE_TYPE
,      CERT_PRESENTED
,      EDUCATION_CODE
,      PREFERRED_LEVEL__
,      DECISION_NUMBER
,      DATE_OF_DECISION
,      TYPE_OF_DECISION
,      NAME_OF_FOREIGN_DIPLOMA
,      TYPE_OF_RECORD
,      EDUCATIONAL_LEVEL
,      QUALIFICATION_LEVEL
,      NUS_2000_CODE
,      HIGHEST_LEVEL
,      GRADE_POINT_AVERAGE
,      NUMBER_OF_CREDITS
,      COURSE_NAME
,      QUALIFICATION_IMPROVEMENT_TYPE
,      DOCUMENT_NAME
,      DIPLOMA_CERTIFICATE_SERIES
,      DIPLOMA_CERTIFICATE_NUMBER
,      PROFESSIONAL_QUALIFICATION
,      PROFESSION_CODE
,      SUN_CODE
,      EDUCATION_COURSE
,      CONCATENATED_SEGMENTS
FROM APPS.PER_QUALIFICATIONS1_DFV;

Dependencies

[top of page]

APPS.PER_QUALIFICATIONS1_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_QUALIFICATIONS

APPS.PER_QUALIFICATIONS1_DFV is referenced by following:

PUBLIC: PER_QUALIFICATIONS1_DFV