VIEW: APPS.IGS_AS_SUAAI_HIST_V

Source

View Text - Preformatted

SELECT suaai.rowid ,suaai.person_id ,pev.person_number ,p.PARTY_NAME ,pev.full_name ,L1.meaning ,pev.birth_date ,api.api_person_id ,IGS_EN_GEN_003.enrp_get_encmbrd_ind(Suaai.person_id) ,DECODE(pev.DATE_OF_DEATH,NULL,NVL(PD.DECEASED_IND,'N'),'Y') ,suaai.course_cd ,suaai.unit_cd ,suaai.cal_type ,suaai.ci_sequence_number ,SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(suaai.cal_type,suaai.ci_sequence_number),1,10) ,SUBSTR(IGS_CA_GEN_001.calp_get_alt_cd(suaai.cal_type,suaai.ci_sequence_number),1,10) ,suaai.ass_id ,suaai.creation_dt ,suaai.attempt_number ,asi.assessment_type ,SUBSTR(IGS_AS_GEN_003.assp_get_uai_ref(suaai.person_id,suaai.course_cd,suaai.unit_cd, suaai.cal_type,suaai.ci_sequence_number,suaai.ass_id,suaai.uoo_id), 1, 10) ,suaai.created_by, suaai.creation_date, suaai.last_updated_by, suaai.last_update_date, suaai.last_update_login, suaai.uoo_id, uoo.location_cd, uoo.unit_class FROM IGS_AS_SU_ATMPT_ITM suaai, IGS_AS_ASSESSMNT_ITM asi, IGS_PS_UNIT_OFR_OPT uoo, IGS_PE_PERSON_BASE_V pev, IGS_PE_HZ_PARTIES PD, fnd_lookup_values L1, HZ_PARTIES P, IGS_PE_PERSON_ID_TYP PIT, IGS_PE_ALT_PERS_ID API WHERE suaai.ass_id = asi.ass_id AND Suaai.person_id = pev.person_id AND Suaai.uoo_id = uoo.uoo_id AND Suaai.person_id = p.party_id AND Suaai.PERSON_ID = API.PE_PERSON_ID(+) AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE(+) AND PIT.PREFERRED_IND(+) = 'Y' AND SYSDATE BETWEEN API.START_DT(+) AND NVL(API.END_DT(+), SYSDATE) AND Suaai.person_id = PD.PARTY_ID (+) AND pev.GENDER = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER' AND l1.language(+) = userenv('LANG') AND l1.view_application_id(+) = 222 AND l1.security_group_id(+) = 0

View Text - HTML Formatted

SELECT SUAAI.ROWID
, SUAAI.PERSON_ID
, PEV.PERSON_NUMBER
, P.PARTY_NAME
, PEV.FULL_NAME
, L1.MEANING
, PEV.BIRTH_DATE
, API.API_PERSON_ID
, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(SUAAI.PERSON_ID)
, DECODE(PEV.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y')
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUAAI.ASS_ID
, SUAAI.CREATION_DT
, SUAAI.ATTEMPT_NUMBER
, ASI.ASSESSMENT_TYPE
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_UAI_REF(SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.UOO_ID)
, 1
, 10)
, SUAAI.CREATED_BY
, SUAAI.CREATION_DATE
, SUAAI.LAST_UPDATED_BY
, SUAAI.LAST_UPDATE_DATE
, SUAAI.LAST_UPDATE_LOGIN
, SUAAI.UOO_ID
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_ASSESSMNT_ITM ASI
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PE_PERSON_BASE_V PEV
, IGS_PE_HZ_PARTIES PD
, FND_LOOKUP_VALUES L1
, HZ_PARTIES P
, IGS_PE_PERSON_ID_TYP PIT
, IGS_PE_ALT_PERS_ID API
WHERE SUAAI.ASS_ID = ASI.ASS_ID
AND SUAAI.PERSON_ID = PEV.PERSON_ID
AND SUAAI.UOO_ID = UOO.UOO_ID
AND SUAAI.PERSON_ID = P.PARTY_ID
AND SUAAI.PERSON_ID = API.PE_PERSON_ID(+)
AND API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE(+)
AND PIT.PREFERRED_IND(+) = 'Y'
AND SYSDATE BETWEEN API.START_DT(+)
AND NVL(API.END_DT(+)
, SYSDATE)
AND SUAAI.PERSON_ID = PD.PARTY_ID (+)
AND PEV.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0