VIEW: APPS.IGS_AS_SU_SETATMPT_V

Source

View Text - Preformatted

SELECT IASS.ROWID, IASS.PERSON_ID, pdv.PERSON_NUMBER, pdv.FULL_NAME, pdv.SEX_MEANING, pdv.BIRTH_DT, pdv.API_PERSON_ID, IASS.COURSE_CD, IASS.UNIT_SET_CD, IASS.US_VERSION_NUMBER, IASS.SEQUENCE_NUMBER, IASS.SELECTION_DT, IASS.STUDENT_CONFIRMED_IND, IASS.END_DT, IASS.PARENT_UNIT_SET_CD, IASS.PARENT_SEQUENCE_NUMBER, IASS.PRIMARY_SET_IND, IASS.VOLUNTARY_END_IND, IASS.AUTHORISED_PERSON_ID, pdv1.person_number, IASS.AUTHORISED_ON, IASS.OVERRIDE_TITLE, IASS.RQRMNTS_COMPLETE_IND, IASS.RQRMNTS_COMPLETE_DT, IASS.S_COMPLETED_SOURCE_TYPE, ci.description CATALOG, IASS.CATALOG_CAL_TYPE, IASS.CATALOG_SEQ_NUM, IASS.ATTRIBUTE_CATEGORY, IASS.ATTRIBUTE1, IASS.ATTRIBUTE2, IASS.ATTRIBUTE3, IASS.ATTRIBUTE4, IASS.ATTRIBUTE5, IASS.ATTRIBUTE6, IASS.ATTRIBUTE7, IASS.ATTRIBUTE8, IASS.ATTRIBUTE9, IASS.ATTRIBUTE10, IASS.ATTRIBUTE11, IASS.ATTRIBUTE12, IASS.ATTRIBUTE13, IASS.ATTRIBUTE14, IASS.ATTRIBUTE15, IASS.ATTRIBUTE16, IASS.ATTRIBUTE17, IASS.ATTRIBUTE18, IASS.ATTRIBUTE19, IASS.ATTRIBUTE20, IASS.CREATED_BY, IASS.CREATION_DATE, IASS.LAST_UPDATED_BY, IASS.LAST_UPDATE_DATE, IASS.LAST_UPDATE_LOGIN, IASS.REQUEST_ID, IASS.PROGRAM_APPLICATION_ID, IASS.PROGRAM_ID, IASS.PROGRAM_UPDATE_DATE FROM IGS_AS_SU_SETATMPT IASS, IGS_PE_PERSON_V pdv, IGS_PE_PERSON_V pdv1, IGS_CA_INST ci WHERE pdv.PERSON_ID = IASS.PERSON_ID AND pdv1.PERSON_ID(+) = IASS.AUTHORISED_PERSON_ID AND ci.cal_type(+) = IASS.CATALOG_CAL_TYPE AND ci.sequence_number(+) = IASS.CATALOG_SEQ_NUM

View Text - HTML Formatted

SELECT IASS.ROWID
, IASS.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.FULL_NAME
, PDV.SEX_MEANING
, PDV.BIRTH_DT
, PDV.API_PERSON_ID
, IASS.COURSE_CD
, IASS.UNIT_SET_CD
, IASS.US_VERSION_NUMBER
, IASS.SEQUENCE_NUMBER
, IASS.SELECTION_DT
, IASS.STUDENT_CONFIRMED_IND
, IASS.END_DT
, IASS.PARENT_UNIT_SET_CD
, IASS.PARENT_SEQUENCE_NUMBER
, IASS.PRIMARY_SET_IND
, IASS.VOLUNTARY_END_IND
, IASS.AUTHORISED_PERSON_ID
, PDV1.PERSON_NUMBER
, IASS.AUTHORISED_ON
, IASS.OVERRIDE_TITLE
, IASS.RQRMNTS_COMPLETE_IND
, IASS.RQRMNTS_COMPLETE_DT
, IASS.S_COMPLETED_SOURCE_TYPE
, CI.DESCRIPTION CATALOG
, IASS.CATALOG_CAL_TYPE
, IASS.CATALOG_SEQ_NUM
, IASS.ATTRIBUTE_CATEGORY
, IASS.ATTRIBUTE1
, IASS.ATTRIBUTE2
, IASS.ATTRIBUTE3
, IASS.ATTRIBUTE4
, IASS.ATTRIBUTE5
, IASS.ATTRIBUTE6
, IASS.ATTRIBUTE7
, IASS.ATTRIBUTE8
, IASS.ATTRIBUTE9
, IASS.ATTRIBUTE10
, IASS.ATTRIBUTE11
, IASS.ATTRIBUTE12
, IASS.ATTRIBUTE13
, IASS.ATTRIBUTE14
, IASS.ATTRIBUTE15
, IASS.ATTRIBUTE16
, IASS.ATTRIBUTE17
, IASS.ATTRIBUTE18
, IASS.ATTRIBUTE19
, IASS.ATTRIBUTE20
, IASS.CREATED_BY
, IASS.CREATION_DATE
, IASS.LAST_UPDATED_BY
, IASS.LAST_UPDATE_DATE
, IASS.LAST_UPDATE_LOGIN
, IASS.REQUEST_ID
, IASS.PROGRAM_APPLICATION_ID
, IASS.PROGRAM_ID
, IASS.PROGRAM_UPDATE_DATE
FROM IGS_AS_SU_SETATMPT IASS
, IGS_PE_PERSON_V PDV
, IGS_PE_PERSON_V PDV1
, IGS_CA_INST CI
WHERE PDV.PERSON_ID = IASS.PERSON_ID
AND PDV1.PERSON_ID(+) = IASS.AUTHORISED_PERSON_ID
AND CI.CAL_TYPE(+) = IASS.CATALOG_CAL_TYPE
AND CI.SEQUENCE_NUMBER(+) = IASS.CATALOG_SEQ_NUM