VIEW: APPS.IGWFV_GRNT_PRPSL_PERS_DEG_ASGN

Source

View Text - Preformatted

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

View Text - HTML Formatted

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