VIEW: APPS.IGS_AD_TER_ED_UNI_AT_V

Source

View Text - Preformatted

SELECT ATEUA.ROWID ROW_ID, ATEUA.PERSON_ID PERSON_ID, ATEUA.TE_SEQUENCE_NUMBER TE_SEQUENCE_NUMBER, ATEUA.SEQUENCE_NUMBER SEQUENCE_NUMBER, ATEUA.ENROLLED_YR ENROLLED_YR, ATEUA.UNIT_CD UNIT_CD , ATEUA.TITLE TITLE, ATEUA.CREDIT_POINTS CREDIT_POINTS, ATEUA.GRADE GRADE, ATEUA.RESULT_TYPE RESULT_TYPE, LKUPV.MEANING MEANING, ATEUA.DISCIPLINE_GROUP_CD DISCIPLINE_GROUP_CD, DI.DESCRIPTION DESCRIPTION, DI.CLOSED_IND CLOSED_IND, ATEUA.CREATED_BY CREATED_BY, ATEUA.CREATION_DATE CREATION_DATE, ATEUA.LAST_UPDATED_BY LAST_UPDATED_BY, ATEUA.LAST_UPDATE_DATE LAST_UPDATE_DATE, ATEUA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_TER_ED_UNI_AT ATEUA, IGS_PS_DSCP DI,IGS_LOOKUPS_VIEW LKUPV WHERE LKUPV.LOOKUP_CODE = ATEUA.RESULT_TYPE AND LKUPV.LOOKUP_TYPE = 'RESULT_TYPE' AND ATEUA.DISCIPLINE_GROUP_CD = DI.DISCIPLINE_GROUP_CD

View Text - HTML Formatted

SELECT ATEUA.ROWID ROW_ID
, ATEUA.PERSON_ID PERSON_ID
, ATEUA.TE_SEQUENCE_NUMBER TE_SEQUENCE_NUMBER
, ATEUA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, ATEUA.ENROLLED_YR ENROLLED_YR
, ATEUA.UNIT_CD UNIT_CD
, ATEUA.TITLE TITLE
, ATEUA.CREDIT_POINTS CREDIT_POINTS
, ATEUA.GRADE GRADE
, ATEUA.RESULT_TYPE RESULT_TYPE
, LKUPV.MEANING MEANING
, ATEUA.DISCIPLINE_GROUP_CD DISCIPLINE_GROUP_CD
, DI.DESCRIPTION DESCRIPTION
, DI.CLOSED_IND CLOSED_IND
, ATEUA.CREATED_BY CREATED_BY
, ATEUA.CREATION_DATE CREATION_DATE
, ATEUA.LAST_UPDATED_BY LAST_UPDATED_BY
, ATEUA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATEUA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_TER_ED_UNI_AT ATEUA
, IGS_PS_DSCP DI
, IGS_LOOKUPS_VIEW LKUPV
WHERE LKUPV.LOOKUP_CODE = ATEUA.RESULT_TYPE
AND LKUPV.LOOKUP_TYPE = 'RESULT_TYPE'
AND ATEUA.DISCIPLINE_GROUP_CD = DI.DISCIPLINE_GROUP_CD