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.IGW_PRPO_BIOSKETCH_DEGREES_V

Object Details

Object Name:	IGW_PRPO_BIOSKETCH_DEGREES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGW.IGW_PRPO_BIOSKETCH_DEGREES_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

IGW_PRPO_BIOSKETCH_DEGREES_V displays a person's educational background. This information includes date of graduation, degree type, and area of specialization. This view is used in generating a flat file for Electronic Data Interchange.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PROPOSAL_ID	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(15)
PARTY_ID	NUMBER	(15)	Yes
DEGREE_CODE	VARCHAR2	(30)	Yes
DEGREE_TIME_PERIOD	DATE		Yes
DEGREE_DESCRIPTION	VARCHAR2	(80)	Yes
FIELD_OF_STUDY	VARCHAR2	(80)
AREA_OF_SPECIALIZATION	VARCHAR2	(80)
EDUCATIONAL_INSTITUTION	VARCHAR2	(100)
BIO_DEGREE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
BIO_DEGREE_ATTRIBUTE1	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE2	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE3	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE4	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE5	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE6	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE7	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE8	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE9	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE10	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE11	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE12	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE13	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE14	VARCHAR2	(150)
BIO_DEGREE_ATTRIBUTE15	VARCHAR2	(150)

Query Text

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


SELECT PROPOSAL_ID
,      PERSON_ID
,      PARTY_ID
,      DEGREE_CODE
,      DEGREE_TIME_PERIOD
,      DEGREE_DESCRIPTION
,      FIELD_OF_STUDY
,      AREA_OF_SPECIALIZATION
,      EDUCATIONAL_INSTITUTION
,      BIO_DEGREE_ATTRIBUTE_CATEGORY
,      BIO_DEGREE_ATTRIBUTE1
,      BIO_DEGREE_ATTRIBUTE2
,      BIO_DEGREE_ATTRIBUTE3
,      BIO_DEGREE_ATTRIBUTE4
,      BIO_DEGREE_ATTRIBUTE5
,      BIO_DEGREE_ATTRIBUTE6
,      BIO_DEGREE_ATTRIBUTE7
,      BIO_DEGREE_ATTRIBUTE8
,      BIO_DEGREE_ATTRIBUTE9
,      BIO_DEGREE_ATTRIBUTE10
,      BIO_DEGREE_ATTRIBUTE11
,      BIO_DEGREE_ATTRIBUTE12
,      BIO_DEGREE_ATTRIBUTE13
,      BIO_DEGREE_ATTRIBUTE14
,      BIO_DEGREE_ATTRIBUTE15
FROM APPS.IGW_PRPO_BIOSKETCH_DEGREES_V;

Dependencies

[top of page]

APPS.IGW_PRPO_BIOSKETCH_DEGREES_V references the following:

APPS: IGW_PERSON_DEGREES; IGW_PROP_PERSON_DEGREES

APPS.IGW_PRPO_BIOSKETCH_DEGREES_V is not referenced by any database object