VIEW: APPS.IGS_AS_SUSA_INQ_V

Source

View Text - Preformatted

SELECT SUSA.PERSON_ID , SUSA.COURSE_CD , SUSA.UNIT_SET_CD , SUSA.US_VERSION_NUMBER , SUBSTR(IGS_EN_GEN_007.ENRP_GET_SUSA_STATUS(SUSA.SELECTION_DT, SUSA.STUDENT_CONFIRMED_IND, SUSA.END_DT, SUSA.RQRMNTS_COMPLETE_IND),1,10) , US.UNIT_SET_CAT , USC.DESCRIPTION , USC.RANK , US.START_DT , US.REVIEW_DT , US.EXPIRY_DT , US.END_DT , SUSA.SEQUENCE_NUMBER , SUSA.SELECTION_DT , SUSA.STUDENT_CONFIRMED_IND , SUSA.END_DT , SUSA.PARENT_UNIT_SET_CD , SUSA.PARENT_SEQUENCE_NUMBER , SUSA.PRIMARY_SET_IND , SUSA.VOLUNTARY_END_IND , SUSA.AUTHORISED_PERSON_ID , SUSA.AUTHORISED_ON , NVL(SUSA.OVERRIDE_TITLE, US.SHORT_TITLE) , SUSA.RQRMNTS_COMPLETE_IND , SUSA.RQRMNTS_COMPLETE_DT , SUSA.S_COMPLETED_SOURCE_TYPE , SUSA.created_by , SUSA.creation_date , SUSA.last_updated_by , SUSA.last_update_date , SUSA.last_update_login FROM IGS_AS_SU_SETATMPT SUSA, IGS_EN_UNIT_SET US, IGS_EN_UNIT_SET_CAT USC WHERE US.UNIT_SET_CD = SUSA.UNIT_SET_CD AND US.VERSION_NUMBER = SUSA.US_VERSION_NUMBER AND USC.UNIT_SET_CAT = US.UNIT_SET_CAT

View Text - HTML Formatted

SELECT SUSA.PERSON_ID
, SUSA.COURSE_CD
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, SUBSTR(IGS_EN_GEN_007.ENRP_GET_SUSA_STATUS(SUSA.SELECTION_DT
, SUSA.STUDENT_CONFIRMED_IND
, SUSA.END_DT
, SUSA.RQRMNTS_COMPLETE_IND)
, 1
, 10)
, US.UNIT_SET_CAT
, USC.DESCRIPTION
, USC.RANK
, US.START_DT
, US.REVIEW_DT
, US.EXPIRY_DT
, US.END_DT
, SUSA.SEQUENCE_NUMBER
, SUSA.SELECTION_DT
, SUSA.STUDENT_CONFIRMED_IND
, SUSA.END_DT
, SUSA.PARENT_UNIT_SET_CD
, SUSA.PARENT_SEQUENCE_NUMBER
, SUSA.PRIMARY_SET_IND
, SUSA.VOLUNTARY_END_IND
, SUSA.AUTHORISED_PERSON_ID
, SUSA.AUTHORISED_ON
, NVL(SUSA.OVERRIDE_TITLE
, US.SHORT_TITLE)
, SUSA.RQRMNTS_COMPLETE_IND
, SUSA.RQRMNTS_COMPLETE_DT
, SUSA.S_COMPLETED_SOURCE_TYPE
, SUSA.CREATED_BY
, SUSA.CREATION_DATE
, SUSA.LAST_UPDATED_BY
, SUSA.LAST_UPDATE_DATE
, SUSA.LAST_UPDATE_LOGIN
FROM IGS_AS_SU_SETATMPT SUSA
, IGS_EN_UNIT_SET US
, IGS_EN_UNIT_SET_CAT USC
WHERE US.UNIT_SET_CD = SUSA.UNIT_SET_CD
AND US.VERSION_NUMBER = SUSA.US_VERSION_NUMBER
AND USC.UNIT_SET_CAT = US.UNIT_SET_CAT