VIEW: APPS.IGSFV_AD_APPL_EDUGOAL

Source

View Text - Preformatted

SELECT aed.POST_EDUGOAL_ID, aed.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, aed.ADMISSION_APPL_NUMBER, aed.NOMINATED_COURSE_CD, aed.SEQUENCE_NUMBER, aed.EDU_GOAL_ID, cc1.NAME, cc1.DESCRIPTION, acai.EDU_GOAL_PRIOR_ENROLL_ID, cc2.NAME, cc2.DESCRIPTION, aed.CREATED_BY, aed.CREATION_DATE, aed.LAST_UPDATED_BY, aed.LAST_UPDATE_DATE FROM igs_ad_edugoal aed, HZ_PARTIES P, HZ_PERSON_PROFILES PP, igs_ad_code_classes cc1, igs_ad_code_classes cc2, igs_ad_ps_appl_inst_all acai WHERE aed.PERSON_ID = p.PARTY_ID And P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) AND aed.EDU_GOAL_ID = cc1.CODE_ID AND aed.PERSON_ID = acai.PERSON_ID AND aed.ADMISSION_APPL_NUMBER = acai.ADMISSION_APPL_NUMBER AND aed.NOMINATED_COURSE_CD = acai.NOMINATED_COURSE_CD AND aed.SEQUENCE_NUMBER = acai.SEQUENCE_NUMBER AND acai.EDU_GOAL_PRIOR_ENROLL_ID = cc2.CODE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT AED.POST_EDUGOAL_ID
, AED.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, AED.ADMISSION_APPL_NUMBER
, AED.NOMINATED_COURSE_CD
, AED.SEQUENCE_NUMBER
, AED.EDU_GOAL_ID
, CC1.NAME
, CC1.DESCRIPTION
, ACAI.EDU_GOAL_PRIOR_ENROLL_ID
, CC2.NAME
, CC2.DESCRIPTION
, AED.CREATED_BY
, AED.CREATION_DATE
, AED.LAST_UPDATED_BY
, AED.LAST_UPDATE_DATE
FROM IGS_AD_EDUGOAL AED
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_PS_APPL_INST_ALL ACAI
WHERE AED.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND AED.EDU_GOAL_ID = CC1.CODE_ID
AND AED.PERSON_ID = ACAI.PERSON_ID
AND AED.ADMISSION_APPL_NUMBER = ACAI.ADMISSION_APPL_NUMBER
AND AED.NOMINATED_COURSE_CD = ACAI.NOMINATED_COURSE_CD
AND AED.SEQUENCE_NUMBER = ACAI.SEQUENCE_NUMBER
AND ACAI.EDU_GOAL_PRIOR_ENROLL_ID = CC2.CODE_ID(+) WITH READ ONLY