SELECT lookup_code, lookup_type, displayed_field, description from po_lookup_codes where ((lookup_type = 'ACCRUAL TYPE' ) or (lookup_type in ('RCV TRANSACTION TYPE','ACCRUAL WRITE-OFF ACTION', 'SRS ACCRUAL ORDER BY')))
View Text - HTML Formatted
SELECT LOOKUP_CODE , LOOKUP_TYPE , DISPLAYED_FIELD , DESCRIPTION FROM PO_LOOKUP_CODES WHERE ((LOOKUP_TYPE = 'ACCRUAL TYPE' ) OR (LOOKUP_TYPE IN ('RCV TRANSACTION TYPE' , 'ACCRUAL WRITE-OFF ACTION' , 'SRS ACCRUAL ORDER BY')))