SELECT 'OE', NAME , DESCRIPTION , TRANSACTION_TYPE_ID FROM OE_TRXT_TYPES_NOORGS_VL WHERE NVL(ORDER_CATEGORY_CODE,'ORDER') <> 'RETURN' AND TRANSACTION_TYPE_CODE = 'ORDER'
View Text - HTML Formatted
SELECT 'OE' , NAME , DESCRIPTION , TRANSACTION_TYPE_ID FROM OE_TRXT_TYPES_NOORGS_VL WHERE NVL(ORDER_CATEGORY_CODE , 'ORDER') <> 'RETURN' AND TRANSACTION_TYPE_CODE = 'ORDER'