VIEW: APPS.IGS_PE_PERS_PEN_ENCUMB_V

Source

View Text - Preformatted

SELECT A.ROW_ID, A.PERSON_ID, A.ENCUMBRANCE_TYPE, B.DESCRIPTION, B.CLOSED_IND, B.S_ENCUMBRANCE_CAT, a.cal_type, a.sequence_number, CT.TERM, A.START_DT, A.EXPIRY_DT, A.AUTHORISING_PERSON_ID, C.PERSON_NUMBER, A.COMMENTS, A.SPO_COURSE_CD, A.SPO_SEQUENCE_NUMBER, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, A.AUTH_RESP_ID, A.AUTH_RESP_NAME, A.EXTERNAL_REFERENCE, L1.MEANING EXTERNAL_REFERENCE_DESC FROM IGS_PE_PERS_ENCUMB_V A, IGS_FI_ENCMB_TYPE B, IGS_PE_PERSON_BASE_V C, ( SELECT CI.CAL_TYPE, CI.SEQUENCE_NUMBER, DECODE(ct.s_cal_cat,'LOAD', IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(ci.cal_type, ci.sequence_number) || '/'|| NVL(ci.alternate_code, ci.cal_type), 'ACADEMIC', ci.alternate_code) TERM FROM igs_ca_inst ci, igs_ca_type ct WHERE ci.cal_type = ct.cal_type and ct.s_cal_cat in ('LOAD','ACADEMIC') ) CT , IGS_LOOKUP_VALUES L1 WHERE A.ENCUMBRANCE_TYPE = B.ENCUMBRANCE_TYPE AND A.AUTHORISING_PERSON_ID = C.PERSON_ID (+) AND A.CAL_TYPE = CT.CAL_TYPE(+) AND A.SEQUENCE_NUMBER = CT.SEQUENCE_NUMBER (+) AND A.EXTERNAL_REFERENCE = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'PE_EXT_REF'

View Text - HTML Formatted

SELECT A.ROW_ID
, A.PERSON_ID
, A.ENCUMBRANCE_TYPE
, B.DESCRIPTION
, B.CLOSED_IND
, B.S_ENCUMBRANCE_CAT
, A.CAL_TYPE
, A.SEQUENCE_NUMBER
, CT.TERM
, A.START_DT
, A.EXPIRY_DT
, A.AUTHORISING_PERSON_ID
, C.PERSON_NUMBER
, A.COMMENTS
, A.SPO_COURSE_CD
, A.SPO_SEQUENCE_NUMBER
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.AUTH_RESP_ID
, A.AUTH_RESP_NAME
, A.EXTERNAL_REFERENCE
, L1.MEANING EXTERNAL_REFERENCE_DESC
FROM IGS_PE_PERS_ENCUMB_V A
, IGS_FI_ENCMB_TYPE B
, IGS_PE_PERSON_BASE_V C
, ( SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, DECODE(CT.S_CAL_CAT
, 'LOAD'
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(CI.CAL_TYPE
, CI.SEQUENCE_NUMBER) || '/'|| NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 'ACADEMIC'
, CI.ALTERNATE_CODE) TERM
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE CI.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT IN ('LOAD'
, 'ACADEMIC') ) CT
, IGS_LOOKUP_VALUES L1
WHERE A.ENCUMBRANCE_TYPE = B.ENCUMBRANCE_TYPE
AND A.AUTHORISING_PERSON_ID = C.PERSON_ID (+)
AND A.CAL_TYPE = CT.CAL_TYPE(+)
AND A.SEQUENCE_NUMBER = CT.SEQUENCE_NUMBER (+)
AND A.EXTERNAL_REFERENCE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'PE_EXT_REF'