SELECT wf.assignment_id, wf.ORDER_TYPE_ID , vl.NAME, wf.WF_ITEM_TYPE from oe_workflow_assignments wf, oe_transaction_types_vl vl WHERE wf.order_type_id = vl.transaction_type_id and wf.line_type_id IS NOT NULL
View Text - HTML Formatted
SELECT WF.ASSIGNMENT_ID , WF.ORDER_TYPE_ID , VL.NAME , WF.WF_ITEM_TYPE FROM OE_WORKFLOW_ASSIGNMENTS WF , OE_TRANSACTION_TYPES_VL VL WHERE WF.ORDER_TYPE_ID = VL.TRANSACTION_TYPE_ID AND WF.LINE_TYPE_ID IS NOT NULL