VIEW: APPS.IGS_AS_UAP_SUA_V

Source

View Text - Preformatted

SELECT sua.person_id, sua.course_cd, sua.unit_cd, uap.version_number, sua.cal_type, sua.ci_sequence_number, uap.ass_pattern_id, uap.ass_pattern_cd, uap.description, uap.location_cd, uap.unit_class, uap.unit_mode, uap.dflt_pattern_ind, uap.logical_delete_dt, sua.location_cd, sua.unit_class, uc.unit_mode, uap.created_by, uap.creation_date, uap.last_updated_by, uap.last_update_date, uap.last_update_login ,sua.deg_aud_detail_id ,sua.uoo_id FROM IGS_EN_SU_ATTEMPT sua, IGS_AS_UNTAS_PATTERN uap, IGS_AS_UNIT_CLASS uc WHERE sua.unit_cd = uap.unit_cd AND sua.version_number = uap.version_number AND sua.cal_type = uap.cal_type AND sua.ci_sequence_number = uap.ci_sequence_number AND sua.unit_class = uc.unit_class AND IGS_AS_VAL_UAP.assp_val_sua_uap(sua.location_cd, sua.unit_class, uc.unit_mode, uap.location_cd, uap.unit_class, uap.unit_mode) = 'TRUE'

View Text - HTML Formatted

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, UAP.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UAP.ASS_PATTERN_ID
, UAP.ASS_PATTERN_CD
, UAP.DESCRIPTION
, UAP.LOCATION_CD
, UAP.UNIT_CLASS
, UAP.UNIT_MODE
, UAP.DFLT_PATTERN_IND
, UAP.LOGICAL_DELETE_DT
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, UAP.CREATED_BY
, UAP.CREATION_DATE
, UAP.LAST_UPDATED_BY
, UAP.LAST_UPDATE_DATE
, UAP.LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNTAS_PATTERN UAP
, IGS_AS_UNIT_CLASS UC
WHERE SUA.UNIT_CD = UAP.UNIT_CD
AND SUA.VERSION_NUMBER = UAP.VERSION_NUMBER
AND SUA.CAL_TYPE = UAP.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = UAP.CI_SEQUENCE_NUMBER
AND SUA.UNIT_CLASS = UC.UNIT_CLASS
AND IGS_AS_VAL_UAP.ASSP_VAL_SUA_UAP(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, UAP.LOCATION_CD
, UAP.UNIT_CLASS
, UAP.UNIT_MODE) = 'TRUE'