VIEW: APPS.IGS_PE_PERSON_PREFS_ENQ_V

Source

View Text - Preformatted

SELECT pp.person_id, pp.enq_acad_cal_type, pp.enq_acad_ci_sequence_number, SUBSTR(IGS_CA_GEN_001.calp_get_alt_cd(pp.enq_acad_cal_type, pp.enq_acad_ci_sequence_number),1,10), ci1.start_dt, ci1.end_dt, pp.enq_adm_cal_type, pp.enq_adm_ci_sequence_number, SUBSTR(IGS_CA_GEN_001.calp_get_alt_cd(pp.enq_adm_cal_type, pp.enq_adm_ci_sequence_number),1,10), ci2.start_dt, ci2.end_dt, pp.CREATED_BY, pp.CREATION_DATE, pp.LAST_UPDATED_BY, pp.LAST_UPDATE_DATE, pp.LAST_UPDATE_LOGIN FROM IGS_PE_PERS_PREFS pp, IGS_CA_INST_REL cir, IGS_CA_INST ci1, IGS_CA_INST ci2 WHERE cir.sup_cal_type (+) = pp.enq_acad_cal_type AND cir.sup_ci_sequence_number (+) = pp.enq_acad_ci_sequence_number AND cir.sub_cal_type (+) = pp.enq_adm_cal_type AND cir.sub_ci_sequence_number (+) = pp.enq_adm_ci_sequence_number AND ci1.cal_type (+) = cir.sup_cal_type AND ci1.sequence_number (+) = cir.sup_ci_sequence_number AND ci2.cal_type (+) = cir.sub_cal_type AND ci2.sequence_number (+) = cir.sub_ci_sequence_number

View Text - HTML Formatted

SELECT PP.PERSON_ID
, PP.ENQ_ACAD_CAL_TYPE
, PP.ENQ_ACAD_CI_SEQUENCE_NUMBER
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(PP.ENQ_ACAD_CAL_TYPE
, PP.ENQ_ACAD_CI_SEQUENCE_NUMBER)
, 1
, 10)
, CI1.START_DT
, CI1.END_DT
, PP.ENQ_ADM_CAL_TYPE
, PP.ENQ_ADM_CI_SEQUENCE_NUMBER
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(PP.ENQ_ADM_CAL_TYPE
, PP.ENQ_ADM_CI_SEQUENCE_NUMBER)
, 1
, 10)
, CI2.START_DT
, CI2.END_DT
, PP.CREATED_BY
, PP.CREATION_DATE
, PP.LAST_UPDATED_BY
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATE_LOGIN
FROM IGS_PE_PERS_PREFS PP
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI1
, IGS_CA_INST CI2
WHERE CIR.SUP_CAL_TYPE (+) = PP.ENQ_ACAD_CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER (+) = PP.ENQ_ACAD_CI_SEQUENCE_NUMBER
AND CIR.SUB_CAL_TYPE (+) = PP.ENQ_ADM_CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER (+) = PP.ENQ_ADM_CI_SEQUENCE_NUMBER
AND CI1.CAL_TYPE (+) = CIR.SUP_CAL_TYPE
AND CI1.SEQUENCE_NUMBER (+) = CIR.SUP_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE (+) = CIR.SUB_CAL_TYPE
AND CI2.SEQUENCE_NUMBER (+) = CIR.SUB_CI_SEQUENCE_NUMBER