View: IGWFV_GRNT_PRPSL_PERS_DEG_ASGN

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRNT_PRPSL_PERS_DEG_ASGN

View Text

SELECT PR.PROPOSAL_NUMBER
, PAPF.FULL_NAME
, LKUP1.MEANING
, PD.GRADUATION_DATE
, PD.DEGREE
, PD.FIELD_OF_STUDY
, PD.SPECIALIZATION
, PD.SCHOOL_NAME
, PPD.SHOW_FLAG
, PPD.DEGREE_SEQUENCE
, PR.PROPOSAL_ID
, PPD.PERSON_DEGREE_ID
, PPD.LAST_UPDATE_DATE
, PPD.LAST_UPDATED_BY
, PPD.CREATION_DATE
, PPD.CREATED_BY
FROM IGW_PROP_PERSON_DEGREES PPD
, IGW_PERSON_DEGREES PD
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
, IGW_LOOKUPS_V LKUP1
WHERE PR.PROPOSAL_ID = PPD.PROPOSAL_ID
AND PD.PERSON_DEGREE_ID = PPD.PERSON_DEGREE_ID
AND PAPF.PERSON_ID = PD.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PD.DEGREE_TYPE_CODE = LKUP1.LOOKUP_CODE
AND LKUP1.LOOKUP_TYPE = 'IGW_DEGREE_TYPES' WITH READ ONLY

Columns