VIEW: APPS.IGSBV_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', PEE.CREATED_BY, PEE.CREATION_DATE, PEE.LAST_UPDATED_BY, PEE.LAST_UPDATE_DATE FROM IGS_PE_PERSENC_EFFCT PEE, HZ_PARTIES HP, IGS_FI_ENCMB_TYPE_ALL ENT WHERE PEE.PERSON_ID = HP.PARTY_ID AND PEE.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_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'
, PEE.CREATED_BY
, PEE.CREATION_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_DATE
FROM IGS_PE_PERSENC_EFFCT PEE
, HZ_PARTIES HP
, IGS_FI_ENCMB_TYPE_ALL ENT
WHERE PEE.PERSON_ID = HP.PARTY_ID
AND PEE.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE WITH READ ONLY