VIEW: APPS.IGS_PE_HOLD_REL_OVR_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'