VIEW: APPS.IGSFV_PERSON_HOLD_EFFECTS

Source

View Text - Preformatted

SELECT PEE.PERSON_ID PERSON_ID, PEE.ENCUMBRANCE_TYPE HOLD_TYPE, PEE.PEN_START_DT HOLD_EFFECTIVE_START_DATE, PEE.S_ENCMB_EFFECT_TYPE SYSTEM_HOLD_EFFECT_TYPE, PEE.PEE_START_DT HOLD_EFCT_EFFECTIVE_START_DATE, PEE.SEQUENCE_NUMBER SEQUENCE_NUMBER, PEE.EXPIRY_DT EXPIRY_DATE, PEE.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_LOAD, PEE.COURSE_CD PROGRAM_CODE, PEE.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE, HP.PARTY_NUMBER PERSON_NUMBER, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION, '_LA:PEE.S_ENCMB_EFFECT_TYPE:IGS_LOOKUP_VALUES:ENCMB_EFFECT_TYPE:MEANING', EAT.DESCRIPTION RESTRICTED_ATTENDANCE_TYP_DESC, PEE.CREATED_BY, PEE.CREATION_DATE, PEE.LAST_UPDATED_BY, PEE.LAST_UPDATE_DATE FROM IGS_PE_PERSENC_EFFCT PEE, IGS_FI_ENCMB_TYPE_ALL ENT, HZ_PARTIES HP, IGS_EN_ATD_TYPE_ALL EAT WHERE HP.PARTY_ID = PEE.PERSON_ID AND ENT.ENCUMBRANCE_TYPE = PEE.ENCUMBRANCE_TYPE AND PEE.RESTRICTED_ATTENDANCE_TYPE = EAT.ATTENDANCE_TYPE(+) WITH READ ONLY

View Text - HTML Formatted

SELECT PEE.PERSON_ID PERSON_ID
, PEE.ENCUMBRANCE_TYPE HOLD_TYPE
, PEE.PEN_START_DT HOLD_EFFECTIVE_START_DATE
, PEE.S_ENCMB_EFFECT_TYPE SYSTEM_HOLD_EFFECT_TYPE
, PEE.PEE_START_DT HOLD_EFCT_EFFECTIVE_START_DATE
, PEE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PEE.EXPIRY_DT EXPIRY_DATE
, PEE.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_LOAD
, PEE.COURSE_CD PROGRAM_CODE
, PEE.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, HP.PARTY_NUMBER PERSON_NUMBER
, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION
, '_LA:PEE.S_ENCMB_EFFECT_TYPE:IGS_LOOKUP_VALUES:ENCMB_EFFECT_TYPE:MEANING'
, EAT.DESCRIPTION RESTRICTED_ATTENDANCE_TYP_DESC
, PEE.CREATED_BY
, PEE.CREATION_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_DATE
FROM IGS_PE_PERSENC_EFFCT PEE
, IGS_FI_ENCMB_TYPE_ALL ENT
, HZ_PARTIES HP
, IGS_EN_ATD_TYPE_ALL EAT
WHERE HP.PARTY_ID = PEE.PERSON_ID
AND ENT.ENCUMBRANCE_TYPE = PEE.ENCUMBRANCE_TYPE
AND PEE.RESTRICTED_ATTENDANCE_TYPE = EAT.ATTENDANCE_TYPE(+) WITH READ ONLY