VIEW: APPS.IGSFV_ST_PR_CONCENTRATION_ATTS

Source

View Text - Preformatted

SELECT SUSA.PERSON_ID, HP1.PARTY_NUMBER, HP1.PARTY_NAME, SUSA.COURSE_CD, PSV.TITLE,SUSA.UNIT_SET_CD, SUSA.US_VERSION_NUMBER,SUSA.SEQUENCE_NUMBER,US1.TITLE,SUSA.SELECTION_DT,SUSA.STUDENT_CONFIRMED_IND, '_LA:SUSA.STUDENT_CONFIRMED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING',SUSA.END_DT,SUSA.PARENT_UNIT_SET_CD, SUSA.PARENT_SEQUENCE_NUMBER,US2.TITLE,SUSA.PRIMARY_SET_IND, '_LA:SUSA.PRIMARY_SET_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING',SUSA.VOLUNTARY_END_IND, '_LA:SUSA.VOLUNTARY_END_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING',SUSA.AUTHORISED_PERSON_ID,HP2.PARTY_NUMBER, HP2.PARTY_NAME,SUSA.AUTHORISED_ON,SUSA.OVERRIDE_TITLE,SUSA.RQRMNTS_COMPLETE_IND, '_LA:SUSA.RQRMNTS_COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING',SUSA.RQRMNTS_COMPLETE_DT, SUSA.S_COMPLETED_SOURCE_TYPE,SUSA.CATALOG_CAL_TYPE,SUSA.CATALOG_SEQ_NUM,CI.START_DT,CI.END_DT,CI.DESCRIPTION, '_DF:IGS:IGS_AS_SU_SETATMPT_FLEX:SUSA',SUSA.CREATED_BY,SUSA.CREATION_DATE,SUSA.LAST_UPDATED_BY, SUSA.LAST_UPDATE_DATE FROM IGS_AS_SU_SETATMPT SUSA, HZ_PARTIES HP1, IGS_EN_STDNT_PS_ATT_ALL SCA, IGS_PS_VER_ALL PSV, IGS_EN_UNIT_SET_ALL US1, IGS_CA_INST_ALL CI, IGS_AS_SU_SETATMPT SUSA1, IGS_EN_UNIT_SET_ALL US2, HZ_PARTIES HP2 WHERE SUSA.PERSON_ID = HP1.PARTY_ID AND SUSA.PERSON_ID = SCA.PERSON_ID AND SUSA.COURSE_CD = SCA.COURSE_CD AND SUSA.COURSE_CD = PSV.COURSE_CD AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER AND SUSA.UNIT_SET_CD = US1.UNIT_SET_CD AND SUSA.US_VERSION_NUMBER = US1.VERSION_NUMBER AND SUSA.CATALOG_CAL_TYPE = CI.CAL_TYPE (+) AND SUSA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER (+) AND SUSA.PERSON_ID = SUSA1.PERSON_ID(+) AND SUSA.COURSE_CD = SUSA1.COURSE_CD(+) AND SUSA.PARENT_UNIT_SET_CD = SUSA1.UNIT_SET_CD (+) AND SUSA.PARENT_SEQUENCE_NUMBER = SUSA1.SEQUENCE_NUMBER (+) AND SUSA1.UNIT_SET_CD = US2.UNIT_SET_CD (+) AND SUSA1.US_VERSION_NUMBER = US2.VERSION_NUMBER (+) AND SUSA.AUTHORISED_PERSON_ID = HP2.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT SUSA.PERSON_ID
, HP1.PARTY_NUMBER
, HP1.PARTY_NAME
, SUSA.COURSE_CD
, PSV.TITLE
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, SUSA.SEQUENCE_NUMBER
, US1.TITLE
, SUSA.SELECTION_DT
, SUSA.STUDENT_CONFIRMED_IND
, '_LA:SUSA.STUDENT_CONFIRMED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUSA.END_DT
, SUSA.PARENT_UNIT_SET_CD
, SUSA.PARENT_SEQUENCE_NUMBER
, US2.TITLE
, SUSA.PRIMARY_SET_IND
, '_LA:SUSA.PRIMARY_SET_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUSA.VOLUNTARY_END_IND
, '_LA:SUSA.VOLUNTARY_END_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUSA.AUTHORISED_PERSON_ID
, HP2.PARTY_NUMBER
, HP2.PARTY_NAME
, SUSA.AUTHORISED_ON
, SUSA.OVERRIDE_TITLE
, SUSA.RQRMNTS_COMPLETE_IND
, '_LA:SUSA.RQRMNTS_COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUSA.RQRMNTS_COMPLETE_DT
, SUSA.S_COMPLETED_SOURCE_TYPE
, SUSA.CATALOG_CAL_TYPE
, SUSA.CATALOG_SEQ_NUM
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, '_DF:IGS:IGS_AS_SU_SETATMPT_FLEX:SUSA'
, SUSA.CREATED_BY
, SUSA.CREATION_DATE
, SUSA.LAST_UPDATED_BY
, SUSA.LAST_UPDATE_DATE
FROM IGS_AS_SU_SETATMPT SUSA
, HZ_PARTIES HP1
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL PSV
, IGS_EN_UNIT_SET_ALL US1
, IGS_CA_INST_ALL CI
, IGS_AS_SU_SETATMPT SUSA1
, IGS_EN_UNIT_SET_ALL US2
, HZ_PARTIES HP2
WHERE SUSA.PERSON_ID = HP1.PARTY_ID
AND SUSA.PERSON_ID = SCA.PERSON_ID
AND SUSA.COURSE_CD = SCA.COURSE_CD
AND SUSA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SUSA.UNIT_SET_CD = US1.UNIT_SET_CD
AND SUSA.US_VERSION_NUMBER = US1.VERSION_NUMBER
AND SUSA.CATALOG_CAL_TYPE = CI.CAL_TYPE (+)
AND SUSA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER (+)
AND SUSA.PERSON_ID = SUSA1.PERSON_ID(+)
AND SUSA.COURSE_CD = SUSA1.COURSE_CD(+)
AND SUSA.PARENT_UNIT_SET_CD = SUSA1.UNIT_SET_CD (+)
AND SUSA.PARENT_SEQUENCE_NUMBER = SUSA1.SEQUENCE_NUMBER (+)
AND SUSA1.UNIT_SET_CD = US2.UNIT_SET_CD (+)
AND SUSA1.US_VERSION_NUMBER = US2.VERSION_NUMBER (+)
AND SUSA.AUTHORISED_PERSON_ID = HP2.PARTY_ID (+) WITH READ ONLY