DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_EDU_GOAL_V

Source

View Text - Preformatted

SELECT AE.ROWID ROW_ID, AE.POST_EDUGOAL_ID POST_EDUGOAL_ID, AE.PERSON_ID PERSON_ID, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER, AE.EDU_GOAL_ID EDU_GOAL_ID, CC.NAME NAME, CC.DESCRIPTION DESCRIPTION, AE.CREATED_BY CREATED_BY, AE.CREATION_DATE CREATION_DATE, AE.LAST_UPDATED_BY LAST_UPDATED_BY, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_EDUGOAL AE, IGS_AD_CODE_CLASSES CC WHERE CC.CODE_ID = AE.EDU_GOAL_ID
View Text - HTML Formatted

SELECT AE.ROWID ROW_ID
, AE.POST_EDUGOAL_ID POST_EDUGOAL_ID
, AE.PERSON_ID PERSON_ID
, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AE.EDU_GOAL_ID EDU_GOAL_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, AE.CREATED_BY CREATED_BY
, AE.CREATION_DATE CREATION_DATE
, AE.LAST_UPDATED_BY LAST_UPDATED_BY
, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_EDUGOAL AE
, IGS_AD_CODE_CLASSES CC
WHERE CC.CODE_ID = AE.EDU_GOAL_ID