SELECT C.HOLD_LOOKUP_CODE HOLD_LOOKUP_CODE , L.DISPLAYED_FIELD HOLD , L.DESCRIPTION REASON , C.HOLD_TYPE LOOKUP_TYPE , C.USER_RELEASEABLE_FLAG USER_RELEASEABLE_FLAG FROM AP_HOLD_CODES C , AP_LOOKUP_CODES L WHERE C.HOLD_TYPE IN ( 'INVOICE HOLD REASON' , 'VARIANCE HOLD REASON' , 'MATCHING HOLD REASON' , 'INSUFFICIENT FUNDS') AND L.LOOKUP_TYPE = 'HOLD CODE' AND NVL(C.INACTIVE_DATE , SYSDATE + 1) > SYSDATE AND L.LOOKUP_CODE = C.HOLD_LOOKUP_CODE