Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes the Hold override or release details |
Implementation/DBA Data: | Not implemented in this database |
SELECT HRO.ROWID ROW_ID
, HRO.HOLD_REL_OVR_ID
, HRO.ELGB_OVERRIDE_ID
, HRO.HOLD_TYPE
, ET.DESCRIPTION
, PE.START_DT
, PE.EXPIRY_DT
, HRO.HOLD_REL_OR_OVR
, HRO.HOLD_OLD_END_DT
, HRO.ACTION_DT
, HRO.CREATED_BY
, HRO.CREATION_DATE
, HRO.LAST_UPDATED_BY
, HRO.LAST_UPDATE_DATE
, HRO.LAST_UPDATE_LOGIN
, PE.EXTERNAL_REFERENCE
, L1.MEANING EXTERNAL_REFERENCE_DESC
FROM IGS_PE_HOLD_REL_OVR HRO
, IGS_FI_ENCMB_TYPE ET
, IGS_PE_PERS_ENCUMB PE
, IGS_EN_ELGB_OVR_ALL OV
, IGS_LOOKUP_VALUES L1
WHERE HRO.HOLD_TYPE = ET.ENCUMBRANCE_TYPE
AND HRO.HOLD_TYPE = PE.ENCUMBRANCE_TYPE
AND ET.ENCUMBRANCE_TYPE = PE.ENCUMBRANCE_TYPE
AND HRO.ELGB_OVERRIDE_ID = OV.ELGB_OVERRIDE_ID
AND OV.PERSON_ID = PE.PERSON_ID
AND PE.START_DT = HRO.START_DATE
AND PE.EXTERNAL_REFERENCE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'PE_EXT_REF'