SELECT C.HOLD_LOOKUP_CODE RELEASE_LOOKUP_CODE , L.DISPLAYED_FIELD RELEASE , L.DESCRIPTION REASON , C.HOLD_TYPE HOLD_TYPE FROM AP_HOLD_CODES C , AP_LOOKUP_CODES L WHERE C.HOLD_TYPE LIKE '%RELEASE%' AND L.LOOKUP_TYPE = 'HOLD CODE' AND NVL(C.INACTIVE_DATE , SYSDATE + 1) > SYSDATE AND L.LOOKUP_CODE = C.HOLD_LOOKUP_CODE